UNABLE TO GET DATA FROM GOOGLE SHEET - ERROR: ENSURE THAT HEADERS ARE AVAILBLE

[susheel91]

i am unable to pull data from my Google Sheet.

A response result error comes saying that - Ensure that, headers are availabled for each column of your sheet.

PLEASE HELP

 

[Pabbly]

You need to make sure that your Google Sheet as a header row as shown here for example -

 

[susheel91]

I already have headers: Please see the below image:

 

[Pabblymember11]

Hey @susheel91

If you are having any conditional formatting or any kind of validation kindly try to avoid such things from your Sheet and check if you have inserted any small data out of the range of the rows.