Question

How to run a loop in Google Sheets and find row based on status

  • 4 October 2021
  • 4 replies
  • 874 views

Userlevel 1

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

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

4 replies

Userlevel 7
Badge +14

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.

Userlevel 1

@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!

Userlevel 3
Badge +1

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.