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 created a Zap that uses New or Updated Spreadsheet Row from the Google Sheets app. This document is updated daily; there is a process that clears the spreadsheet and adds new rows and it could have up to 100k new rows.


I’m receiving the too much data error message when this happens. Is there a different way to do this? Or is this a product limitation?

Hi @Ops User

Good question.

Google spreadsheets are not optimized for large volumes of information (spreadsheets with around 10,000+ rows), and this can make it a challenge to access them via Zapier.

 

Help: https://help.zapier.com/hc/en-us/articles/8495995099533-Common-Problems-with-Google-Sheets-on-Zapier#interpreting-dates-times-and-timestamps-in-google-sheets-0-9

thanks for the reply @Troy Tessalone, is there a workaround for this?

 

I’m trying to read all thes rows and then update them in Marketo, which after tests, went good. But I can’t make Zapier to read them.

I don’t need this to be on real-time basis, is there a way to read the spreadsheet and load it all on Zapier?

 

Thanks!

@Ops User 

It’s likely that much data in a GSheet will cause issues/errors in the Zaps.

@Ops User 

You’d likely have to use the GSheets API and implement looping logic to iterate thru chunks of data (rows) in the GSheet.

 

I don’t see that option in the GSheets app, it is not included on all plans?

@Ops User 

Available GSheet Zap app triggers/actions: https://developers.google.com/sheets/api/guides/concepts

Terms & Conditions