Question

How to create a Zap that extracts data from Google Sheets and uses browse.ai to scrape the data weekly?

  • 28 July 2023
  • 2 replies
  • 38 views

Userlevel 1

Hello,

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


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @BM-OnlineMarketing 

If you need to iterate over each URL, then you can use the Looping app: https://zapier.com/apps/looping/help

Userlevel 7
Badge +6

Hi there @BM-OnlineMarketing,

Welcome to the Community! 🎉

Here’s my general Zap outline for your desired workflow:

  1. Trigger: Schedule by Zapier - Every Week or Every Month
  2. Action: Google Sheets - Lookup Spreadsheet Row OR Find Many Spreadsheet Rows (With Line Item Support) OR Get Many Spreadsheet Rows (Advanced, With Line Item Support)
  3. Action: Browse AI

Hopefully, this points you to the right direction! 😊