Suddenly appeared this error, saying that can not read the 5th column in Google sheet

Help Activities
, ,
1

Hi Everyone,

I have a project has been working normally for a long time, but today when running suddenly appeared this error, saying that can not read the 5th column, but it has been no data from the 5th column, how can I fix it? Thanks.

The image shows an error message in a blue dialog box stating "Read Range: Cannot find column 5," along with a "Read Range" configuration window for reading a spreadsheet in an automation workflow. (Captioned by AI)
The image shows an error message in a blue dialog box stating "Read Range: Cannot find column 5," along with a "Read Range" configuration window for reading a spreadsheet in an automation workflow. (Captioned by AI)748×562 30.7 KB

2

if you have a defined range - Enter the specific range instead of reading all the sheet

Example - A1: D [LastRow]

For identifying the last row - use below activity

image
image431×256 11.8 KB

Specific to your issue - try restarting studio as well as the file and see if the issue is still there. Also take a copy of the file and delete the rows and columns which are blank and give a try with copied file as well.

1 Like
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.