Best answer

Google Sheets - Getting more than 20 rows

  • 13 October 2021
  • 4 replies
  • 933 views

I am trying to setup a scheduled zap that scans a google sheet for rows that contain the current date.  It would then return the customer data in that row.  Was considering using the “Get Many Spreadsheet Rows (Advanced, With Line Item Support)” action.  My issue is that it is very likely my results would return more than 20 rows.  In some cases up to 200+ rows.  Is there a way around this to return more rows?  Are there any other actions I can consider? 

I am debating of taking the leap to do this with mysql but we aren’t there yet.

Thoughts?

icon

Best answer by christina.d 29 October 2022, 02:23

View original

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

4 replies

Userlevel 7
Badge +9

Hi @mattw,

In order to go beyond zapier limitation of 20 rows, you can use Google Sheet API to retrieve array of the rows containing current date. For that you can explore the docs below:

  1. https://zapier.com/blog/add-any-app-to-zapier/ (webhook by zapier section)
  2. https://developers.google.com/sheets/api/guides/values#reading_a_single_range
Userlevel 7
Badge +14

Hi @mattw 

Alternative is to use Airtable: https://zapier.com/apps/airtable/integrations#triggers-and-actions

Airtable has Views: https://support.airtable.com/hc/en-us/articles/202624989-Guide-to-views

Views have Filters. (e.g. Date = TODAY)

Records that flow into Views can trigger Zaps.

Airtable also has an API: https://support.airtable.com/hc/en-us/articles/203313985-Public-REST-API

API can return 100 records per page.

Userlevel 7
Badge +11

I just wanted to pop in here as spotted there’s an existing feature request to increase the amount of results returned with the Google Sheets search actions. I’ve added @mattw’s vote for this feature request. While I can’t give an ETA on when it would be possible to return more than 20 rows we will email as soon as it is. 

In the meantime, the suggestions given by Rob and Troy here would be good workarounds to try! :)

Userlevel 7
Badge +9

Hiii friends! 👋🏽

Swinging by with some good news! 

The “Get Many Spreadsheet Rows” and “Lookup Spreadsheet Rows” Google Sheets search functions now return up to 500 results! 🎉

Yay! Hope this helps ya’ll and happy zapping! 🧡