I am using a zap that adds and edits new rows to my google spreadsheet. It runs once a day, and grabs data from social media posts.
I started getting this error daily:
“Google Sheets: The read operation timed out. This usually happens because your spreadsheet is too big. Consider starting a new spreadsheet with less data. Or, consider turning OFF any Zaps that use this spreadsheet, delete any unnecessary rows or columns from the spreadsheet, then turn the affected Zaps back ON.”
To make the sheet size as small as possible, I made a new spreadsheet file and only imported data absolutely necessary and deleted extra rows/columns
It currently has 5 columns and about 5,000 rows, and I am already getting the same error again. (only a coulple days worth of data, I need to store atleast a month worth of data, preferably more) Surely there has to be a way around this, 5000 rows is not even that significant of a number. Is there a defined limit?
Please let me know if there is any work arounds
Best answer by mindbizView original