Describe the problem/error/question
I am trying to use the Postgres v2 node (Insert or Update / upsert) to sync data from Google Sheets into a Supabase/Postgres table (public.exposure_control).
I want to match existing rows using the Link (and ideally also AFF ID) column(s). The input items already contain Link and AFF ID fields and the table has the same columns (there is also a unique index on ("AFF ID", "Link")).
However, the Insert or Update operation keeps failing with “Column to match on not found in input item”, even when I switch Mapping Column Mode to Map Each Column Manually and explicitly map Link to {{$json["Link"]}} and AFF ID to {{$json["AFF ID"]}}.
What is the error message (if any)?
{
“errorMessage”: “Column to match on not found in input item. Add a column to match on or set the ‘Data Mode’ to ‘Define Below’ to define the value to match on.”,
“errorDetails”: {},
“n8nDetails”: {
“nodeName”: “Insert or update rows in a table”,
“nodeType”: “n8n-nodes-base.postgres”,
“nodeVersion”: 2.6,
“resource”: “database”,
“operation”: “upsert”,
“time”: “04.12.2025, 16:51:46”,
“n8nVersion”: “1.119.1 (Self Hosted)”,
“binaryDataMode”: “default”
}
}
Please share your workflow
Share the output returned by the last node
{
“AFF ID”:
“3728431”,
“Link”:
null,
“GEO”:
“TR”,
“Initial position”:
null,
"Current position ":
null,
“Casino/Betting/Cryptro”:
null,
“Teamlead”:
“ANASTASIA”,
“MANAGER/TEAM”:
“Polly”,
“TL Comment”:
null,
“Position de facto”:
null,
“Check by Traffic Control (date)”:
null,
“DEAL”:
“CPA 100 BL 1”,
“Comments 15.07”:
null,
“Comments November”:
“аппрув, пока нет сайта”,
“Bonus Mentioned (amount, percentage)”:
null,
“Актуальная рефка?”:
null,
“Комменты Ира/Денис”:
null,
“Отправлено в работу?”:
false,
“Исправлено?”:
false
},
{
“AFF ID”:
“3721111”,
“Link”:
“https://www.example.com/en/”,
“GEO”:
“CA\nNZ\r\nDE\nAT\nFR\nFI\nNO”,
“Initial position”:
“2/3”,
"Current position ":
“6”,
“Casino/Betting/Cryptro”:
“Casino”,
“Teamlead”:
“ANASTASIA”,
“MANAGER/TEAM”:
“Lexie”,
“TL Comment”:
null,
“Position de facto”:
“0”,
“Check by Traffic Control (date)”:
null,
“DEAL”:
“50% RS”,
“Comments 15.07”:
null,
“Comments November”:
“в ревью все норм, инфа корректная”,
“Bonus Mentioned (amount, percentage)”:
null,
“Актуальная рефка?”:
null,
“Комменты Ира/Денис”:
null,
“Отправлено в работу?”:
false,
“Исправлено?”:
false
},
Information on your n8n setup
- n8n version:
- Database (default: SQLite):
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app):
- Operating system:
comunity!