Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Is there a way to have Zapier go though the contents of a Google Sheet (example below) and find all of the rows with the Status of Active and run a series of actions with the other values found on those rows?

 

Alphanumeric Numeric Status Source
ABC234111 3232038 Active Internet
ABC234795 3231771 Active Phone
ABC234355 3229880 Inactive Internet
ABC234113 3232031 Active Internet
ABC234114 3232030 Active Internet
ABC234112 3232029 Inactive Internet

Hi @ToolsGuy 

Some options...

GSheets has some options related to finding rows in bulk:

 

Once you have the line items, you can use the Looping app: https://zapier.com/apps/looping/integrations

 

NOTE: If you have more than 10 rows, you’ll have to build in advanced iteration logic to find all the matching rows.

 

###

 

May be better to consider using Airtable instead of GSheets.

Airtable: https://zapier.com/apps/airtable/integrations#triggers-and-actions

Airtable has an API that can be used in Zaps: https://support.airtable.com/hc/en-us/articles/203313985-Public-REST-API

Airtable can return up to 100 records per page.

@Troy Tessalone, thank you.  That’s very interesting about Airtable, will defiantly have to take a look at it in the very near future.  For my conundrum with Google Sheets, I found a video at  

that showed how to use Webhooks to create a loop using Google Sheets, which from initial testing appears to address my main issues.

@Troy Tessalone, thank you.  That’s very interesting about Airtable, will defiantly have to take a look at it in the very near future.  For my conundrum with Google Sheets, I found a video at  

that showed how to use Webhooks to create a loop using Google Sheets, which from initial testing appears to address my main issues.

@ToolsGuy - Thanks for sharing that YouTube video. It helped me utilize a webhook for the first time!

Since Looping is still in beta, you might consider another approach - if you feed a step an array rather than the usual output object, Zapier will automatically loop through the array. If you need to pass multiple values to each iteration, then just create an array of JSON-encoded objects. Each iteration will get a JSON string which it can then decode to act on all of the included values.

Terms & Conditions