Decipher Sheet ID from Sheet Permalink

Ramsay Zaki · 07/28/22

Is there any way to decipher the Sheet ID from the permalink for the sheet?

Scenario: Sheet automation triggers an alert to a User. Standard Smartsheet automation sends the sheet URL (permalink) in the body. Whenever that user receives the alert I want to trigger an API call back to Smartsheet but I need the Sheet ID for this call. However, the alert body text doesn't contain the Sheet ID.

Genevieve P. · 08/01/22

Hi @Ramsay Zaki

What about using the trigger for the automation as the trigger for the API call, would that be possible?

Ramsay Zaki · 08/15/22

https://community.smartsheet.com/discussion/comment/338215#Comment_338215

Not sure I follow. Can you give me an example?

Genevieve P. · 08/22/22

@Ramsay Zaki

What sends the alert to your user?

For example, is it triggered based on a Date being reached, or a change in the sheet?

If it's a change in the sheet (e.g. Status changes to "Complete"), you could have a Webhook monitoring that sheet for that specific change. This way you would be able to tell what sheet the alert came from.

I will note that it sounds like using one of Smartsheet's Workflows in the UI may be a better way to update that sheet, so you don't need to use API. For example, if the Status changes to "Complete", you could have another workflow triggered by that change to update a different cell with a Change Cell workflow.

Cheers,

Genevieve

Decipher Sheet ID from Sheet Permalink

Answers

Categories