Hi,
I’ve been trying to create an automation that updates data in google sheets, however whenever I want to make an update, I get the following error:
The ‘Column to Match On’ parameter is required.
Despite the fact that the parameter is set. What can I do in such case? is it a bug?
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:
What happens if you remove the special characters (brackets [ ], and ampersand &) from the value in the header cell? I don’t know if that’s what is causing the trouble, but it would probably help whoever can look “under the covers” to know if this makes a difference.
Are you sure you’re first item doesn’t have a null value for the “Id T&M” field?
Had a minute to set up a test. It’s definitely the brackets that break things. The ampersand seems ok.
Test Table
Test Workflow
2 Likes
Afternoon,
We are tracking this internally as NODE-2482 it was also reported to GitHub a few days back but hopefully this will be fixed very soon.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
New version [email protected] got released which includes the GitHub PR 13589.