Column names were updated after the node's setup - Google Sheets

[LePoser]

Describe the problem/error/question

I’m getting this error when i try to use Google Sheets node. Even if i refresh the columns list or create another node, the step still getting error.

What is the error message (if any)?

Column names were updated after the node’s setup

Refresh the columns list in the ‘Column to Match On’ parameter.

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

• n8n version: 1.56.2
• Database (default: SQLite): SQLite
• n8n EXECUTIONS_PROCESS setting (default: own, main): own
• Running n8n via: DOCKER
• Operating system: ubuntu 24.02

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[bartv]

Are the -> characters part of the column names? I wonder if those are causing issues.

Also, a screenshot isn’t really helpful to help us understand the issue - please copy the workflow, click the </> button above and paste in the JSON code so we can see the node setup.

[LePoser]

Thank you for the instructions. You can see the output error message:

{
  "errorMessage": "Column names were updated after the node's setup",
  "errorDescription": "Refresh the columns list in the 'Column to Match On' parameter. Updated columns: data -> , nome -> data, celular -> nome, zap -> , origem -> celular, procedimento 1 -> zap, procedimento 2 -> origem, consultor -> procedimento 1, status -> procedimento 2, objeção -> consultor, dia entrada agenda -> status, plan Agend -> objeção, -- -> dia entrada agenda, data desejada -> plan Agend, data_lembrar -> --, alerta -> data desejada, mês_resg -> data_lembrar, data_resg -> , consultor_resg -> alerta, status resgate -> mês_resg, objeção resgate -> data_resg, anotação resgate -> consultor_resg, status -> status resgate, prazo alerta -> objeção resgate, headers -> anotação resgate, params -> , query -> , body -> , webhookUrl -> , executionMode -> ",
  "errorDetails": {},
  "n8nDetails": {
    "nodeName": "Google Sheets",
    "nodeType": "n8n-nodes-base.googleSheets",
    "nodeVersion": 4.5,
    "resource": "sheet",
    "operation": "appendOrUpdate",
    "time": "29/08/2024, 09:02:54",
    "n8nVersion": "1.56.2 (Self Hosted)",
    "binaryDataMode": "default",
    "stackTrace": [
      "NodeOperationError: Column names were updated after the node's setup",
      "    at checkForSchemaChanges (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Google/Sheet/v2/helpers/GoogleSheets.utils.js:277:15)",
      "    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Google/Sheet/v2/actions/sheet/appendOrUpdate.operation.js:231:56)",
      "    at processTicksAndRejections (node:internal/process/task_queues:95:5)",
      "    at Object.router (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Google/Sheet/v2/actions/router.js:67:23)",
      "    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Google/Sheet/v2/GoogleSheetsV2.node.js:21:16)",
      "    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:728:19)",
      "    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:673:51",
      "    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:1104:20"
    ]
  }
}

[LePoser]

Can you check the error code?

[pachecothiago]

Did you manage to solve it? I’m having the same problem.

[pachecothiago]

I found out the cause of the error.
In my case there was a cell with no content in the header of the Google Sheet.
I entered ‘name_characters’ just to fill the field and it’s working now.