X
So you're looking for help with automation? Leave us your details below and we'll get back to you shortly to discuss.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Fixing common Google Sheets errors on Zapier

Want a cheaper, easier alternative to Zapier? Try Make (1 month of Pro free!)

If you're getting errors while building zaps with Google Sheets, here's how to fix them.

Zapier integrates with Google Sheets, probably one of the best-known apps in the world and what many millions of people and businesses worldwide use as their primary spreadsheet.

If you're having issues, the first place to check is Zapier's help page for Google Sheets, or contact their support (which is 24/7). Alternatively, you can book a call with us to get help.

In this guide, we're going to summarise some common errors and issues and what you can do about them.

Want more automation resources sent to your inbox? Join our newsletter.

1. "ExternalHTTPSConnectionPool(host='sheets.googleapis.com', port=443): Read timed out. (read timeout=39)"

When an action step runs, behind the scenes Zapier calls the target app's API to send data. Zapier will then wait for up to 30 seconds for a reply message from the API with data and/or a success message. If, after 30 seconds, Zapier does not get a response, it assumes there has been an issue with Google Sheets and shows this error (or a similar one).

One thing to keep in mind is that even though Zapier got no response from Google Sheets, if the error occurred on a "Create/Update Spreadsheet Row" step then the row may still have been created/updated.

Check out our detailed guide about timeout errors in Zapier.

Need the help of an automation expert? Contact us now.

February 21, 2020
Need an automation expert?
Tell us what you need and we'll get to work.
Hire Us

Want to do something like this in your business?

We'd love to talk to you about your business and how automation could transform your business.  Just tell us what you need and we'll get back to you within a few hours.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.