topic Re: Google Sheet Trigger Erroring 403 Forbidden in Workato Pros Discussion Board

Google Sheet Trigger Erroring 403 Forbidden

rachelnatik — Mon, 10 Mar 2025 16:30:18 GMT

Hello,

We have a Recipe that is triggered by a new row added to a Google Spreadsheet. This Recipe has been working well for a long time. It runs on a polling system, in which every 5 minutes Workato checks if there are new rows (this is important!)

Suddenly, on Feb 24 we received a notification from Workato that the Recipe was turned off because of Trigger errors. After some digging, we found the 403 Forbidden Error.

The recipe worked for a google sheet row added at 2/24/2025 15:09:50 but then the recipe trigger fails as of 2/24/2025 15:28:00 so in the span of 20 minutes, it started failing.
NO User Permissions or access has changed.

We tried to stop/start the Recipe several times, and then disconnected the connector and re-authenticated. We then got the recipe to run.

HOWEVER, since then, it continuously errors. So it will be a one off. The trigger will error a few times a day. Now, remember that this is on a polling system. So there are no permissions or access changing at 5 minutes intervals....

And then last Thursday, the Recipe was stopped again due to too many trigger error.

Workato support has so far only told us to check permissions etc.

Our other Google related recipes are working fine. Only those with this connector are affected.

Hoping for some input and solutions!

Re: Google Sheet Trigger Erroring 403 Forbidden

Prudvi — Mon, 10 Mar 2025 17:45:03 GMT

Hi @rachelnatik,
1. You can try creating a new connection and see how is it behaving.
2. Check from Google API if there is any restriction that is causing the issue like API limitation/user.
3. Check if there are other Recipes simultaneously access the Google Sheets.

PS : There could other possible reasons as well.
Regards,
Prudvi

Re: Google Sheet Trigger Erroring 403 Forbidden

rachelnatik — Tue, 11 Mar 2025 13:07:59 GMT

We have other recipes working just fine with Google.

Re: Google Sheet Trigger Erroring 403 Forbidden

Prudvi — Tue, 11 Mar 2025 13:18:38 GMT

Hi @rachelnatik,
Did you try creating a new connection and see how is it behaving.
Regards,
Prudvi

Re: Google Sheet Trigger Erroring 403 Forbidden

ansa — Wed, 12 Mar 2025 15:24:44 GMT

Like @Prudvi suggested, look for race conditions. Is there another recipe or user that has the file open at the same time as this recipe.