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”.
When I test it, the Custom expression is not evaluated correctly, resulting in an error.
To me, even though I have selected “Custom expression”, it seems that the action is trying to use the “Option” value, which should be empty / null, and therefore creating a invalid range.
The error displays the range as undefined!A1:B19 instead of 'My Sheet'!A1:B19.
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?