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 |
+14
Hi
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.
that showed how to use Webhooks to create a loop using Google Sheets, which from initial testing appears to address my main issues.
that showed how to use Webhooks to create a loop using Google Sheets, which from initial testing appears to address my main issues.
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
