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.

Hello everyone, 

I'm running more than 10 zaps with Google Sheets integrations and the step “Find Spreadsheet Row in Google Sheets” sometimes gives an error “Error 502 (Server Error)!!1”. The 1 is not a typo. It started happening about a month ago in all my 10 zaps. I don't see a pattern when it does/doesn't happen. 

Does anyone know how to fix this, or have ideas of what I could try?

Best,

Caspar

Hey everyone. This is a normal issue with Google Sheets API. The way I handle it on my programs that I create outside of Zapier is to retry again if an error happens by sending a request again. 

 

To do this in Zapier, you can just enable auto replay of errored zaps. This will cause the entire Zap to play again if something happens, like the 502s from Google Sheets. You can enable this for your entire account, or for individual Zaps. If you're not an admin, I'd suggest enabling it for your individual Zap since you might not have permission.

 

https://help.zapier.com/hc/en-us/articles/8496241726989-Replay-Zap-runs#h_01H9KDY333ZEHNDSHKEVVBN61B

 

Autoreplay would only retry any failed steps in a Zap run, instead of the entire zao, which means that if your Zap requires a sequence of fields / updates in the Sheets, this retry wouldn’t work (which is the case for me) :(

 

 

Are you sure? According to the article and the behaviour I've experienced, it auto replays the entire Zap. Not just the failed steps

 

 

yes, from the link here, it mentioned “Zapier will replay all stopped actions in the Zap.”, instead of the entire zap

https://help.zapier.com/hc/en-us/articles/19220226086797-What-is-replay#h_01H9KBC1HMW07HTC6EC7NBTENH

 

Another way to confirm is if you look at the Zap that has auto rerun on in Zap History, you’ll see the step are not running chronologically, as the 502 spreadsheet step would be attempted to run say for instance 5 minutes after the first error, while the other steps which has run already would not be re-run.  

 

 

 

Hi friends,

I have added you all to the open bug report for the 502 error in the Google Sheets integration. While we can’t provide an exact ETA of the bug’s fix. We will keep you updated once the bug is fixed.

I appreciate your patience and understanding.

 @ken.a - I am running into this issue as well. Please add me to this list as well, thank you!

Hi folks 👋

@adam.doogansmith, @morganlbachman, @bethannon, @Lorry Marcoux, @CyrusAY, @Mike Shay, @Dave R, @MBI, @wwolf, @Danielle.PCA, @ChadWV, @IDrankWhat, @John22B, @janraz, @Obed S. and @jkrreed - we’ve ensured that you’re all added to the bug report so you’ll definitely be notified once the issue has been fixed.

As others have already noted here, these “Error 502 (Server Error)!!1” errors are related to an issue on Google’s end which is beyond our control. However, any Zap runs with those errors should go through successfully when they are replayed. If you’re on a paid plan, Autoreplay can be enabled which will automatically retry any Zap steps that errored, though it won’t replay the entire Zap run.

Thanks so much for everyone’s continued patience and understanding on this, it’s much appreciated 🙏🧡

Hi guys!!

Are you facing this error below?

[WinError 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

I think it’s related to google API…

I’m posting here because I know you all have connections with google ;)

Hi @Flavia,

 

Consider posting this error with its thread associated with the error message that you are getting with your Zap.

Reply


Terms & Conditions