Construire un serveur MCP avec Airtable
Intermédiaire
Ceci est unBuilding Blocks, AI, IT Opsworkflow d'automatisation du domainecontenant 13 nœuds.Utilise principalement des nœuds comme AirtableTool, Agent, McpTrigger, ChatTrigger, LmChatOpenAi, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. Construire un serveur MCP avec Airtable
Prérequis
- •Clé API Airtable
- •Clé API OpenAI
Nœuds utilisés (13)
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"id": "kS9EfgZeaK3QV6Mw",
"meta": {
"instanceId": "9219ebc7795bea866f70aa3d977d54417fdf06c41944be95e20cfb60f992db19",
"templateCredsSetupCompleted": true
},
"name": "Build an MCP server with Airtable",
"tags": [],
"nodes": [
{
"id": "357649f0-43c5-4d6c-97b9-079fa3b5c1f3",
"name": "À la réception d'un message de chat",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
-100,
-80
],
"webhookId": "c42d1e2e-b175-48cf-bfd4-aa8289266a20",
"parameters": {
"options": {}
},
"typeVersion": 1.1
},
{
"id": "ddf28f88-d76c-4ab6-82c4-c1ab1b746009",
"name": "Agent IA",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
152,
-180
],
"parameters": {
"options": {}
},
"typeVersion": 1.9
},
{
"id": "3170d4fd-700c-4449-a800-0395c06711aa",
"name": "Mémoire simple",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
260,
40
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "557b0e0a-133b-4e80-afba-408803ed9898",
"name": "Airtable Client MCP",
"type": "@n8n/n8n-nodes-langchain.mcpClientTool",
"position": [
600,
100
],
"parameters": {
"sseEndpoint": "https://your-sse-endpoint-url"
},
"typeVersion": 1
},
{
"id": "a0bc9aa3-decb-42f1-bee4-b9e425db81e8",
"name": "OpenAI Modèle de chat",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
80,
40
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "gpt-4o"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "vupAk5StuhOafQcb",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "7737e491-ddd4-4e4f-a34d-73f518497990",
"name": "Déclencheur de serveur MCP",
"type": "@n8n/n8n-nodes-langchain.mcpTrigger",
"position": [
140,
240
],
"webhookId": "a93f35fb-3a86-4475-9ebd-1434aef8e433",
"parameters": {
"path": "insert-your-cool-path-here"
},
"typeVersion": 1
},
{
"id": "0ce9e128-be31-41d8-ae06-894316781358",
"name": "Obtenir",
"type": "n8n-nodes-base.airtableTool",
"position": [
0,
460
],
"parameters": {
"id": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Record_ID', ``, 'string') }}",
"base": {
"__rl": true,
"mode": "list",
"value": "appltMFy409fOqCVt",
"cachedResultUrl": "https://airtable.com/appltMFy409fOqCVt",
"cachedResultName": "AI news and social posts"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblZwA0JCNPeORaGi",
"cachedResultUrl": "https://airtable.com/appltMFy409fOqCVt/tblZwA0JCNPeORaGi",
"cachedResultName": "Social Posts"
},
"options": {}
},
"credentials": {
"airtableTokenApi": {
"id": "4hNTBxRPe8ft4Iic",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "1f9c6a61-9357-4fa1-81e0-42719284d291",
"name": "Rechercher",
"type": "n8n-nodes-base.airtableTool",
"position": [
140,
460
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appltMFy409fOqCVt",
"cachedResultUrl": "https://airtable.com/appltMFy409fOqCVt",
"cachedResultName": "AI news and social posts"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblZwA0JCNPeORaGi",
"cachedResultUrl": "https://airtable.com/appltMFy409fOqCVt/tblZwA0JCNPeORaGi",
"cachedResultName": "Social Posts"
},
"options": {},
"operation": "search",
"returnAll": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Return_All', ``, 'boolean') }}",
"filterByFormula": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Filter_By_Formula', ``, 'string') }}"
},
"credentials": {
"airtableTokenApi": {
"id": "4hNTBxRPe8ft4Iic",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "061a0eb9-26de-47f1-b444-5dd98c984d70",
"name": "Mettre à jour",
"type": "n8n-nodes-base.airtableTool",
"position": [
260,
460
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appltMFy409fOqCVt",
"cachedResultUrl": "https://airtable.com/appltMFy409fOqCVt",
"cachedResultName": "AI news and social posts"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblZwA0JCNPeORaGi",
"cachedResultUrl": "https://airtable.com/appltMFy409fOqCVt/tblZwA0JCNPeORaGi",
"cachedResultName": "Social Posts"
},
"columns": {
"value": {},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "sourceHeadline",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "sourceHeadline",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sourceSummary",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "sourceSummary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "goToArticle",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "goToArticle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sourceURL",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "sourceURL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "socialChannels",
"type": "array",
"display": true,
"options": [
{
"name": "Twitter",
"value": "Twitter"
},
{
"name": "LinkedIn",
"value": "LinkedIn"
},
{
"name": "Blog",
"value": "Blog"
},
{
"name": "Instagram",
"value": "Instagram"
},
{
"name": "Facebook",
"value": "Facebook"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "socialChannels",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "needsImage?",
"type": "options",
"display": true,
"options": [
{
"name": "Yes",
"value": "Yes"
},
{
"name": "No",
"value": "No"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "needsImage?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "twitterCopy",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "twitterCopy",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedinCopy",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "linkedinCopy",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagramCopy",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "instagramCopy",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebookCopy",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "facebookCopy",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "blogCopy",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "blogCopy",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "imagePrompt",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "imagePrompt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postImage",
"type": "array",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "postImage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "options",
"display": true,
"options": [
{
"name": "Waiting for Content",
"value": "Waiting for Content"
},
{
"name": "Needs Approval",
"value": "Needs Approval"
},
{
"name": "Approved",
"value": "Approved"
},
{
"name": "Posted",
"value": "Posted"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "datePosted",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "datePosted",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ID",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "ID",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"id": "4hNTBxRPe8ft4Iic",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "b0e17724-5a56-4b71-997d-f9f44d16e5bc",
"name": "Supprimer",
"type": "n8n-nodes-base.airtableTool",
"position": [
400,
460
],
"parameters": {
"id": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Record_ID', ``, 'string') }}",
"base": {
"__rl": true,
"mode": "list",
"value": "appltMFy409fOqCVt",
"cachedResultUrl": "https://airtable.com/appltMFy409fOqCVt",
"cachedResultName": "AI news and social posts"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblZwA0JCNPeORaGi",
"cachedResultUrl": "https://airtable.com/appltMFy409fOqCVt/tblZwA0JCNPeORaGi",
"cachedResultName": "Social Posts"
},
"operation": "deleteRecord"
},
"credentials": {
"airtableTokenApi": {
"id": "4hNTBxRPe8ft4Iic",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "2d0273b6-520b-45b7-8192-a83b10661028",
"name": "Créer",
"type": "n8n-nodes-base.airtableTool",
"position": [
520,
460
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appltMFy409fOqCVt",
"cachedResultUrl": "https://airtable.com/appltMFy409fOqCVt",
"cachedResultName": "AI news and social posts"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblZwA0JCNPeORaGi",
"cachedResultUrl": "https://airtable.com/appltMFy409fOqCVt/tblZwA0JCNPeORaGi",
"cachedResultName": "Social Posts"
},
"columns": {
"value": {},
"schema": [
{
"id": "sourceHeadline",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "sourceHeadline",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sourceSummary",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "sourceSummary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "goToArticle",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "goToArticle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sourceURL",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "sourceURL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "socialChannels",
"type": "array",
"display": true,
"options": [
{
"name": "Twitter",
"value": "Twitter"
},
{
"name": "LinkedIn",
"value": "LinkedIn"
},
{
"name": "Blog",
"value": "Blog"
},
{
"name": "Instagram",
"value": "Instagram"
},
{
"name": "Facebook",
"value": "Facebook"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "socialChannels",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "needsImage?",
"type": "options",
"display": true,
"options": [
{
"name": "Yes",
"value": "Yes"
},
{
"name": "No",
"value": "No"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "needsImage?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "twitterCopy",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "twitterCopy",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedinCopy",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "linkedinCopy",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagramCopy",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "instagramCopy",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebookCopy",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "facebookCopy",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "blogCopy",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "blogCopy",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "imagePrompt",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "imagePrompt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postImage",
"type": "array",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "postImage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "options",
"display": true,
"options": [
{
"name": "Waiting for Content",
"value": "Waiting for Content"
},
{
"name": "Needs Approval",
"value": "Needs Approval"
},
{
"name": "Approved",
"value": "Approved"
},
{
"name": "Posted",
"value": "Posted"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "datePosted",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "datePosted",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ID",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "ID",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "4hNTBxRPe8ft4Iic",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "69e906cf-82da-45c4-bacc-00970902d1f5",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
-60
],
"parameters": {
"width": 360,
"height": 280,
"content": "## Update SSE endpoint "
},
"typeVersion": 1
},
{
"id": "819d82c9-da54-48c6-a007-2e8750cfb3e2",
"name": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-520,
-220
],
"parameters": {
"width": 380,
"height": 540,
"content": "## Talk to your Airtable database \nPoint to your SSE endpoint, update your credentials and talk to your Airtable to:\n\n- Get records\n- Search records\n- Update records\n- Delete records\n- Create records\n\nand more!\n\nThis example showcases basic yet powerful functionality for a table.\n\nFeel free to combine it with other tools, connect a Slack channel as trigger node or another as output to receive the updates for the stakeholders and project owners.\n\nEnjoy!\n\nAitor\n[1 Node](https://1node.ai)"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "2355fe0d-0515-4d1b-8a02-42712191f466",
"connections": {
"0ce9e128-be31-41d8-ae06-894316781358": {
"ai_tool": [
[
{
"node": "7737e491-ddd4-4e4f-a34d-73f518497990",
"type": "ai_tool",
"index": 0
}
]
]
},
"2d0273b6-520b-45b7-8192-a83b10661028": {
"ai_tool": [
[
{
"node": "7737e491-ddd4-4e4f-a34d-73f518497990",
"type": "ai_tool",
"index": 0
}
]
]
},
"b0e17724-5a56-4b71-997d-f9f44d16e5bc": {
"ai_tool": [
[
{
"node": "7737e491-ddd4-4e4f-a34d-73f518497990",
"type": "ai_tool",
"index": 0
}
]
]
},
"1f9c6a61-9357-4fa1-81e0-42719284d291": {
"ai_tool": [
[
{
"node": "7737e491-ddd4-4e4f-a34d-73f518497990",
"type": "ai_tool",
"index": 0
}
]
]
},
"061a0eb9-26de-47f1-b444-5dd98c984d70": {
"ai_tool": [
[
{
"node": "7737e491-ddd4-4e4f-a34d-73f518497990",
"type": "ai_tool",
"index": 0
}
]
]
},
"ddf28f88-d76c-4ab6-82c4-c1ab1b746009": {
"main": [
[]
]
},
"3170d4fd-700c-4449-a800-0395c06711aa": {
"ai_memory": [
[
{
"node": "ddf28f88-d76c-4ab6-82c4-c1ab1b746009",
"type": "ai_memory",
"index": 0
}
]
]
},
"a0bc9aa3-decb-42f1-bee4-b9e425db81e8": {
"ai_languageModel": [
[
{
"node": "ddf28f88-d76c-4ab6-82c4-c1ab1b746009",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"557b0e0a-133b-4e80-afba-408803ed9898": {
"ai_tool": [
[
{
"node": "ddf28f88-d76c-4ab6-82c4-c1ab1b746009",
"type": "ai_tool",
"index": 0
}
]
]
},
"357649f0-43c5-4d6c-97b9-079fa3b5c1f3": {
"main": [
[
{
"node": "ddf28f88-d76c-4ab6-82c4-c1ab1b746009",
"type": "main",
"index": 0
}
]
]
}
}
}Foire aux questions
Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Intermédiaire - Blocs de construction, Intelligence Artificielle, Opérations IT
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Serveur MCP d'assistant personnel
Construire un assistant personnel intégrant Google Gemini, Gmail et le calendrier avec MCP
Gmail Tool
Agent
Google Sheets Tool
+
Gmail Tool
Agent
Google Sheets Tool
20 NœudsAitor | 1node.ai
Autres
Agent RAG IA avec Milvus et Cohere
Construire un système de questions-réponses sur les documents RAG pour Google Drive avec Milvus, Cohere et OpenAI
Google Drive
Agent
Extract From File
+
Google Drive
Agent
Extract From File
14 NœudsAitor | 1node.ai
Support
Transcription Mistral
Construire un serveur MCP avec Google Calendar et des fonctions personnalisées
Set
Switch
Debug Helper
+
Set
Switch
Debug Helper
32 NœudsSolomon
Blocs de construction
Construire un serveur MCP de workflow n8n personnalisé
Construire un serveur MCP personnalisé pour les workflows n8n
If
N8n
Set
+
If
N8n
Set
46 NœudsJimleuk
Autres
Agent MCP Supabase
MCP Supabaseagent - utilisationAIgestiondonnées库
Supabase Tool
Agent
Mcp Trigger
+
Supabase Tool
Agent
Mcp Trigger
16 NœudsAmanda Benks
Ingénierie
ozki : Analyse de CSV OpenAI
Analyser les données Google Sheets avec un agent de données piloté par OpenAI
Agent
Google Sheets Tool
Chat Trigger
+
Agent
Google Sheets Tool
Chat Trigger
6 Nœudsozkary
Ingénierie
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds13
Catégorie3
Types de nœuds8
Description de la difficulté
Auteur
Aitor | 1node.ai
@aitoralonsoHi, I’m Aitor, cofounder of 1node.ai. We help businesses integrate full-scale AI solutions that save time, cut costs, and increase revenue. Guaranteed. Need help building smarter workflows? Visit 1node.ai and let's connect.
Liens externes
Voir sur n8n.io →
Partager ce workflow