About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How to create a Zap that extracts data from Google Sheets and uses browse.ai to scrape the data weekly?
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
  • 36 views
BM-OnlineMarketing
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

ken.a
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! 😊

 

Troy Tessalone
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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions