Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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?

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

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.

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! :)

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! 🧡

Terms & Conditions