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?
Best answer by Troy Tessalone
View original
+14
Hi
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.
thanks for the reply
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!
+14
It’s likely that much data in a GSheet will cause issues/errors in the Zaps.
+14
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?
+14
Available GSheet Zap app triggers/actions: https://developers.google.com/sheets/api/guides/concepts
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
