Question

How do I retrieve over 500 rows daily from a spreadsheet using Zapier's "Lookup spreadsheet rows" function?

  • 20 September 2023
  • 1 reply
  • 107 views

Userlevel 1

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?


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Ryan Tripi 

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.