Since 1.50.1 update Google sheet node works incorrectly

Questions
1

Hey there,

After today’s update to version 1.50.1, my Google Sheet workflow started malfunctioning. The “Append row” operation no longer uses the “Keys” as column names it creates table without column names.

Information on your n8n setup

  • **n8n version: 1.50.1
  • **Database (default: SQLite): Postgres
  • **n8n EXECUTIONS_PROCESS setting (default: own, main): queue mode
  • **Running n8n via: Docker
  • **Operating system:Linux
2

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:
3

Do you know what version you were on before the upgrade? that could help narrow down the change causing this issue.

4

@netroy That was prevues one 1.49.1

5

@netroy The fix made in the 1.50.0 release

  • Google Sheets Node: Append fails if cells have some default values added by data validation rules (#9950) (d1821eb)

is probably causing the behaviour I am experiencing.

6

Yeah, I’ve already asked internally to have a look at that PR again.

7

New version n8n@1.53.0 got released which includes the GitHub PR 10200.