Getting error in Read range when using Gsuite API

For example i can read two columns but can’t till read third column.

Error message is - Read Range: Cannot find column 3.

image

image

Hi @sathish_Kumar6

There is no column as column 3 name. Check the Google sheet and give the name of third column.

Or there is no column exist.

Hope it helps!!

1 Like

i have data in the third column but it doesn’t have header so should i put header name for third column or is there anything we can do?

@sathish_Kumar6

Read the data with has header unchecked and then after read you can add headers as you need and also inplace of blanks can add some value or remove those columns if not needed further

Or else you have to add a header in sheet itself

Cheers

1 Like

Okay @sathish_Kumar6

Then if you want to read the specific column give the range. For ex if you want to read column give range “D:D”

Note - In the read range uncheck the headers option.
Or if you can add column manually try to add column.

Hope it works!!

1 Like

Its working thanks @mkankatala

1 Like

its working thanks @Anil_G

1 Like

Hi @sathish_Kumar6
Read the data table by unchecking the add headers
Or
You can read by specifying the range of the columns which you want to read. For example “A:D”

Hope it helps!!

1 Like

thanks for the response s it is working now

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