Hi,
I am currently getting multiple values from google sheets, and running a loop action after that. Currently I am only able to query on one or two google sheets columns, however I would like to query on more columns, any one know how to do that?
My get around to this currently is using a filter after retrieving multiple rows. This however causes inefficiency in my zap due to multiple iterations that are being always filtered.
Best answer by Troy Tessalone
Hi
Keep in mind that GSheets via Zaps has a limit to 10/20 returned rows max depending on the action being used.
If you’re trying to use GSheets, one workaround is to use another Tab with formulas (FILTER/QUERY) that return results from the master list of rows.
Another option is to use an operational database app instead of GSheets, such as Airtable which has advanced querying capabilities for a single row.
Airtable also has APIs that can be leveraged to returned up to 100 results per page.
Airtable: https://zapier.com/apps/airtable/integrations
+14Hi
Keep in mind that GSheets via Zaps has a limit to 10/20 returned rows max depending on the action being used.
If you’re trying to use GSheets, one workaround is to use another Tab with formulas (FILTER/QUERY) that return results from the master list of rows.
Another option is to use an operational database app instead of GSheets, such as Airtable which has advanced querying capabilities for a single row.
Airtable also has APIs that can be leveraged to returned up to 100 results per page.
Airtable: https://zapier.com/apps/airtable/integrations
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
