Problem in node ‘Google Sheets‘ - The column could not be found

[Vi_Hlo]

Describe the problem/error/question

when i press test Node Google Sheets didnt see column
But in filter befor i can choose it

What is the error message (if any)?

The column could not be found

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

• n8n version: - 1.79.3
• Database (default: SQLite): - Postgres
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app): - Railway
• Operating system: Mac OS
  
  
  
  
  

[Alex_Huang]

Can you get the Document and Sheet field directly? or did you fill the blank yourself？As after I select the right Document and Sheet fields , I got a Mapping Column Mode. But I don’t see one in your workflow.

[hrishikesh]

I tested this and ran into the same issue. The solution was to change the format of the column name in Google Sheets to “string”. You can do that by entering the following in the formula bar:

="1"

instead of simply entering 1 in the cell. The former creates a string, the latter creates a number.

[hrishikesh]

Here’s my output:

and the sheet itself:

Column 2 and 3 are still numbers, so they’d run into the same issue.

[hrishikesh]

If this helped, please consider marking it as a solution