Zapier automation no longer working with Smartsheet (all of a sudden)

Clinton W

Hi all,

It's a week of things all of a sudden not working after 6 months of a Zap automation working it's just stopped today. On Zapiers end i've contacted their support and we've troubleshot everything, it's all good on their end.

I have a custom Zap that when some data is makes it's way to a certain point in the Zapier automation it is to be pushed into a Smartsheet just in 4 cells (it finds the row by matching a certain cell).

However, now it gets this error:
An error occurred while running action 151197: Code runner error while running code: Got upstream error: status=403 body={"Message":"Forbidden"} Will retry... Got upstream error: status=403 body={"Message":"Forbidden"} Will retry... Got upstream erro

Which seems like it's blocked from access the sheet via the API. HOWEVER, i have another Zapier automation that creates a brand new row in this very same Smartsheet and it still works perfectly. So Zapier can still still talk to Smartsheet properly in this instance.

Is there anything anyone can recommend trying from the Smartsheet end given one Zap works and one doesn't?

Thanks

kowal

hi @Clinton W,

i hope this is a temporary problem and not a permanent issue. A lot of my customers are using zapier to add data to smartsheet.

Georgie

Hi @Clinton W,

That does seem like strange behaviour. I’d recommend posting your question in the Smartsheet API Community. If you’re still unable to reach a resolution, I’d then reach out to our Support team so that they can investigate what might be causing this issue. 

Thanks, 

Georgie

kowal

hi @Clinton W,

Yesterda I checked my Zapier to Smartsheet solution and it worked without any interruptions.

One of my client is using Excel New Row to Smartsheet New Row connection and it was still working. Can you check if this is really Smartsheet doing something?

Clinton W

Thanks for the comments all. I actually have a Zap that still works as a Smartsheet New Row. But this other Zap has just stopped completely. I'll investigate further given no immediate answers.