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

Article: https://zapier.com/help/doc/common-problems-google-sheets-zapier#sslerror-the-read-operation-timed-out

 

Thank you for your response, I looked into the article.

I need the data to be eventually imported into google sheets because that is where I have everything set up in. That being said I tried to import that data into an airtable database, which I’d sync with a spreadsheet. Then I came across a new problem, I don’t believe zapier has an integration that allows multiple airtable records to be created at once. I need a couple hundred new records to be created at once. Rather than doing that, it seems the API will only allow one new record to be created (which then the couple hundred rows are all combined into a single cell, with data separated by commas).

 

How can I set up airtable so that the data is imported correctly in there? MySQL seems more complicated and expensive than what I need.

Zapier in most cases really isn't meant to do bulk actions of 100s of records, rather 1 record at a time.

Otherwise, you’d have to create a looping/iterating Zap.

Zapier in most cases really isn't meant to do bulk actions of 100s of records, rather 1 record at a time.

Otherwise, you’d have to create a looping/iterating Zap.

Sounds like a shortcoming of zapier/airtable integration. In google sheets you are able to add/edit multiple rows in a single zap. I will figure out an alternate solution

Issue fixed

Ended up fixing by having the data be combined into a single row then imported into a google sheet with a delimiter to separate values. That way the sheet that needs to be accessed by the API is tiny, then I imported data from that into a larger spreadsheet where I used a bunch of functions to separate out all the values and put them back in the correct place.

Terms & Conditions