Question

Google sheet error: Trigger partner failure

  • 10 April 2023
  • 3 replies
  • 42 views

We use Zapier with google sheet, but recently we’ve got those error message

 

Could you please explain what this error means, and how can we solve this?

Thanks!


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +6

Hey there @Yong,

Welcome to the Community! 🎉

Before we dig deeper into this, could you please send a screenshot of the error message you’ve received? Please don’t include/blur out any personal information in the screenshot.

Thanks! 😊

Hi @ken.a thanks for answer!

 

So the error message is about Google sheets trigger,

‘Trigger partner failure: This usually happens when the Zap does not receive a response from Google Sheets within 30 seconds confirming we could access the spreadsheet data successfully’

 

Would you please help that how can I fix this issue?

Userlevel 7
Badge +11

Thanks for sharing that helpful screenshot of the error here, @Yong!

That type of error can occur when there’s an outage or temporary issue on the partner app’s side that’s preventing the Zap from accessing the app. Usually these type of issues are short-lived and the app will be able to trigger on any missed items the next time the Zap is able to successfully connect to the app, in this case Google Sheets.

But if it’s continually not able to trigger then it could be that there’s been a change made to the connected spreadsheet (like renaming it for example) that has caused a disconnect between the Zap and the spreadsheet. We have a guide on the types of changes that can cause issues: The Google Sheets trigger on my Zap stopped working

If that’s the case, you’ll want to turn the Zap off, reselect the spreadsheet and turn it back on again to refresh the connection between the spreadsheet and the Zap.

Hopefully that’ll help to fix it. Please do keep us informed on how you’re getting on with this, keen to help get this sorted!