This workflow follows the Agent → Airtable recipe pattern — see all workflows that pair these two integrations.
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 →
{
"createdAt": "2025-01-30T10:27:04.755Z",
"updatedAt": "2025-02-03T01:34:41.000Z",
"id": "7iw3HCXyCfn4LxrB",
"name": "\ubc95\uc815\ub3d9\ucf54\ub4dc \uc0dd\uc131\uae30",
"active": false,
"nodes": [
{
"parameters": {
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"typeVersion": 1.1,
"position": [
-1080,
-140
],
"id": "619a94f1-0361-4d1d-98f8-55760279ee36",
"name": "When chat message received"
},
{
"parameters": {
"hasOutputParser": true,
"options": {
"systemMessage": "={{$json.chatInput}}\uc740 \uc8fc\uc18c\uc774\ub2e4.\n\uc774 \uc8fc\uc18c\uc9c0\uc758 \uad6c\uc131\uc0ac\ub840\ub294 ' \uc11c\uc6b8\ud2b9\ubcc4\uc2dc \uc885\ub85c\uad6c \uccad\uc6b4\ub3d9 \"\n3\uac00\uc9c0\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\ub2e4.\n\uc2dc\ub3c4\uba85 : \"\uc11c\uc6b8\ud2b9\ubcc4\uc2dc\"\n\uc2dc\uad70\uad6c\uba85 : \"\uc885\ub85c\uad6c\"\n\uc74d\uba74\ub9ac\ub3d9 : \"\uccad\uc6b4\ub3d9\"\n\n\uc774 \uc8fc\uc18c\uc9c0\uc758 \ubc95\uc815\ub3d9\ucf54\ub4dc\ub97c \ucc3e\ub294 \uac83\uc774 \ub108\uc758 \uc5ed\ud560\uc774\ub2e4.\n\ubc95\uc815\ub3d9\ucf54\ub4dc\ub294 Tool\uc758 SheetAgent \ubaa8\ub4c8\uc744 \uc0ac\uc6a9\ud55c\ub2e4.\n\uc774 \ubaa8\ub4c8\uc5d0\uc11c \uc2dc\ub3c4\uba85, \uc2dc\uad70\uad6c\uba85, \uc74d\uba74\ub9ac\ub3d9\uc744 \ucc3e\uc544\uc11c \uc77c\uce58\ud558\ub294 \n\ubc95\uc815\ub3d9\ucf54\ub4dc\ub9cc\uc744 \uc81c\uc2dc\ud55c\ub2e4.\n\n"
}
},
"type": "@n8n/n8n-nodes-langchain.agent",
"typeVersion": 1.7,
"position": [
-860,
-140
],
"id": "065de4e0-3575-4065-a2f3-d27abf197c83",
"name": "AI Agent"
},
{
"parameters": {
"options": {
"maxTokens": -1
}
},
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"typeVersion": 1,
"position": [
-980,
100
],
"id": "ac4a13c3-faad-46a8-88a7-80f914bdb7ab",
"name": "OpenAI Chat Model",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {},
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"typeVersion": 1.3,
"position": [
-840,
100
],
"id": "64766600-30cd-4367-bdb5-b1c4257213a9",
"name": "Window Buffer Memory"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "dd502e15-076b-4d58-a4f1-29dd33c0e7f9",
"name": "response",
"value": "={{ $json.code }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-280,
-140
],
"id": "69496f97-926e-44cb-966d-cd8f741e3f2c",
"name": "Edit Fields"
},
{
"parameters": {
"jsCode": "return items.map(item => {\n const output = item.json.output; // AI Agent\uc758 \ucd9c\ub825 \uac00\uc838\uc624\uae30\n // \uc22b\uc790\ub97c \ud3ec\ud568\ud55c \ud070\ub530\uc634\ud45c \uc548\uc758 \ub0b4\uc6a9\uc744 \ucd94\ucd9c\n const match = output.match(/\"(\\d+)\"/); // \"\uc22b\uc790\" \ud615\uc2dd\uc744 \ucd94\ucd9c\n return {\n json: {\n code: match ? match[1] : null, // \ucd94\ucd9c\ub41c \uc22b\uc790 \ubc18\ud658\n }\n };\n});\n\n"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
-480,
-140
],
"id": "f62348b6-2387-41fe-be66-e74ee22619f6",
"name": "Code"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1MZ9gXK12o0Uhg1Yq_Y0ZKTBS6U8sidzqHA32CNQ63ps",
"mode": "list",
"cachedResultName": "\uad6d\ud1a0\uad50\ud1b5\ubd80_\uc804\uad6d \ubc95\uc815\ub3d9_20240802\uc758 \uc0ac\ubcf8",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1MZ9gXK12o0Uhg1Yq_Y0ZKTBS6U8sidzqHA32CNQ63ps/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 1928233197,
"mode": "list",
"cachedResultName": "\uc11c\uc6b8\uacbd\uae30",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1MZ9gXK12o0Uhg1Yq_Y0ZKTBS6U8sidzqHA32CNQ63ps/edit#gid=1928233197"
},
"options": {
"returnFirstMatch": true
}
},
"type": "n8n-nodes-base.googleSheetsTool",
"typeVersion": 4.5,
"position": [
-120,
260
],
"id": "c0dec1dd-1f61-4c0f-89c2-244311809940",
"name": "\uc11c\uc6b8\uacbd\uae30",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1MZ9gXK12o0Uhg1Yq_Y0ZKTBS6U8sidzqHA32CNQ63ps",
"mode": "list",
"cachedResultName": "\uad6d\ud1a0\uad50\ud1b5\ubd80_\uc804\uad6d \ubc95\uc815\ub3d9_20240802\uc758 \uc0ac\ubcf8",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1MZ9gXK12o0Uhg1Yq_Y0ZKTBS6U8sidzqHA32CNQ63ps/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 1338090821,
"mode": "list",
"cachedResultName": "\ucda9\uccad\ub3c4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1MZ9gXK12o0Uhg1Yq_Y0ZKTBS6U8sidzqHA32CNQ63ps/edit#gid=1338090821"
},
"options": {}
},
"type": "n8n-nodes-base.googleSheetsTool",
"typeVersion": 4.5,
"position": [
-20,
260
],
"id": "979c74ae-1a30-4902-9ce8-6d26dfc46f2e",
"name": "\ucda9\uccad\ub3c4",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1MZ9gXK12o0Uhg1Yq_Y0ZKTBS6U8sidzqHA32CNQ63ps",
"mode": "list",
"cachedResultName": "\uad6d\ud1a0\uad50\ud1b5\ubd80_\uc804\uad6d \ubc95\uc815\ub3d9_20240802\uc758 \uc0ac\ubcf8",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1MZ9gXK12o0Uhg1Yq_Y0ZKTBS6U8sidzqHA32CNQ63ps/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 449470448,
"mode": "list",
"cachedResultName": "\ud2b9\ubcc4\uc790\uce58\ub3c4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1MZ9gXK12o0Uhg1Yq_Y0ZKTBS6U8sidzqHA32CNQ63ps/edit#gid=449470448"
},
"options": {}
},
"type": "n8n-nodes-base.googleSheetsTool",
"typeVersion": 4.5,
"position": [
100,
260
],
"id": "949c1dee-5585-4080-a4bf-9bdd67e3501b",
"name": "\ud2b9\ubcc4\uc790\uce58\ub3c4(\uac15\uc6d0,\uc804\ubd81)",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1MZ9gXK12o0Uhg1Yq_Y0ZKTBS6U8sidzqHA32CNQ63ps",
"mode": "list",
"cachedResultName": "\uad6d\ud1a0\uad50\ud1b5\ubd80_\uc804\uad6d \ubc95\uc815\ub3d9_20240802\uc758 \uc0ac\ubcf8",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1MZ9gXK12o0Uhg1Yq_Y0ZKTBS6U8sidzqHA32CNQ63ps/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 120303426,
"mode": "list",
"cachedResultName": "\uad11\uc5ed\uc2dc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1MZ9gXK12o0Uhg1Yq_Y0ZKTBS6U8sidzqHA32CNQ63ps/edit#gid=120303426"
},
"options": {
"returnFirstMatch": true
}
},
"type": "n8n-nodes-base.googleSheetsTool",
"typeVersion": 4.5,
"position": [
220,
260
],
"id": "17cddf76-ae61-4ca1-805f-7655ecb91fb4",
"name": "\uad11\uc5ed\uc2dc(\uc778\ucc9c \uc138\uc885 \ub300\uad6c \uad11\uc8fc \ub300\uc804)",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"content": "## \uc6cc\ud06c\ud50c\ub85c\uc6b0\n\n1. \uad6c\uae00\uc2dc\ud2b8\uc758 \ubc95\uc815\ub3d9\uc0ac\uc774\uc988\uac00 \ucee4\uc11c OpenAI Chat model\uc758 \ucd5c\ub300\ud1a0\ud070\uac12 128000\uc744 \ub118\uc5b4\uc12c.\n2. Google_sheet \ubcc4\ub3c4 \uc5d0\uc774\uc804\ud2b8\ub97c \ub9cc\ub4e4\uc5b4\uc11c \uac01 \uc9c0\uc5ed\ubcc4\ub85c \ubd84\ub9ac\ud574\uc11c \ud574\ub2f9 \ubc95\uc815\ub3d9\ucf54\ub4dc\ub97c \ucc3e\ub3c4\ub85d \ud568.\n3. \ubcc4\ub3c4\uc5d0\uc774\uc804\ud2b8 \uc2e4\ud589\ud560\ub584 \uc720\uc758\uc810.\n => response \uac12\uc774 \uc548\ubcf4\uc57c\ub3c4 \ub41c\ub2e4.\n=> \ubcc4\ub3c4\uc5d0\uc774\uc804\ud2b8\ub294 \uc2dc\uc791\uac12\uc744 query\ub85c \uc784\uc758 \uc9c0\uc815\ud558\uace0 \uc2dc\uc791\ud55c\ub2e4. \n=> \ub9c8\uc9c0\ub9c9\uc740response \ubaa8\ub4c8\uc744 \ub123\uc5b4\uc900\ub2e4. ",
"height": 300,
"width": 300
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-1480,
-280
],
"id": "0a681b67-0782-402c-b0d8-daefc6572c9f",
"name": "Sticky Note"
},
{
"parameters": {
"url": "https://apis.data.go.kr/1613000/BldRgstHubService/getBrTitleInfo",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "serviceKey",
"value": "G9RPi/FJq6YadHqgasuXKJN8veXS8rLubWqz66pixLEpDssWsUiFWN1jhcWG4bVH1/nCJfW/ggtNzUKkYEzTBA=="
},
{
"name": "bjdongCd",
"value": "=10300"
},
{
"name": "platGbCd",
"value": "0"
},
{
"name": "bun",
"value": "0012"
},
{
"name": "ji",
"value": "0000"
},
{
"name": "numOfRows",
"value": "10"
},
{
"name": "pageNo",
"value": "1"
},
{
"name": "sigunguCd",
"value": "11680"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
-60,
-140
],
"id": "07a39a17-bf12-4aad-9bb3-a46e53f14fbb",
"name": "HTTP Request"
},
{
"parameters": {
"name": "SheetAgent",
"description": "Cal this tool to search google sheets to find address code to match address I write",
"workflowId": {
"__rl": true,
"value": "kkVV1PsCCsANV8GK",
"mode": "list",
"cachedResultName": "SheetAgent"
}
},
"type": "@n8n/n8n-nodes-langchain.toolWorkflow",
"typeVersion": 1.3,
"position": [
-700,
100
],
"id": "99ba5ee7-8eb1-4c13-b238-0c0f877dba50",
"name": "SheetAgent"
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.xml",
"typeVersion": 1,
"position": [
140,
-140
],
"id": "166228de-dca9-4e54-8a77-3346c3c1b0cd",
"name": "XML"
},
{
"parameters": {
"operation": "create",
"base": {
"__rl": true,
"value": "appnWOGnsVE6GaAY7",
"mode": "list",
"cachedResultName": "\uac74\ub300",
"cachedResultUrl": "https://airtable.com/appnWOGnsVE6GaAY7"
},
"table": {
"__rl": true,
"value": "tbl7IqgBTG4IGoryW",
"mode": "list",
"cachedResultName": "Table 1",
"cachedResultUrl": "https://airtable.com/appnWOGnsVE6GaAY7/tbl7IqgBTG4IGoryW"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"\uc2dc\uad70\uad6c": "={{ $json.response.body.items.item[0].sigunguCd }}",
"\ubc95\uc815\ub3d9": "={{ $json.response.body.items.item[0].bjdongCd }}",
"\uc9c0": "={{ $json.response.body.items.item[0].ji }}",
"\ubc88": "={{ $json.response.body.items.item[0].bun }}",
"\uc9c0\ubc88": "={{ $json.response.body.items.item[0].platPlc }}"
},
"matchingColumns": [],
"schema": [
{
"id": "\uc9c0\ubc88",
"displayName": "\uc9c0\ubc88",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
},
{
"id": "\uc2dc\uad70\uad6c",
"displayName": "\uc2dc\uad70\uad6c",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
},
{
"id": "\ubc95\uc815\ub3d9",
"displayName": "\ubc95\uc815\ub3d9",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
},
{
"id": "\ubc88",
"displayName": "\ubc88",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "number",
"readOnly": false,
"removed": false
},
{
"id": "\uc9c0",
"displayName": "\uc9c0",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "number",
"readOnly": false,
"removed": false
},
{
"id": "\uc9c4\ud589",
"displayName": "\uc9c4\ud589",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "options",
"options": [
{
"name": "Done",
"value": "Done"
},
{
"name": "progress",
"value": "progress"
}
],
"readOnly": false,
"removed": false
}
]
},
"options": {}
},
"type": "n8n-nodes-base.airtable",
"typeVersion": 2.1,
"position": [
340,
-140
],
"id": "2fcdc3b0-034e-4686-97bc-70f7fd9040a0",
"name": "Airtable",
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
}
}
],
"connections": {
"When chat message received": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Window Buffer Memory": {
"ai_memory": [
[
{
"node": "AI Agent",
"type": "ai_memory",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"\uc11c\uc6b8\uacbd\uae30": {
"ai_tool": [
[]
]
},
"\ucda9\uccad\ub3c4": {
"ai_tool": [
[]
]
},
"Edit Fields": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"SheetAgent": {
"ai_tool": [
[
{
"node": "AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "XML",
"type": "main",
"index": 0
}
]
]
},
"XML": {
"main": [
[
{
"node": "Airtable",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1"
},
"staticData": null,
"meta": null,
"versionId": "5fdece3e-74c7-4a2e-9e1d-6bac25713cbe",
"triggerCount": 0,
"tags": []
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
airtableTokenApigoogleSheetsOAuth2ApiopenAiApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
법정동코드 생성기. Uses chatTrigger, agent, lmChatOpenAi, memoryBufferWindow. Chat trigger; 15 nodes.
Source: https://github.com/leoskyearth/repository_n8n/blob/146446f72d7dfd5b1fee14a51f6f5dd7dba533c3/workflows/7iw3HCXyCfn4LxrB.json — 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.
by Varritech Technologies
Chat Trigger, Agent, OpenAI Chat +8
Who is this workflow for? This workflow is designed for SEO analysts, content creators, marketing agencies, and developers who need to index a website and then interact with its content as if it were
Agent, OpenAI Chat, Memory Buffer Window +10
Airtable AI Agent. Uses lmChatOpenAi, agent, toolWorkflow, toolCode. Chat trigger; 42 nodes.
OpenAI Chat, Agent, Tool Workflow +6
Ai Agent To Chat With Airtable And Analyze Data. Uses lmChatOpenAi, agent, stickyNote, memoryBufferWindow. Chat trigger; 41 nodes.
OpenAI Chat, Agent, Memory Buffer Window +6
I prepared a detailed guide that shows the entire process of building an AI agent that integrates with Airtable data in n8n. This template covers everything from data preparation to advanced configura
OpenAI Chat, Agent, Memory Buffer Window +6