Read Range: Cannot resolve spreadsheet ID and /or Google service

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