Upsert Records in Airtable
n8n-nodes-base.httpRequest
Create or update records in Airtable based on matching field values. If a record matches, it's updated; otherwise, a new record is created.
💡 Use Cases
- Sync data without duplicates
- Update existing or create new records
- Maintain data consistency across systems
📚 API Documentation
Reference documentation for this API endpoint:
🔗 https://airtable.com/developers/web/api/update-multiple-records ↗📋 Node Configuration
{
"nodes": [
{
"parameters": {
"content": "## 🔄 Upsert Records in Airtable\n\n**Usage:**\nCreate or update records based on matching fields. Updates existing records or creates new ones.\n\n**Required Input:**\n- `baseId`: Your Airtable base ID (starts with 'app')\n- `tableIdOrName`: Table ID or name\n- `records`: Array of records with fields\n- `fieldsToMergeOn`: Field(s) to match records on\n\n**Request Body Format:**\n```json\n{\n \"performUpsert\": {\n \"fieldsToMergeOn\": [\"Email\"]\n },\n \"records\": [\n { \"fields\": { \"Email\": \"a@b.com\", \"Name\": \"Test\" } }\n ]\n}\n```\n\n**Merge Fields:**\n- Up to 3 fields\n- Must be: text, number, date, or select\n\n**Setup:**\n1. Create HTTP Header Auth credential\n2. Set Name: `Authorization`\n3. Set Value: `Bearer YOUR_PERSONAL_ACCESS_TOKEN`\n\n**Output:**\nReturns records with createdRecords and updatedRecords arrays",
"height": 238,
"width": 389,
"color": 4
},
"type": "n8n-nodes-base.stickyNote",
"position": [
96,
332
],
"typeVersion": 1,
"id": "sticky-airtable-upsert",
"name": "Sticky Note"
},
{
"parameters": {
"method": "PATCH",
"url": "=https://api.airtable.com/v0/{{ $json.baseId }}/{{ $json.tableIdOrName }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"performUpsert\": {\n \"fieldsToMergeOn\": [\"{{ $json.mergeField }}\"]\n },\n \"records\": [\n {\n \"fields\": {\n \"{{ $json.mergeField }}\": \"{{ $json.mergeValue }}\",\n \"Name\": \"{{ $json.name }}\",\n \"Status\": \"{{ $json.status }}\"\n }\n }\n ],\n \"typecast\": true\n}",
"options": {}
},
"id": "airtable-upsert-node",
"name": "Upsert Airtable Records",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
368,
400
],
"credentials": {
"httpHeaderAuth": {
"id": "airtable-header-auth",
"name": "Airtable Header Auth"
}
}
}
],
"connections": {},
"pinData": {},
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "airtable-flowkit-instance"
}
}
[
{
"id": "b5a18eb3-3925-41ba-9062-26b6c9c6517f",
"meta": {
"name": "API Call Node",
"id": "api-call",
"icon": {
"svg": "
{
"subflows": [
{
"flow": [
{
"id": 813,
"module": "http:ActionSendDataBasicAuth",
"version": 3,
"parameters": {
"key": "ANONYMIZED_CREDENTIALS",
"handleErrors": false,
"useNewZLibDeCompress": true
},
"mapper": {
"ca": "",
"qs": [],
"url": "https://api.airtable.com/v0/{{1.baseId}}/{{1.tableIdOrName}}",
"data": "{\n \"performUpsert\": {\n \"fieldsToMergeOn\": [{{1.mergeField}}]\n },\n \"records\": [\n {\n \"fields\": {\n {{1.mergeField}}: {{1.mergeValue}},\n \"Name\": {{1.name}},\n \"Status\": {{1.status}}\n }\n }\n ],\n \"typecast\": true\n}",
"gzip": true,
"method": "patch",
"headers": [
{
"name": "Content-Type",
"value": "application/json"
},
{
"name": "Authorization",
"value": "Bearer {{ANONYMIZED_TOKEN}}"
}
],
"timeout": "",
"useMtls": false,
"bodyType": "raw",
"contentType": "application/json",
"serializeUrl": false,
"shareCookies": false,
"parseResponse": true,
"followRedirect": true,
"useQuerystring": false,
"followAllRedirects": false,
"rejectUnauthorized": true
},
"metadata": {
"designer": {
"x": 300,
"y": 300,
"name": "Upsert Records in Airtable"
},
"restore": {
"expect": {
"qs": {
"mode": "chose",
"items": []
},
"method": {
"mode": "chose",
"label": "PATCH"
},
"headers": {
"mode": "chose",
"items": [
null,
null
]
},
"bodyType": {
"label": "Raw"
},
"contentType": {
"label": "JSON (application/json)"
}
},
"parameters": {
"key": {
"label": "ANONYMIZED_CREDENTIALS"
}
}
},
"parameters": [
{
"name": "key",
"type": "keychain:basicauth",
"label": "Credentials",
"required": true
},
{
"name": "handleErrors",
"type": "boolean",
"label": "Evaluate all states as errors (except for 2xx and 3xx )",
"required": true
},
{
"name": "useNewZLibDeCompress",
"type": "hidden"
}
],
"expect": [
{
"name": "url",
"type": "url",
"label": "URL",
"required": true
},
{
"name": "serializeUrl",
"type": "boolean",
"label": "Serialize URL",
"required": true
},
{
"name": "method",
"type": "select",
"label": "Method",
"required": true,
"validate": {
"enum": [
"get",
"head",
"post",
"put",
"patch",
"delete",
"options"
]
}
},
{
"name": "headers",
"spec": [
{
"name": "name",
"type": "text",
"label": "Name",
"required": true
},
{
"name": "value",
"type": "text",
"label": "Value"
}
],
"type": "array",
"label": "Headers"
},
{
"name": "qs",
"spec": [
{
"name": "name",
"type": "text",
"label": "Name",
"required": true
},
{
"name": "value",
"type": "text",
"label": "Value"
}
],
"type": "array",
"label": "Query String"
},
{
"name": "bodyType",
"type": "select",
"label": "Body type",
"validate": {
"enum": [
"raw",
"x_www_form_urlencoded",
"multipart_form_data"
]
}
},
{
"name": "parseResponse",
"type": "boolean",
"label": "Parse response",
"required": true
},
{
"name": "contentType",
"type": "select",
"label": "Content type",
"validate": {
"enum": [
"text/plain",
"application/json",
"application/xml",
"text/xml",
"text/html",
"custom"
]
}
},
{
"name": "data",
"type": "buffer",
"label": "Request content"
}
]
}
}
]
}
],
"metadata": {
"version": 1
}
}