How to run a loop in Google Sheets and find row based on status
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
Page 1 / 1
Hi @ToolsGuyÂ
Some options...
GSheets has some options related to finding rows in bulk:
@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.