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.

@hm_tan

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.

@hm_tan,

If you always use the same spreadsheet, put in spreadsheet ID the ID of your spreadsheet between “”,and try if works