Updating GSheet with header starting from row3

[Bill]

I am trying to achieve update the google sheets with headers on row3. Whenever I try to select the column I get the same error column is not found because of the query automatically reads the first row as headers of the columns.

Could you please help me how to start reading and updating referencing row3 as column header. Thank you,

[Tess]

Hi @Bill,

It looks like you need to use A1 notation to skip over the first 2 rows. Here's an example where I am reading everything in the first column, A, starting at the 3rd cell.

[Bill]

Thank you very much Tess. You are a star