Hello. I am trying to get the file and read range. However, this error occured, not too sure how to solve it.
Please check your SpreadsheetID is correct or not.
In debug it showing strField as “” though you assigned value to strField.
And also please check your Google Service credentials.
If you always use the same spreadsheet, put in spreadsheet ID the ID of your spreadsheet between “”,and try if works
Hello,
I was having this same error when I tried to run my workflow from Orchestrator (after running it successfully from Studio on my development machine). Because my automation runs under another Google account in production I went on at scrutinizing (for long hours) all my Google permission setup on the spreadsheet I was updating. But there was nothing wrong there.
It turns out the error was that my workflow uses the spreadsheet ID as an argument, which is initialized in the code but in Orchestrator I was not initializing its value as an argument in its corresponding process. After I fixed this everything ran as expected.
Hope this can help someone with similar problem.
ashokkarale
lrtetala
ppr
Yoichi
SorenB
alper_ozyurt
chauhan.rachita30
Phanvi99
torontothomas135