we want to Extract Data with browse.ai from our website. We have a list of Product Names with corresponding Search URLs and want to check weekly if the products are Online and what the current price is.
The Zap should look something like this:
Trigger: Every Monday at 8 am
Action: Get URLs from Google Spreadsheet
Action: Get those URLs to browse.ai and scrape the data
What we have Working and what is still needed:
We have the Task in Browse.ai set up and working. Insert the URL and it returns the Info we need to the Spreadsheet. Basically we just need to get the URLs from the Spreadsheet and insert them as the Origin URL in Browse.ai each Week.
Problems we run into:
The Spreadsheet is only updated once a month(Products in the campaign change once per month). So the spreadsheet is more or less static and it’s roughly 100 rows.
We cannot do it over the Browse.ai Monitor since there would be 100 URLs we would have to change manually each month.
Right now we have one zap set up: the Task runs everytime a Spreadsheet Row is added or an existing row is updated. and it’s working. We just can’t get it on a schedule