Respected Client,
Thank you for considering Apify for your web scraping and data management needs. We understand that you require a solution to import data from Ultimate Walmart Scraper actor to your Google Sheet, and to update the data twice a day automatically.
We propose using Apify's Google Sheets Import & Export actor to import the data to your Google Sheet. Additionally, we can create an automation script that runs the Apify actor twice a day, and replace the old data with the new data on the same sheet.
However, we understand that the API url for the Ultimate Walmart Scraper actor changes every time it is run on Apify. To address this, we can create a custom Apify actor that extracts the data from Ultimate Walmart Scraper actor, and outputs it to a fixed API url that can be used by the Google Sheets Import & Export actor.
Once the data is imported into your Google Sheet, we can also create a formula using Google Sheets' built-in functions such as importxml, importdata, or importhtml to move the required columns to different sheets.
To provide you with step-by-step instructions, we can create a video tutorial or a detailed text guide on how to set up the Apify actor, configure the Google Sheets Import & Export actor, and create the required formulas in your Google Sheet.
Please let us know if you have any further questions or concerns. We are looking forward to working with you to develop a solution that meets your needs.
Best Regards,
Usama.