We need a zap that will pull at least 600 rows from a spreadsheet on a daily basis, but the “Lookup spreadsheet rows” can only pull a maximum of 500.
Is there a way to pull more? Perhaps using an additional step, or some coding?
Question
How do I retrieve over 500 rows daily from a spreadsheet using Zapier's "Lookup spreadsheet rows" function?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Good question.
You’ll need to use the GSheets API: https://developers.google.com/sheets/api/guides/concepts
NOTE: If you need to do iterations, the Looping app has a max of 500 iterations.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.