This topic was automatically generated from Slack. You can find the original thread here.
“Worksheet Id” evaluates to null when using “custom expression”
In the first screenshot is my configuration for an action that should update a range in my Google Sheets file.
I selected both the “Google Sheets Account” and “Spreadsheet” fields from the “Select an option” tab
For the “Worksheet Id” I have entered a “Custom expression” which is value from a previous “Export Variables” action. In this case, it’s “‘My Sheet’” (with single quotes added manually)
I did NOT select the Worksheet from the “Options”.
(see image 1)
When I test it, the Custom expression is not evaluated correctly, resulting in an error.
I feel like, even though I have selected “Custom expression”, the action is trying to use the “Option” value, which is empty / null, and therefore creating a invalid range…
The error displays the range as undefined!A1:B19 instead of 'My Sheet'!A1:B19.
This also happens, if I hard-code the Worksheet Id (type it instead of an expression)
(see image 2)
You can see that the “Worksheet Id” is displayed correctly in the “Inputs” tab but it is not being used in the action…
The Action is “Google Sheets - Update Multiple Rows”
Any help in this situation?
P.s.: I tried posting directly to the forums but it got stuck waiting for a review, so I’m reposting here
