{ "error": { "type": "INVALID_VALUE_FOR_COLUMN", "message": "Record must include columns to merge on" } }

Questions
1

Hello I am getting this error can anyone assist thanks
{ “error”: { “type”: “INVALID_VALUE_FOR_COLUMN”, “message”: “Record must include columns to merge on” } }

2

No idea. Please provide more context.
Share your workflow

3

INVALID_VALUE_FOR_COLUMN with “Record must include columns to merge on” comes from the Postgres node when its operation is Insert or Update (upsert): every incoming item has to contain each column you listed under Columns to Match On. Check that field, then confirm the input items actually carry those keys - they are case-sensitive and must be present on every item, not just the first one. A common cause is an upstream Set / Edit Fields node that renames or drops the key before it reaches Postgres. If you only need inserts, switch the operation to Insert so the merge requirement no longer applies. If it still fails, paste the node’s input JSON and the exact column list.

4

The error indicates that an upsert / insert-or-update operation expected one or more merge columns that are missing from at least one incoming item.

The details does not show which node produced it, so we cannot reliably tell whether this is PostgreSQL, Airtable, or another integration yet.

Please share:

  1. The name of the failing node and its selected operation.
  2. The configured Columns to Match On.
  3. One sample input item from the node’s Input panel.
  4. A screenshot of the failing node configuration, with credentials hidden.

In the meantime, verify that every incoming item contains the exact merge-column keys, including capitalization, and that an upstream Set / Edit Fields / Merge / Code node has not removed or renamed them.

If you only need to create new records and do not need upsert behavior, switch to a plain Insert/Create operation.

5

Hi @Zarth, this message comes from Airtable’s upsert API. If you’re using Create or Update, the fields selected under Columns to Match On must also be included in the mapped values sent to Airtable. Selecting a match column alone doesn’t give it a value.

For example, if you match on Email, map that column to the incoming email field and check the expression result for the failing item. Please share that node’s Parameters screen and input JSON so we can see which field is missing.

6

Thanks for coming back to me. I logged in today and executed the workflow and now there does not appear to be an error only issue now is getting the airtable article inbox populated. Wondering whether n8n is the right solution as I’ve spend more time trying to fix stuff. Maybe I expected too much that it would all work 3rd time round.

7

Thanks for coming back to me. I logged in today and executed the workflow successfully now there does not appear to be an error only issue now is getting the airtable article inbox populated.

8

Hi @Zarth,

Zara here from n8n support.

I’m sorry this has been such a slog. Getting a second problem right after fixing the first is really frustrating, and it doesn’t mean you expected too much. This kind of issue is usually small and it’s usually one of these:
1. No items reaching the node: Open the last execution, click the Airtable node, and check whether the Input panel has items. If it’s empty, the cause is upstream.
2. Wrong destination. Check that the base and table are the ones you expect, and that your Airtable view isn’t filtering the new records out.
3. Field names don’t match. They need to match your Airtable columns exactly, including capitalization.
4. Create or Update matching an existing record. If the match column has the same value each time, it updates that record instead of adding a new one.
5. Token scopes. Your Airtable access token needs permission to read the schema and write records.

We would also suggest having a read for our docs for the node: Airtable | Nodes | n8n Docs

If you are still stuck, please email help@n8n.io with your workflow and the execution logs, and the team can take a closer look.

Zara
(n8n Support)