Smartsheet API POST Request for Google Sheets

Hello! I’m new to Postman and the exciting world of API so please bear with me if some of my language doesn’t quite make sense :slightly_smiling_face: . I’m attempting to create a POST request that would signal my webhook in Google sheets to trigger every time a row is added or updated one of my Smartsheets. I’ve verified the webhook is active and the Smartsheet ID is correct but no matter what I do, it returns the error code “1008.”

Any trouble shooting advice would be greatly appreciated! Thank you in advance!!

Based on this discussion, I think it might have to do with the events you have defined.

Maybe try switching from events: ["ROW_ADDED", "ROW_UPDATED"], you switch to events: ["*.*"] and see if that works. If that works, maybe start working backwards from there to see how you can safely change the event types.

Thank you Allen! That worked!! :tada:

However, my Google Sheet is still not reflecting a change when I update my Smartsheet. Would you know if this is because I need to define my event types? Or do I need to work on my Google Aps Script? Is there a way to easily determine why it’s not updating?

Are you sure the webhook is firing? At this point, I’d assume anything remaining that isn’t working is going to be script related. You could add some logs in there to see what is happening and if it’s running at all.

Let me know if you need assistance with that!

Upon doing some digging, I might not have the webhook application enabled on my Smartsheet account. I am looking into that and I’ll go from there. Thank you for you offer to help! If needed, I might take you up on that!

1 Like