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

  • 28 July 2023
  • 2 replies

Userlevel 1


we want to Extract Data with 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 and scrape the data

What we have Working and what is still needed:
We have the Task in 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 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 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 +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! 😊


Userlevel 7
Badge +14

Hi @BM-OnlineMarketing 

If you need to iterate over each URL, then you can use the Looping app: