I’m running a daily Zap that uses API Request in Google Sheets and is getting up to 70,000 results.
Is there a Zapier tool that would let me split it into small batches (around 300 records per batch) and run it until all records are being sent (to Marketo)?
+14
Hi
Good question.
Fetching that much data in a Zap step likely will go above the Zap step data size limits.
For us to have more context, how is your GSheet API Request Zap step configured? (screenshots)
Hi
+14
GSheets API endpoint to reference for setting ranges: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/batchGet
GSheets API endpoint to reference for setting ranges: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/batchGet
Thank you! How can I create a loop that reads the first range, then the next, and so on until it finishes all the rows?
+14
You’ll have to implement logic (likely with a Code step) to increment the range values and determine the # of rows returned to further determine if the looping should continue to happen.
May offer guidance about how to create a looping Zap with webhooks:
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
