This workflow follows the Airtable → Chainllm 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 →
{
"id": "12h8SlaLyitquaup",
"name": "20250728-airtable-youtube-transcript-v1",
"description": null,
"active": false,
"isArchived": false,
"nodes": [
{
"parameters": {
"content": "## Receive webhook \nObtain Airtable record",
"height": 282,
"width": 824,
"color": 7
},
"id": "0881f2e6-0426-4f92-86a9-4e7ce5c511e1",
"name": "Sticky Note12",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-432,
368
],
"disabled": true
},
{
"parameters": {
"path": "youtube-transcript",
"options": {}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-304,
448
],
"id": "35697506-2c5b-467b-b0e5-94c6c6c5e6b5",
"name": "Webhook"
},
{
"parameters": {
"base": {
"__rl": true,
"value": "appZx6OWphy0LudAx",
"mode": "list",
"cachedResultName": "Scrapes AI -peter0725- Interface",
"cachedResultUrl": "https://airtable.com/appZx6OWphy0LudAx"
},
"table": {
"__rl": true,
"value": "tblJc21nI6OHHUed5",
"mode": "list",
"cachedResultName": "YT_transcript",
"cachedResultUrl": "https://airtable.com/appZx6OWphy0LudAx/tblJc21nI6OHHUed5"
},
"id": "={{ $('Webhook').item.json.query.recordId }}",
"options": {}
},
"type": "n8n-nodes-base.airtable",
"typeVersion": 2.1,
"position": [
272,
448
],
"id": "8a2bf6de-2d51-4cf6-b2d6-31f88bb75e6c",
"name": "GetRecord",
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "6e5320f5-9681-4a50-85f4-3849bded95c7",
"leftValue": "={{ $json['Status'] }}",
"rightValue": "Incomplete",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
512,
448
],
"id": "6f2050ff-1a7e-4320-b3a0-47860147647a",
"name": "IfIncomplete"
},
{
"parameters": {
"operation": "update",
"base": {
"__rl": true,
"value": "appZx6OWphy0LudAx",
"mode": "list",
"cachedResultName": "Scrapes AI -peter0725- Interface",
"cachedResultUrl": "https://airtable.com/appZx6OWphy0LudAx"
},
"table": {
"__rl": true,
"value": "tblCALxxpLQicYZar",
"mode": "list",
"cachedResultName": "Company",
"cachedResultUrl": "https://airtable.com/appZx6OWphy0LudAx/tblCALxxpLQicYZar"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"id": "={{ $json.id }}",
"Notes": "Already complete - switch 'Status' to incomplete and check 'Generate Info' to re-run"
},
"matchingColumns": [
"id"
],
"schema": [
{
"id": "id",
"displayName": "id",
"required": false,
"defaultMatch": true,
"display": true,
"type": "string",
"readOnly": true,
"removed": false
},
{
"id": "Company name",
"displayName": "Company name",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Website URL",
"displayName": "Website URL",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Company Linkedin",
"displayName": "Company Linkedin",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Generate Info",
"displayName": "Generate Info",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "boolean",
"readOnly": false,
"removed": true
},
{
"id": "Product description",
"displayName": "Product description",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Who are the ICP?",
"displayName": "Who are the ICP?",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Pain points / Challenges",
"displayName": "Pain points / Challenges",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Key Goals / Objectives",
"displayName": "Key Goals / Objectives",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "How do they currently solve their problems?",
"displayName": "How do they currently solve their problems?",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Status",
"displayName": "Status",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "options",
"options": [
{
"name": "Incomplete",
"value": "Incomplete"
},
{
"name": "Complete",
"value": "Complete"
}
],
"readOnly": false,
"removed": true
},
{
"id": "Notes",
"displayName": "Notes",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.airtable",
"typeVersion": 2.1,
"position": [
528,
944
],
"id": "b917a5c9-3001-4591-a8d0-27136c4e1f4d",
"name": "AddNotes",
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"content": "## Process\nOnly if information not complete",
"height": 234,
"width": 292,
"color": 7
},
"id": "14e72c8e-4dda-4acc-a58b-4f517509d671",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
400,
368
],
"disabled": true
},
{
"parameters": {
"operation": "update",
"base": {
"__rl": true,
"value": "appZx6OWphy0LudAx",
"mode": "list",
"cachedResultName": "Scrapes AI -peter0725- Interface",
"cachedResultUrl": "https://airtable.com/appZx6OWphy0LudAx"
},
"table": {
"__rl": true,
"value": "tblJc21nI6OHHUed5",
"mode": "list",
"cachedResultName": "YT_transcript",
"cachedResultUrl": "https://airtable.com/appZx6OWphy0LudAx/tblJc21nI6OHHUed5"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Generate Info": false,
"Status": "Complete",
"id": "={{ $('GetRecord').item.json.id }}",
"Notes": "=",
"Google Doc": "={{ $json.property_google_doc }}",
"Notion DB url": "={{ $json.url }}"
},
"matchingColumns": [
"id"
],
"schema": [
{
"id": "id",
"displayName": "id",
"required": false,
"defaultMatch": true,
"display": true,
"type": "string",
"readOnly": true,
"removed": false
},
{
"id": "Company name",
"displayName": "Company name",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Youtube URL",
"displayName": "Youtube URL",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Generate Info",
"displayName": "Generate Info",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "boolean",
"readOnly": false,
"removed": false
},
{
"id": "Status",
"displayName": "Status",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "options",
"options": [
{
"name": "Incomplete",
"value": "Incomplete"
},
{
"name": "Complete",
"value": "Complete"
}
],
"readOnly": false,
"removed": false
},
{
"id": "Notes",
"displayName": "Notes",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
},
{
"id": "Google Doc",
"displayName": "Google Doc",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
},
{
"id": "record_id",
"displayName": "record_id",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": true,
"removed": true
},
{
"id": "Notion DB url",
"displayName": "Notion DB url",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.airtable",
"typeVersion": 2.1,
"position": [
4208,
432
],
"id": "9ddb6e3e-2f88-4996-a9de-d6cefa87b9dd",
"name": "UpdateRecord",
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"content": "## Update\nUpdate info",
"height": 234,
"width": 452,
"color": 7
},
"id": "e434e411-c596-4863-b1ef-7fc7cb7bf2a4",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
3712,
-144
],
"disabled": true
},
{
"parameters": {
"url": "=https://api.apify.com/v2/actor-runs/{{ $json.data.id}}",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "waitForFinish",
"value": "60"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"options": {}
},
"id": "b64f985e-ddf4-445d-8def-3710114ea62c",
"name": "Get Actor Run",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
1232,
432
],
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"url": "=https://api.apify.com/v2/datasets/{{$json.data.defaultDatasetId}}/items",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"options": {}
},
"id": "1c1962fa-4ae7-491f-a539-f76ee510f1b4",
"name": "Get DataSet",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
1440,
432
],
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"onError": "continueErrorOutput"
},
{
"parameters": {
"method": "POST",
"url": "https://api.apify.com/v2/acts/xXOR6XE5SNC1QD138/runs",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"video_url\": {{ $('Set input').item.json.url.toJsonString() }}\n}",
"options": {}
},
"id": "10337986-5429-4bd7-a23d-fcaf77fc15ef",
"name": "Start Act",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
1008,
432
],
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"typeVersion": 1,
"position": [
2640,
640
],
"id": "afea93da-ab78-4270-9b6f-6fade8d5c165",
"name": "OpenAI Chat Model",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"promptType": "define",
"text": "={{ $('Get DataSet').item.json.text }}",
"messages": {
"messageValues": [
{
"message": "=\n2,156 / 5,000\n\u60a8\u7684\u8a2d\u8a08\u76ee\u6a19\u662f\u8655\u7406\u5f71\u7247\u5167\u5bb9\u7684\u8f49\u9304\uff0c\u4e26\u63d0\u4f9b\u7c21\u6f54\u660e\u4e86\u7684\u6458\u8981\u3002\u8a72\u5de5\u5177\u975e\u5e38\u9069\u5408\u90a3\u4e9b\u5e0c\u671b\u5feb\u901f\u7406\u89e3\u5f71\u7247\u5167\u5bb9\u7684\u8981\u9ede\u3001\u95dc\u9375\u8981\u9ede\u6216\u53ef\u64cd\u4f5c\u6027\u898b\u89e3\uff0c\u800c\u7121\u9700\u901a\u8b80\u6574\u500b\u8f49\u9304\u6587\u5b57\u7684\u4f7f\u7528\u8005\u3002\n\n\u8f38\u51fa\u683c\u5f0f\u4e00\u5f8b\u8f49\u6210\u7e41\u9ad4\u4e2d\u6587.\n\n\n\u8aaa\u660e\uff1a\n\n\u5167\u5bb9\u5206\u6790\uff1a\u4ed4\u7d30\u5be9\u67e5\u6574\u500b\u8f49\u9304\u6587\u672c\uff0c\u627e\u51fa\u95dc\u9375\u4e3b\u984c\u3001\u8ad6\u9ede\u548c\u91cd\u8981\u7d30\u7bc0\u3002\u5c0b\u627e\u8f49\u9304\u6587\u672c\u4e2d\u63d0\u4f9b\u7684\u4e3b\u8981\u601d\u60f3\u3001\u95dc\u9375\u9ede\u6216\u4efb\u4f55\u53ef\u64cd\u4f5c\u6027\u898b\u89e3\u3002\u8b58\u5225\u53cd\u8986\u51fa\u73fe\u7684\u4e3b\u984c\u6216\u767c\u8a00\u8005\uff0c\u4e26\u8a18\u9304\u4ed6\u5011\u7684\u8ca2\u737b\uff0c\u5c24\u5176\u662f\u5728\u4ed6\u5011\u5c0d\u6574\u9ad4\u8cc7\u8a0a\u81f3\u95dc\u91cd\u8981\u7684\u60c5\u6cc1\u4e0b\u3002\n\n\u6458\u8981\u683c\u5f0f\uff1a\u6839\u64da\u8f49\u9304\u6587\u5b57\u7684\u9577\u5ea6\u548c\u8907\u96dc\u7a0b\u5ea6\uff0c\u78ba\u5b9a\u6700\u5408\u9069\u7684\u683c\u5f0f\uff1a\u7c21\u77ed\u8981\u9ede\uff1a\u7528\u65bc\u5feb\u901f\u3001\u6613\u65bc\u7406\u89e3\u7684\u6458\u8981\u3002\u5168\u6587\u6bb5\u843d\uff1a\u7528\u65bc\u66f4\u8a73\u7d30\u3001\u66f4\u9023\u8cab\u7684\u6458\u8981\u3002\u5169\u8005\u7d50\u5408\uff1a\u5fc5\u8981\u6642\uff0c\u6dfb\u52a0\u8981\u9ede\u6982\u8ff0\u95dc\u9375\u898b\u89e3\uff0c\u4e26\u6dfb\u52a0\u4e00\u6bb5\u7528\u65bc\u80cc\u666f\u6216\u89e3\u91cb\u7684\u6bb5\u843d\u3002\u6ce8\u91cd\u6e05\u6670\u7c21\u6f54\uff0c\u78ba\u4fdd\u91cd\u9ede\u6613\u65bc\u7406\u89e3\u3002\n\n\u8a9e\u6c23\u8207\u7d50\u69cb\uff1a\u6839\u64da\u5f71\u7247\u5167\u5bb9\u8abf\u6574\u6458\u8981\u7684\u8a9e\u6c23\uff1a\u6b63\u5f0f\u8a9e\u6c23\uff1a\u9069\u7528\u65bc\u5c08\u696d\u3001\u5b78\u8853\u6216\u5546\u696d\u76f8\u95dc\u5167\u5bb9\u3002\u975e\u6b63\u5f0f\u8a9e\u6c23\uff1a\u9069\u7528\u65bc\u4f11\u9592\u3001\u5c0d\u8a71\u6216\u5a1b\u6a02\u985e\u5167\u5bb9\u3002\u6458\u8981\u61c9\u4fdd\u6301\u908f\u8f2f\u6d41\u66a2\uff0c\u4ee5\u5408\u7406\u4e14\u6613\u65bc\u7406\u89e3\u7684\u9806\u5e8f\u5448\u73fe\u91cd\u9ede\u3002\n\n\u6458\u8981\u9577\u5ea6\uff1a\u6458\u8981\u9577\u5ea6\u61c9\u9748\u6d3b\uff0c\u4e26\u8207\u63d0\u4f9b\u7684\u8f49\u9304\u5167\u5bb9\u76f8\u7b26\uff1a\u7c21\u6f54\u6458\u8981\uff1a\u9069\u7528\u65bc\u7c21\u77ed\u7684\u8f49\u9304\u5167\u5bb9\u6216\u50c5\u9700\u50b3\u9054\u8981\u9ede\u7684\u60c5\u6cc1\u3002\u64f4\u5145\u6458\u8981\uff1a\u9069\u7528\u65bc\u8f03\u9577\u7684\u8f49\u9304\u5167\u5bb9\uff0c\u5305\u542b\u66f4\u591a\u7d30\u7bc0\u548c\u7d30\u5fae\u5dee\u5225\u3002\u78ba\u4fdd\u6458\u8981\u5920\u8a73\u7d30\uff0c\u80fd\u5920\u63d0\u4f9b\u6709\u50f9\u503c\u7684\u898b\u89e3\uff0c\u4f46\u53c8\u8981\u7c21\u6f54\u660e\u4e86\uff0c\u907f\u514d\u4e0d\u5fc5\u8981\u7684\u8d05\u8ff0\u3002\n\n\u6e05\u6670\u5ea6\u548c\u76f8\u95dc\u6027\uff1a\u78ba\u4fdd\u6458\u8981\u50c5\u95dc\u6ce8\u6700\u76f8\u95dc\u7684\u8cc7\u8a0a\u3002\u907f\u514d\u4f7f\u7528\u7121\u95dc\u6216\u904e\u65bc\u8a73\u7d30\u7684\u90e8\u5206\uff0c\u9664\u975e\u5b83\u5011\u6709\u52a9\u65bc\u7406\u89e3\u5f71\u7247\u7684\u95dc\u9375\u8cc7\u8a0a\u3002\u5982\u679c\u63d0\u5230\u4e86\u767c\u8a00\u8005\uff0c\u8acb\u660e\u78ba\u6307\u51fa\u76f8\u61c9\u7684\u767c\u8a00\u8005\uff0c\u5c24\u5176\u662f\u5728\u4ed6\u5011\u5c0d\u65bc\u5167\u5bb9\u81f3\u95dc\u91cd\u8981\u7684\u60c5\u6cc1\u4e0b\u3002"
}
]
}
},
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"typeVersion": 1.5,
"position": [
2928,
432
],
"id": "96e3cd01-7e8b-4b49-a297-b65039c24bc8",
"name": "Video Summary"
},
{
"parameters": {
"promptType": "define",
"text": "={{ $('Get DataSet').item.json.transcript.map(item => `[${item.start} - ${item.end}] ${item.text}`).join('\\n') }}",
"messages": {
"messageValues": [
{
"message": "=\u9019\u6b3e GPT \u52a9\u7406\u65e8\u5728\u5206\u6790 JSON \u683c\u5f0f\u7684\u8996\u8a0a\u8f49\u9304\u6578\u64da\uff0c\u4e26\u63d0\u53d6\u95dc\u9375\u6642\u9593\u6233\u53ca\u5176\u5c0d\u61c9\u7684\u4e3b\u984c\u6216\u7ae0\u7bc0\u3002\u5176\u76ee\u6a19\u662f\u5e6b\u52a9\u7528\u6236\u5feb\u901f\u8b58\u5225\u5f71\u7247\u4e2d\u7684\u91cd\u8981\u90e8\u5206\u3002\n\u8f38\u51fa\u4e00\u5f8b\u7528\u7e41\u9ad4\u4e2d\u6587\u8f38\u51fa.\n\n\u8aaa\u660e\uff1a\n\u60a8\u5c07\u5206\u6790\u6587\u4ef6\u4e26\u7522\u751f\u4ee5\u4e0b\u8f38\u51fa\uff1a\n\u6642\u9593\u6233 -\n00:00:00 - \u75c5\u6bd2\u5f0f Instagram \u8173\u672c\u7684 AI \u81ea\u52d5\u5316\n00:03:54 - \u7522\u751f\u75c5\u6bd2\u5f0f\u8173\u672c\u2026\n01:03:00 - \u75c5\u6bd2\u5f0f\u5167\u5bb9\u5efa\u7acb\u6d41\u7a0b \u6bcf\u500b\u6642\u9593\u6233\u8a18\u90fd\u6a19\u8a18\u8f49\u9304\u4e2d\u5075\u6e2c\u5230\u7684\u65b0\u4e3b\u984c\u3001\u7ae0\u7bc0\u6216\u91cd\u8981\u8f49\u8b8a\u3002\n\n\u5206\u6790\u6b65\u9a5f\uff1a\u52a9\u624b\u6703\u8b80\u53d6\u8f49\u9304\u8cc7\u6599\u3002\u6839\u64da\u95dc\u9375\u5b57\uff08\u4f8b\u5982\u300c\u4e0b\u4e00\u500b\u300d\u3001\u300c\u4e3b\u984c\u300d\u3001\u300c\u73fe\u5728\u8b93\u6211\u5011\u7e7c\u7e8c\u300d\u6216\u5176\u4ed6\u6a21\u5f0f\uff09\u8b58\u5225\u904e\u6e21\u6216\u65b0\u7ae0\u7bc0\u3002\u5c07\u76f8\u95dc\u5167\u5bb9\u4ee5\u7279\u5b9a\u6642\u9593\u6233\u5206\u7d44\u3002\u6700\u7d42\u4ee5\u7c21\u6f54\u6613\u7528\u7684\u683c\u5f0f\u8f38\u51fa\u7d50\u679c\uff0c\u5982\u4e0a\u5716\u6240\u793a\u3002\n\n\u4f7f\u7528\u6848\u4f8b\u7bc4\u4f8b\uff1a\u5feb\u901f\u8b58\u5225\u7db2\u8def\u7814\u8a0e\u6703\u3001\u57f9\u8a13\u6216\u793a\u7bc4\u5f71\u7247\u7684\u7247\u6bb5\u3002\u5c07\u5197\u9577\u7684\u64ad\u5ba2\u6216\u6559\u5b78\u8ab2\u7a0b\u6982\u62ec\u70ba\u95dc\u9375\u6642\u523b\u3002\u64f7\u53d6\u6d1e\u5bdf\uff0c\u70ba YouTube \u7b49\u5e73\u53f0\u5efa\u7acb\u5f71\u7247\u6458\u8981\u6216\u6642\u9593\u6233\u8a18\u3002"
}
]
}
},
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"typeVersion": 1.5,
"position": [
2544,
432
],
"id": "de594429-bc22-4dc0-9fd9-c93dffd46929",
"name": "Transcript Chunking",
"alwaysOutputData": true
},
{
"parameters": {
"content": "## Apify - Scrape Transcript from Video URL\nhttps://console.apify.com/actors/xXOR6XE5SNC1QD138/input",
"height": 300,
"width": 660,
"color": 7
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
944,
288
],
"id": "f9a064af-cdea-4a84-8d6d-8d78bd169f70",
"name": "Sticky Note1"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "ba223339-9daf-4a69-9a5c-baac25e07509",
"name": "id",
"value": "={{ $('Set input').item.json?.id }}",
"type": "string"
},
{
"id": "12f943c0-4a09-4409-99f1-9152d9ee25c2",
"name": "Video_summary",
"value": "={{ $('Video Summary').item.json.text }}",
"type": "string"
},
{
"id": "8f5e417f-b81f-43e9-9a40-710ddf6fa4bf",
"name": "Script_summary",
"value": "={{ $('Transcript Chunking').item.json.text }}",
"type": "string"
},
{
"id": "02e8be39-dc33-4bbb-b172-fb6e89910851",
"name": "Transcript",
"value": "={{ $('Get DataSet').item.json.transcript.map(item => `[${item.start} - ${item.end}] ${item.text}`).join('\\n') }}",
"type": "string"
}
]
},
"includeOtherFields": true,
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
3312,
432
],
"id": "08abcd2d-13e4-400e-b1b8-2401c6f263c0",
"name": "Set output"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "92179010-4964-4d18-b5a7-624ba720606d",
"name": "=url",
"value": "={{ $json['Youtube URL'] }}",
"type": "string"
},
{
"id": "11bfae12-3a7a-44dc-a582-3f064f32d678",
"name": "update_airtable",
"value": "",
"type": "string"
}
]
},
"includeOtherFields": true,
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
784,
432
],
"id": "86862d2a-c9a8-4895-b2ef-292f63c4ed62",
"name": "Set input"
},
{
"parameters": {
"resource": "databasePage",
"databaseId": {
"__rl": true,
"value": "23aca842-df05-8020-b47c-c5eb024a02a1",
"mode": "list",
"cachedResultName": "zap_youtube_transcript_summary",
"cachedResultUrl": "https://www.notion.so/23aca842df058020b47cc5eb024a02a1"
},
"propertiesUi": {
"propertyValues": [
{
"key": "video_url|url",
"urlValue": "={{ $('Set input').item.json.url }}"
},
{
"key": "Video\u540d\u7a31|title",
"title": "={{ $('Get DataSet').item.json.title }}"
},
{
"key": "Google Doc \u5168\u6587\u7db2\u5740|url",
"urlValue": "=https://docs.google.com/document/d/{{ $('Done1').item.json.id }}/edit\n\n"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.notion",
"typeVersion": 2.2,
"position": [
3968,
432
],
"id": "a4d50429-ed7d-44dd-8953-bd33d517bfc3",
"name": "Create a database page",
"credentials": {
"notionApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"folderId": "1JFefvurPciz9OVH7XmQ5cBGKa7cUiBfw",
"title": "={{ $('Get DataSet').item.json.title }}"
},
"type": "n8n-nodes-base.googleDocs",
"typeVersion": 2,
"position": [
1888,
432
],
"id": "2c6bdbf3-401c-4409-824d-24fab2ef6842",
"name": "Create Docs",
"credentials": {
"googleDocsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "update",
"documentURL": "={{ $json.id }}",
"actionsUi": {
"actionFields": [
{
"action": "insert",
"text": "={{ $('Code').item.json.text }}\n"
}
]
}
},
"type": "n8n-nodes-base.googleDocs",
"typeVersion": 2,
"position": [
2112,
432
],
"id": "62757c6d-fbeb-44ee-ba42-e3bfc4325a4f",
"name": "Update Docs",
"credentials": {
"googleDocsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "move",
"fileId": {
"__rl": true,
"value": "={{ $('Create Docs').item.json.id }}",
"mode": "id"
},
"driveId": {
"__rl": true,
"value": "https://drive.google.com/drive/folders/1GCu9Bq64NO3J8rwRJhAPabytpR60s_0b",
"mode": "url"
},
"folderId": {
"__rl": true,
"value": "https://drive.google.com/drive/folders/1GCu9Bq64NO3J8rwRJhAPabytpR60s_0b",
"mode": "url"
}
},
"type": "n8n-nodes-base.googleDrive",
"typeVersion": 3,
"position": [
3760,
432
],
"id": "c8166c9b-8a74-4cc3-b094-64d99a5a7c17",
"name": "Done1",
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "// \u53d6\u5f97\u8f38\u5165\u8cc7\u6599\nconst item = $input.all()[0];\n\n// \u6aa2\u67e5\u662f\u5426\u6709 text \u6b04\u4f4d\u4e26\u66ff\u63db | \u70ba \\n\nif (item.json.text) {\n item.json.text = item.json.text.replace(/\\|/g, '\\n');\n}\n\nreturn [item];"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
1664,
432
],
"id": "ebca5097-4cc5-45cb-9e18-b55487a22f24",
"name": "Code"
},
{
"parameters": {
"operation": "update",
"documentURL": "={{ $('Update Docs').item.json.documentId }}",
"actionsUi": {
"actionFields": [
{
"action": "insert",
"text": "============================================================================\n\nVideo summary :\n\n{{ $json.Video_summary }}\n\n===========================================================================\n\nScript summary :\n\n{{ $json.Script_summary }}"
}
]
}
},
"type": "n8n-nodes-base.googleDocs",
"typeVersion": 2,
"position": [
3520,
432
],
"id": "3297d0b2-0c72-4fa2-948b-c01ab851e8e7",
"name": "Update Docs1",
"credentials": {
"googleDocsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"content": "## Chunk transcript into key sections",
"height": 300,
"width": 340,
"color": 7
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
2512,
288
],
"id": "f479cd67-4554-473f-b4ee-4dd81afe1bb7",
"name": "Sticky Note4"
},
{
"parameters": {
"content": "## Summarise video content\nUsing transcript",
"height": 300,
"width": 340,
"color": 7
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
2880,
288
],
"id": "398dd204-2aad-4a71-ad3e-c82789df90c2",
"name": "Sticky Note5"
},
{
"parameters": {
"workflowId": {
"__rl": true,
"value": "5TgCpCi2jAUFV0lQ",
"mode": "list",
"cachedResultName": "subFlow-line-v1"
},
"workflowInputs": {
"mappingMode": "defineBelow",
"value": {
"content": "YouTube Transcript via Airtable to Notion is done. "
},
"matchingColumns": [
"content"
],
"schema": [
{
"id": "content",
"displayName": "content",
"required": false,
"defaultMatch": false,
"display": true,
"canBeUsedToMatch": true,
"type": "string",
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": true
},
"options": {}
},
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1.2,
"position": [
4432,
432
],
"id": "a9201ab2-18b2-47f6-8008-ca8b11e29837",
"name": "Execute Workflow",
"executeOnce": true
},
{
"parameters": {
"workflowId": {
"__rl": true,
"value": "5TgCpCi2jAUFV0lQ",
"mode": "list",
"cachedResultName": "subFlow-line-v1"
},
"workflowInputs": {
"mappingMode": "defineBelow",
"value": {
"content": "Got webhook for Youtube script. start the task now."
},
"matchingColumns": [
"content"
],
"schema": [
{
"id": "content",
"displayName": "content",
"required": false,
"defaultMatch": false,
"display": true,
"canBeUsedToMatch": true,
"type": "string",
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": true
},
"options": {}
},
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1.2,
"position": [
-96,
448
],
"id": "95ddf2e9-44ec-4d1a-a92b-88bf5ccd6d77",
"name": "Execute Workflow1"
}
],
"connections": {
"Webhook": {
"main": [
[
{
"node": "Execute Workflow1",
"type": "main",
"index": 0
}
]
]
},
"GetRecord": {
"main": [
[
{
"node": "IfIncomplete",
"type": "main",
"index": 0
}
]
]
},
"IfIncomplete": {
"main": [
[
{
"node": "Set input",
"type": "main",
"index": 0
}
],
[
{
"node": "AddNotes",
"type": "main",
"index": 0
}
]
]
},
"Get Actor Run": {
"main": [
[
{
"node": "Get DataSet",
"type": "main",
"index": 0
}
]
]
},
"Get DataSet": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Start Act": {
"main": [
[
{
"node": "Get Actor Run",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Transcript Chunking",
"type": "ai_languageModel",
"index": 0
},
{
"node": "Video Summary",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Video Summary": {
"main": [
[
{
"node": "Set output",
"type": "main",
"index": 0
}
]
]
},
"Transcript Chunking": {
"main": [
[
{
"node": "Video Summary",
"type": "main",
"index": 0
}
]
]
},
"Set output": {
"main": [
[
{
"node": "Update Docs1",
"type": "main",
"index": 0
}
]
]
},
"Set input": {
"main": [
[
{
"node": "Start Act",
"type": "main",
"index": 0
}
]
]
},
"Create Docs": {
"main": [
[
{
"node": "Update Docs",
"type": "main",
"index": 0
}
]
]
},
"Update Docs": {
"main": [
[
{
"node": "Transcript Chunking",
"type": "main",
"index": 0
}
]
]
},
"Done1": {
"main": [
[
{
"node": "Create a database page",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Create Docs",
"type": "main",
"index": 0
}
]
]
},
"Update Docs1": {
"main": [
[
{
"node": "Done1",
"type": "main",
"index": 0
}
]
]
},
"Create a database page": {
"main": [
[
{
"node": "UpdateRecord",
"type": "main",
"index": 0
}
]
]
},
"UpdateRecord": {
"main": [
[
{
"node": "Execute Workflow",
"type": "main",
"index": 0
}
]
]
},
"Execute Workflow1": {
"main": [
[
{
"node": "GetRecord",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1"
},
"staticData": null,
"meta": {
"templateCredsSetupCompleted": true
},
"activeVersionId": null,
"versionCounter": 1,
"shared": [
{
"updatedAt": "2025-07-28T00:37:49.919Z",
"createdAt": "2025-07-28T00:37:49.919Z",
"role": "workflow:owner",
"workflowId": "12h8SlaLyitquaup",
"projectId": "0liZARjPSF29Xm7S",
"project": {
"updatedAt": "2025-05-09T03:15:11.991Z",
"createdAt": "2025-05-09T03:15:09.651Z",
"id": "0liZARjPSF29Xm7S",
"name": "ChengHsien Yang <chenghyang2001@gmail.com>",
"type": "personal",
"icon": null,
"description": null,
"creatorId": "67155d98-04ab-4531-a011-993eff9c535f"
}
}
],
"tags": [
{
"updatedAt": "2025-07-25T06:58:25.520Z",
"createdAt": "2025-07-25T06:58:25.520Z",
"id": "T3UMngUvJRe99xhe",
"name": "webhook"
},
{
"updatedAt": "2025-07-01T06:00:22.350Z",
"createdAt": "2025-07-01T06:00:22.350Z",
"id": "na0TxcppD9SBpFMo",
"name": "airtable"
}
],
"activeVersion": null
}
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.
airtableTokenApigoogleDocsOAuth2ApigoogleDriveOAuth2ApihttpHeaderAuthnotionApiopenAiApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
20250728-airtable-youtube-transcript-v1. Uses airtable, httpRequest, lmChatOpenAi, chainLlm. Webhook trigger; 27 nodes.
Source: https://github.com/chenghyang2001/n8n-workflows/blob/022ee1a4e003aa4829dd0365bd54e8715867ef3f/workflows/20250728-airtable-youtube-transcript-v1.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.
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Airtable, HTTP Request, Google Drive +1
This workflow automates the entire lifecycle of a service-based client, combining four distinct business flows into a single view: Intake Leads: Receives a webhook from your form builder, validates th
Airtable, Notion, Google Calendar +3
Stop manually copy-pasting client data into Word templates. This workflow automates the entire invoicing process, handling complex line items, VAT calculations, PDF generation, and CRM syncing in unde
Airtable, Google Drive, HTTP Request
This workflow automatically saves Zoom meeting recordings to Google Drive and logs all important details into Airtable for easy tracking. Perfect for teams that want a searchable meeting archive. Zoom
Airtable, Google Drive, HTTP Request
Code. Uses httpRequest, extractFromFile, splitInBatches, noOp. Webhook trigger; 51 nodes.
HTTP Request, Chain Llm, OpenAI Chat +1