Hello,
I’m trying to dynamically reference a google sheet. I have a webhook trigger that receives the ID of the sheet. I’m then trying to pass the path to that ID as a custom expression to the Spreadsheet input field of the Sheets action.
Here’s the path: {{steps.trigger.event.body.sheet_id}}
Unfortunately, this doesn’t work because when I go to select the Sheet Name, I get “Requested entity was not found.” However, when I manually enter in the ID as a custom expression it works. Not sure why the path and the manually entered ID aren’t equivalent.
Any thoughts? The sheet ID from the trigger is a string.