Sr_Sr
February 6, 2026, 10:42am
1
Hello,
I am currently using n8n cloud (last version) and I am facing the same issue described here:
It makes impossible to use the workflow for multiple sheets. In my case, the sheetId is dynamic and passed as an argument into the workflow, so the same workflow is used to write rows in different sheets with different schemas.
I expected that “Map Automatically” means that it reads the columns of the sheet during runtime, but as I see now, it caches them during build time and tries to reuse whatever cached schema independently of the actual sheet referenced by sheetId.
Hope it will be fixed s…
I managed to fix it with the same solution, downgrading the typeVersion from 4.7 to 3.
“type”: “n8n-nodes-base.googleSheets”,
I still dont understand why 4.7 works like that while the Version 3 have no issues with this. If is an intended feature, could you add (at least) a tick like “ignore updates”?
Anyone facing the same issue or know if this is under development or with an opened issue?
Thanks!
This is by-design in v4.x for better editor UX. Workarounds:
Use “Map Each Column Manually” with expressions.
Use typeVersion 3 which reads columns at runtime.
Use an HTTP Request node to call the Sheets API directly for full dynamic control.