David Olusola This workflow corresponds to n8n.io template #5509 — we link there as the canonical source.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "nNmc3DeecTU28eVM",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Airtable MCP",
"tags": [],
"nodes": [
{
"id": "57d9bacd-3ff4-48b3-a253-f47cc8fde5ab",
"name": "MCP Server Trigger",
"type": "@n8n/n8n-nodes-langchain.mcpTrigger",
"position": [
780,
120
],
"parameters": {
"path": "your-webhook-path-here"
},
"typeVersion": 1.1
},
{
"id": "5e1eb7f9-a1c7-44fc-acb2-38ea6b407896",
"name": "Get Record",
"type": "n8n-nodes-base.airtableTool",
"position": [
720,
380
],
"parameters": {
"id": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Record_ID', ``, 'string') }}",
"base": {
"__rl": true,
"mode": "list",
"value": "YOUR_AIRTABLE_BASE_ID",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID",
"cachedResultName": "contacts"
},
"table": {
"__rl": true,
"mode": "list",
"value": "YOUR_AIRTABLE_TABLE_ID",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID/YOUR_AIRTABLE_TABLE_ID",
"cachedResultName": "contact data"
},
"options": {}
},
"typeVersion": 2.1
},
{
"id": "6226cd66-19b5-4751-8db9-d0f45f017292",
"name": "Create Record",
"type": "n8n-nodes-base.airtableTool",
"position": [
860,
580
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "YOUR_AIRTABLE_BASE_ID",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID",
"cachedResultName": "contacts"
},
"table": {
"__rl": true,
"mode": "list",
"value": "YOUR_AIRTABLE_TABLE_ID",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID/YOUR_AIRTABLE_TABLE_ID",
"cachedResultName": "contact data"
},
"columns": {
"value": {
"Name": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Name', ``, 'string') }}",
"email": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('email', ``, 'string') }}",
"Assignee": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Assignee', ``, 'string') }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Assignee",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Assignee",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "options",
"display": true,
"options": [
{
"name": "Todo",
"value": "Todo"
},
{
"name": "In progress",
"value": "In progress"
},
{
"name": "Done",
"value": "Done"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"typeVersion": 2.1
},
{
"id": "a6ec7651-1953-4c92-8a51-21f9c130df0c",
"name": "Delete Record",
"type": "n8n-nodes-base.airtableTool",
"position": [
1200,
360
],
"parameters": {
"id": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Record_ID', ``, 'string') }}",
"base": {
"__rl": true,
"mode": "list",
"value": "YOUR_AIRTABLE_BASE_ID",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID",
"cachedResultName": "contacts"
},
"table": {
"__rl": true,
"mode": "list",
"value": "YOUR_AIRTABLE_TABLE_ID",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID/YOUR_AIRTABLE_TABLE_ID",
"cachedResultName": "contact data"
},
"operation": "deleteRecord"
},
"typeVersion": 2.1
},
{
"id": "303338ab-02c7-45ed-9978-31e254c9d34b",
"name": "Search Record",
"type": "n8n-nodes-base.airtableTool",
"position": [
1060,
520
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "YOUR_AIRTABLE_BASE_ID",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID",
"cachedResultName": "contacts"
},
"table": {
"__rl": true,
"mode": "list",
"value": "YOUR_AIRTABLE_TABLE_ID",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID/YOUR_AIRTABLE_TABLE_ID",
"cachedResultName": "contact data"
},
"options": {},
"operation": "search",
"filterByFormula": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Filter_By_Formula', ``, 'string') }}"
},
"typeVersion": 2.1
},
{
"id": "39d9b303-de3f-4af4-a464-26be930dda40",
"name": "MCP Trigger Info",
"type": "n8n-nodes-base.stickyNote",
"position": [
560,
20
],
"parameters": {
"color": null,
"height": 260,
"content": "\ud83d\ude80 **MCP TRIGGER**\n**AUTHOR DAVID OLUSOLA**\n\nThis is the entry point for AI interactions. When an AI assistant needs to manage contacts, it triggers this workflow through the Model Context Protocol (MCP).\n\n**Function**: Receives AI requests and routes them to appropriate Airtable operations."
},
"typeVersion": 1
},
{
"id": "2acfe724-42c5-4dd7-af33-47710e57b5b1",
"name": "Get Record Info",
"type": "n8n-nodes-base.stickyNote",
"position": [
500,
340
],
"parameters": {
"color": null,
"width": 220,
"height": 140,
"content": "\ud83d\udd0d **GET RECORD**\n\nRetrieves a specific contact record from Airtable using the Record ID.\n\n**Input**: Record_ID from AI\n**Output**: Complete contact details\n**Use Case**: \"Show me details for contact ID xyz\""
},
"typeVersion": 1
},
{
"id": "f5b8fc28-da04-476c-ab9c-28b9019e73b5",
"name": "Create Record Info",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
620
],
"parameters": {
"color": "orange",
"width": 220,
"height": 140,
"content": "\u2795 **CREATE RECORD**\n\nAdds a new contact to the Airtable database.\n\n**Inputs**: Name, Email, Assignee\n**Output**: New record with auto-generated ID\n**Use Case**: \"Add John Doe with email john@example.com\""
},
"typeVersion": 1
},
{
"id": "75303405-11b5-4f16-8cb1-b6fc136373b5",
"name": "Delete Record Info",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
280
],
"parameters": {
"color": "red",
"width": 200,
"height": 120,
"content": "\ud83d\uddd1\ufe0f **DELETE RECORD**\n\nRemoves a contact from the database permanently.\n\n**Input**: Record_ID from AI\n**Output**: Confirmation of deletion\n**Use Case**: \"Delete contact ID xyz\""
},
"typeVersion": 1
},
{
"id": "59f20c23-144e-439e-a0fd-a37ef9ec0a43",
"name": "Search Record Info",
"type": "n8n-nodes-base.stickyNote",
"position": [
1060,
640
],
"parameters": {
"color": "purple",
"width": 220,
"height": 140,
"content": "\ud83d\udd0e **SEARCH RECORDS**\n\nFinds contacts based on specific criteria using Airtable formulas.\n\n**Input**: Filter_By_Formula from AI\n**Output**: Matching contact records\n**Use Case**: \"Find all contacts assigned to Sarah\""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "f96d97b6-70a4-4e38-b6fd-9bc678fc548f",
"connections": {
"Get Record": {
"ai_tool": [
[
{
"node": "MCP Server Trigger",
"type": "ai_tool",
"index": 0
}
]
]
},
"Create Record": {
"ai_tool": [
[
{
"node": "MCP Server Trigger",
"type": "ai_tool",
"index": 0
}
]
]
},
"Delete Record": {
"ai_tool": [
[
{
"node": "MCP Server Trigger",
"type": "ai_tool",
"index": 0
}
]
]
},
"Search Record": {
"ai_tool": [
[
{
"node": "MCP Server Trigger",
"type": "ai_tool",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
The AI-Powered Airtable Contact Manager is an intelligent n8n workflow that enables AI assistants to seamlessly manage contact data in Airtable through natural language interactions. Using the Model Context Protocol (MCP), this workflow bridges the gap between conversational AI…
Source: https://n8n.io/workflows/5509/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
[](https://youtu.be/lQh1fuIrBN8)
Airtable Tool, Mcp Trigger
Need help? Want access to this workflow + many more paid workflows + live Q&A sessions with a top verified n8n creator?
Mcp Trigger, HTTP Request Tool
Dsp agent. Uses telegramTrigger, telegram, openAi, agent. Event-driven trigger; 18 nodes.
Telegram Trigger, Telegram, OpenAI +9
DSP Agent. Uses telegramTrigger, telegram, openAi, agent. Event-driven trigger; 17 nodes.
Telegram Trigger, Telegram, OpenAI +9
Use-Workflow-as-MCP. Uses executeWorkflowTrigger, mcpTrigger, toolWorkflow, notion. Event-driven trigger; 4 nodes.
Execute Workflow Trigger, Mcp Trigger, Tool Workflow +1