ApifyとDeepSeek AIを使ってYouTubeチャンネルのコンテンツをGoogleスプレッドシートにバッチで分析する
上級
これは自動化ワークフローで、33個のノードを含みます。主にIf, Set, Code, Wait, Gmailなどのノードを使用。 ApifyとDeepSeek AIを使用してYouTubeチャンネルのコンテンツをGoogleスプレッドシートにバッチで分析
前提条件
- •Googleアカウント + Gmail API認証情報
- •Google Drive API認証情報
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
使用ノード (33)
カテゴリー
-
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "e4f10bef48753951b827b1628c136c25720855dd405c916d09e788211699198e",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "b691c282-853a-4b97-af07-c410654538ad",
"name": "Get_Scraper_Status",
"type": "n8n-nodes-base.httpRequest",
"position": [
320,
560
],
"parameters": {
"url": "=https://api.apify.com/v2/acts/streamers~youtube-scraper/runs/last?token={{ $('Parameters').item.json.Apify_API }}",
"method": "=GET",
"options": {}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "bb9ce463-e613-4aeb-a01e-5b865b475281",
"name": "開始_YouTube_Scraper",
"type": "n8n-nodes-base.httpRequest",
"position": [
-128,
640
],
"parameters": {
"url": "=https://api.apify.com/v2/acts/streamers~youtube-scraper/runs?token={{ $('Parameters').item.json.Apify_API }}",
"method": "POST",
"options": {},
"jsonBody": "={\n \"downloadSubtitles\": true,\n \"hasCC\": false,\n \"hasLocation\": false,\n \"hasSubtitles\": false,\n \"is360\": false,\n \"is3D\": false,\n \"is4K\": false,\n \"isBought\": false,\n \"isHD\": false,\n \"isHDR\": false,\n \"isLive\": false,\n \"isVR180\": false,\n \"maxResultStreams\": 0,\n \"maxResults\": {{ $('Parameters').item.json.Total_number_video }},\n \"maxResultsShorts\": 0,\n \"preferAutoGeneratedSubtitles\": true,\n \"saveSubsToKVS\": true,\n \"startUrls\": [\n {\n \"url\": \"{{ $('Parameters').item.json.Youtuber_MainPage_URL }}\",\n \"method\": \"GET\"\n }\n ]\n}",
"sendBody": true,
"specifyBody": "json"
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "ecdf2cac-ffca-4fcd-b840-1cd7d0fd9c8f",
"name": "Check_Scraper_Status",
"type": "n8n-nodes-base.if",
"position": [
544,
640
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e0da6d3b-2eb2-44b3-8115-455361d77513",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.data.status }}",
"rightValue": "SUCCEEDED"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "b6c12e18-f115-4a76-a1bb-2ce1a0bbab4e",
"name": "Retrieve_Scraped_Data",
"type": "n8n-nodes-base.httpRequest",
"position": [
768,
640
],
"parameters": {
"url": "=https://api.apify.com/v2/acts/streamers~youtube-scraper/runs/last/dataset/items?token={{ $('Parameters').item.json.Apify_API }}&format=json&status=SUCCEEDED",
"method": "=GET",
"options": {}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "5940ced6-dc18-495a-9996-2a3a79f23089",
"name": "Content_Analysis_エージェント",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
576,
1344
],
"parameters": {
"text": "=id:{{ $('Process_Each_Video').item.json.VideoID }}\ntitle:{{ $('Process_Each_Video').item.json['\\uFEFFTitle'] }}\nsubtitle:{{ $('Select_Subtitle_Language').item.json.srt }}\ndescription:{{ $('Process_Each_Video').item.json.Description }}",
"options": {
"systemMessage": "=# Role: Video Content Summarization Specialist\n\n## Profile\n- language: English\n- description: Specializes in analyzing YouTube video transcripts and delivering accurate, structured content summaries across multiple domains.\n- background: Years of experience in content analysis; familiar with the needs of education, research, and professional training contexts.\n- personality: Meticulous, logical, and user-oriented.\n- expertise: Video content analysis, information extraction, structured summary writing.\n- target_audience: Content creators, researchers, educators, and industry professionals.\n\n## Skills\n\n1. Core Summarization Skills\n - Content Analysis: Rapidly identify core themes and key information points in the video.\n - Logical Organization: Present key points in a structured manner ordered by importance.\n - Terminology Handling: Appropriately preserve essential technical terms and critical data.\n\n## Rules\n\n1. Summary Principles:\n - Accuracy: Base strictly on the original transcript; do not add subjective speculation.\n - Completeness: Cover all viewpoints and insights from the video; no word-count limit.\n - Coherence: Segment and express according to the content’s inherent logic.\n\n2. Constraints:\n - Do not include any timestamps.\n - Do not omit essential technical terms.\n - Do not include irrelevant content.\n\n## Workflows\n\n- Objective: Provide high-quality video content summaries for the specified audience.\n- Step 1: Read the transcript thoroughly and identify core themes and key viewpoints.\n- Step 2: Organize the key points in a logical sequence to ensure coherence.\n- Step 3: If no video transcript exists, output only `null` with no additional explanation.\n- Step 4: You must output using the following format:\n{\n \"VideoID\": \"the video's unique id\",\n \"Field\": \"the domain/category the video belongs to\",\n \"Output\": \"the analysis result\"\n}\n\n## Initialization\nAs a Video Content Summarization Specialist, you must adhere to the Rules above and execute the task according to the Workflows.\n"
},
"promptType": "define",
"hasOutputParser": true
},
"retryOnFail": true,
"typeVersion": 2.1
},
{
"id": "75b5d321-80c6-4e7c-8290-34d99aea61f6",
"name": "Output_Parser_Auto_Fix",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
640,
1536
],
"parameters": {
"options": {
"prompt": "Instructions:\n--------------\n{instructions}\n--------------\nCompletion:\n--------------\n{completion}\n--------------\n\nAbove, the Completion did not satisfy the constraints given in the Instructions.\nError:\n--------------\n{error}\n--------------\n\nPlease try again. Please only respond with an answer that satisfies the constraints laid out in the Instructions:"
}
},
"typeVersion": 1
},
{
"id": "2428bea8-507e-4c35-9f74-d0830f380398",
"name": "Structured_Output_Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
736,
1664
],
"parameters": {
"jsonSchemaExample": "{\n \"VideoID\": \"the video's unique id\",\n \"Field\": \"the domain/category the video belongs to\",\n \"Output\": \"the analysis result\"\n}"
},
"typeVersion": 1.3
},
{
"id": "7958ee72-77b0-434e-800e-d20303e99ba0",
"name": "Data_Processing_Script",
"type": "n8n-nodes-base.code",
"position": [
944,
1408
],
"parameters": {
"jsCode": "const results = [];\n\nfor (const item of items) {\n const data = item.json.output; // 取出内部的 output 对象\n\n results.push({\n json: {\n VideoID: data.VideoID,\n Field: data.Field,\n Summary: data.Output\n }\n });\n}\n\nreturn results;\n"
},
"typeVersion": 2
},
{
"id": "c42a9ec1-919c-4de9-9550-c58b922c585c",
"name": "待機_15_Seconds",
"type": "n8n-nodes-base.wait",
"position": [
96,
640
],
"webhookId": "5c354cd1-bb19-43e7-bb98-7ef5b9a05b96",
"parameters": {
"amount": 15
},
"typeVersion": 1.1
},
{
"id": "b2a81c4d-b6d1-43d1-b19b-6c5935a4b872",
"name": "Convert_To_File",
"type": "n8n-nodes-base.convertToFile",
"position": [
992,
640
],
"parameters": {
"options": {}
},
"typeVersion": 1.1
},
{
"id": "d4f8de19-8c86-43e7-bb69-414c560533dd",
"name": "Upload_To_Google_Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
1184,
736
],
"parameters": {
"name": "={{ $('Parameters').item.json.Storing_Name }}",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "root",
"cachedResultName": "/ (Root folder)"
}
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "k3pd0AH9zJsf5yrF",
"name": "owen"
}
},
"retryOnFail": true,
"typeVersion": 3
},
{
"id": "94dc0d4d-4d38-4229-b857-40189710e9b0",
"name": "Extract_From_File",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-448,
1552
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "28641279-d6e3-4836-9b33-780ea0138ad7",
"name": "Download_From_Google_Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
-672,
1552
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Upload_To_Google_Drive').item.json.id }}"
},
"options": {},
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "k3pd0AH9zJsf5yrF",
"name": "owen"
}
},
"retryOnFail": true,
"typeVersion": 3
},
{
"id": "b58658ce-ef88-476e-a610-61be50e99daf",
"name": "Process_Each_Video",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-32,
1552
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "4d0ee473-3d4d-41a3-ac43-5215e5f7315d",
"name": "Select_Subtitle_Language",
"type": "n8n-nodes-base.code",
"position": [
208,
1424
],
"parameters": {
"jsCode": "const items = $input.all();\n\nconst isEnglish = (val) => {\n if (typeof val !== 'string') return false;\n const v = val.toLowerCase();\n return v === 'en' || v === 'english' || v.startsWith('en-') || v.startsWith('en_');\n};\n\nconst out = items.map(({ json: src }) => {\n let A = Number(src.A ?? 0); // select the A-th English track (0 = first)\n let i = 0, res = null;\n\n while (true) {\n const lang = src[`subtitles.${i}.language`];\n if (lang === undefined) break;\n\n if (isEnglish(lang)) {\n if (A === 0) {\n res = {\n index: i,\n language: lang,\n srt: src[`subtitles.${i}.srt`],\n srtUrl: src[`subtitles.${i}.srtUrl`],\n };\n break;\n }\n A--;\n }\n i++;\n }\n\n return { json: res ?? { index: null, language: null, srt: null, srtUrl: null } };\n});\n\nreturn out;"
},
"typeVersion": 2
},
{
"id": "66c57b93-9c38-458d-9ad0-8ffc1cb1f762",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-720,
32
],
"parameters": {
"color": 6,
"width": 496,
"height": 864,
"content": "## 1) Input & Initialization\n**Purpose:** Collect all required inputs and prepare an output destination.\n\n**Covers nodes:** `Parameters (Form Trigger)`, `Create sheet` \n**What it does:** \n- Presents a web form for the target channel and run options. \n- Creates/ensures a Google Sheet **tab** named after your `Storing_Name`.\n\n**Form fields :**\n- **Youtuber_MainPage_URL** — Target channel to crawl. \n _Example:_ `https://www.youtube.com/@n8n-io` \n- **Total_number_video** — How many videos to fetch. \n _Recommended:_ Enter the channel’s **current total video count** to crawl everything. \n- **Storing_Name** — Used as the Google Sheet **tab name** and Drive **file name**. \n _Example:_ `n8n.io` \n- **Apify_API** — Your Apify API token for the YouTube Scraper. \n- **Email** — Where to send a completion notice.\n\n**Outputs produced:** \n- A fresh Sheet tab (named `Storing_Name`) for writing rows later. \n- A validated parameter set that drives the rest of the run.\n\n**Tips:** \n- Keep `Storing_Name` short and readable. \n- For first run, try a small number (10–20) to validate end-to-end."
},
"typeVersion": 1
},
{
"id": "b37d3864-79e8-47f9-8520-a44f75f19946",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1600,
592
],
"parameters": {
"width": 816,
"height": 688,
"content": "# 🚀 YouTuber Crawler — Quick Start Guide\n\n## 📋 Workflow Overview\nThis automated workflow helps you:\n- 🎯 Crawl all videos from a specified YouTuber channel\n- 🤖 Use AI to analyze video content and generate summaries\n- 📊 Save structured data to Google Sheets\n- 📁 Back up raw data to Google Drive\n- 📱 Send processing status notifications via Gmail\n\n## 🔄 How it works\n1) Submit the form\n2) The workflow crawls the channel and waits for the run to finish\n3) Raw JSON is backed up to Google Drive\n4) Data is extracted and processed in batches\n5) Subtitles are auto-selected (EN when available)\n6) AI generates structured summaries\n7) Results are appended to Google Sheets, and you get an email notice\n\n## ✅Prerequisites\n- Create a **Google Sheets** for storage data\n- Configured credentials for **Google Sheets**, **Google Drive** and **Gmail**\n- Configured **DeepSeek API**（Or any LLM model） credentials\n"
},
"typeVersion": 1
},
{
"id": "25bff827-a101-4615-b001-babf3f205fe8",
"name": "Parameters",
"type": "n8n-nodes-base.formTrigger",
"position": [
-576,
720
],
"webhookId": "45bb5142-6b1c-4a54-98fe-b44a39ad0548",
"parameters": {
"options": {},
"formTitle": "={{ $workflow.name }}",
"formFields": {
"values": [
{
"fieldLabel": "Youtuber_MainPage_URL",
"placeholder": "This parameters determines which YouTuber’s channel will be scraped.\nexample: https://www.youtube.com/@n8n-io",
"requiredField": true
},
{
"fieldType": "number",
"fieldLabel": "Total_number_video",
"placeholder": "This parameters determines how much video will be scraped. \n(Recommended: fill in the total number of videos currently on the YouTuber’s channel.)",
"requiredField": true
},
{
"fieldLabel": "Storing_Name",
"placeholder": "This parameter determines the name used for storing the file/data.\nexample: n8n.io"
},
{
"fieldLabel": "Apify_API",
"placeholder": "Fill in your Apify API key.",
"requiredField": true
},
{
"fieldLabel": "Email",
"placeholder": "This parameter specifies the email address to receive notifications when the workflow is completed."
}
]
},
"formDescription": "=Please complete all the parameters listed below."
},
"typeVersion": 2.3
},
{
"id": "c128f91e-9eff-4d16-8478-09564392afe9",
"name": "Send a message",
"type": "n8n-nodes-base.gmail",
"position": [
208,
1856
],
"webhookId": "880710a2-1482-4dde-8a41-c5024dd6c625",
"parameters": {
"sendTo": "={{ $('Parameters').item.json.Email }}",
"message": "= {{ $workflow.name }} finished at 🕓{{ new Date().toLocaleString(\"en-CA\", { hour12: false }).replace(',', '') }}\n",
"options": {
"appendAttribution": true
},
"subject": "=🎉 {{ $workflow.name }} Done~"
},
"credentials": {
"gmailOAuth2": {
"id": "jCTNCiXplqBJRbmj",
"name": "Gmail account"
}
},
"executeOnce": true,
"retryOnFail": true,
"typeVersion": 2.1
},
{
"id": "746238f0-288f-4be9-9378-1499a825045a",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-208,
32
],
"parameters": {
"color": 2,
"width": 1120,
"height": 864,
"content": "## 2) Channel Crawl & Status Loop\n**Purpose:** Start the YouTube crawl and wait for it to finish successfully.\n\n**Covers nodes:** `Start_YouTube_Scraper` → `Wait_15_Seconds` → `Get_Scraper_Status` → `Check_Scraper_Status` → `Retrieve_Scraped_Data` \n**What it does:** \n- Starts the Apify actor against the provided channel URL. \n- Polls for completion at a fixed interval. \n- On success, fetches the final dataset as JSON.\n\n**Inputs consumed:** `Youtuber_MainPage_URL`, `Total_number_video`, `Apify_API` \n**Output produced:** Raw crawl JSON (video list, metadata, subtitles metadata, etc.)"
},
"typeVersion": 1
},
{
"id": "decd4294-a551-4283-a260-b2b0b3db1e8d",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
928,
32
],
"parameters": {
"color": 6,
"width": 432,
"height": 864,
"content": "## 3A) Raw Backup to Google Drive\n**Purpose:** Persist the original crawl dataset as a file in Drive so you have a durable, auditable snapshot of exactly what the scraper returned.\n\n**Covers nodes:** `Convert_To_File` → `Upload_To_Google_Drive`\n\n**What it does:** \n- Converts the JSON dataset into a file artifact. \n- Uploads that file to your chosen Google Drive folder (named with your `Storing_Name`).\n\n**Inputs consumed:** Crawled JSON from the scraper run. \n**Outputs produced:** A raw backup file in Drive (for archival and reprocessing)."
},
"typeVersion": 1
},
{
"id": "a61ec128-8f33-4277-84d1-8822d87152f6",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-112,
928
],
"parameters": {
"color": 3,
"width": 496,
"height": 896,
"content": "## 5) Batch Processing & English Subtitle Selection\n**Purpose:** Process videos in manageable chunks and automatically pick usable subtitles.\n\n**Covers nodes:** `Process_Each_Video`, `Select_Subtitle_Language` \n**What it does:** \n- Splits the stream into batches. \n- Finds the first **English**(`en`) subtitle track when available (SRT text and URL).\n\n\n**Notes:** \n- If a video has no usable english subtitles, the AI summary may be limited. \n- don't change the batch size."
},
"typeVersion": 1
},
{
"id": "b2c5aaed-db92-4384-ad8d-8eaef5a17113",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
928
],
"parameters": {
"color": 4,
"width": 704,
"height": 896,
"content": "## 6) AI Summarization Pipeline (Structured)\n**Purpose:** Generate professional, structured summaries with robust formatting guarantees.\n\n**Covers nodes (pipeline):** \n- **LLM & Agent:** `DeepSeek_Chat_Model`, `Content_Analysis_Agent` \n- **Structure & Auto-fix:** `Structured_Output_Parser`, `Output_Parser_Auto_Fix` \n- **Cleanup:** `Data_Processing_Script` \n\n**What it does:** \n- Sends transcript + metadata into Aiagent. \n- Forces a JSON output schema with `videoid`, `field` (topic/domain), and `output` (summary). \n- Automatically retries/repairs formatting edge cases. \n\n**Outputs produced:** \n- Validated, structured AI results aligned to the schema.\n"
},
"typeVersion": 1
},
{
"id": "fc98de8f-63c6-46ae-9fac-8b1772f279ab",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1120,
928
],
"parameters": {
"color": 5,
"width": 640,
"height": 896,
"content": "## 7)Sheet Write & Gentle Throttling\n**Purpose:** Append results and keep APIs happy.\n\n**Covers nodes:** `Extract_Alldata`, `Write_Contentdata_To_Sheet`, `Wait_2_Seconds` \n**What it does:** \n- Get all data and write them into the sheet. \n- Adds a small delay between items to reduce throttling.\n\n**Output produced:** \n- A complete table: **metadata + AI summary** for each video.\n"
},
"typeVersion": 1
},
{
"id": "4f7fc3dd-8439-4e2d-b110-0cf889c01502",
"name": "付箋8",
"type": "n8n-nodes-base.stickyNote",
"position": [
64,
1728
],
"parameters": {
"color": 5,
"width": 400,
"height": 272,
"content": "## 9) Completion Notification (Email)\n**Purpose:** Let the user know when the whole job is done."
},
"typeVersion": 1
},
{
"id": "3367d34e-7529-4fa6-959e-4eb6a038be32",
"name": "付箋9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-704,
928
],
"parameters": {
"color": 4,
"width": 416,
"height": 896,
"content": "## 4) Reload & Structured Extraction\n**Purpose:** Bring the raw backup back into the workflow and expand it into itemized records for batch processing.\n\n**Covers nodes:** `Download_From_Google_Drive` → `Extract_From_File`\n\n**What it does:** \n- Downloads the just-created Drive file. \n- Extracts JSON rows into individual items that flow into batching, subtitle selection, and AI steps.\n\n**Inputs consumed:** The Drive backup file created in **part3**. \n**Outputs produced:** A stream of structured items (one per video) ready for batching and enrichment."
},
"typeVersion": 1
},
{
"id": "d1dced07-8e95-4174-a2f5-9c00fb3b4789",
"name": "start from?",
"type": "n8n-nodes-base.code",
"disabled": true,
"position": [
-256,
1552
],
"parameters": {
"jsCode": "const START = 0;\n// ================================\nif (!Array.isArray(items)) return items;\n\nconst n = items.length;\nconst s = Number.isFinite(START) && START >= 0 ? START : 0;\n\nif (s >= n) return []; \n\nreturn items.slice(s); "
},
"typeVersion": 2
},
{
"id": "90b79d9c-259c-4508-b1d1-a005dfb351da",
"name": "付箋10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1600,
1360
],
"parameters": {
"color": 3,
"width": 816,
"height": 416,
"content": "## (Advanced) Resume from Drive CSV when workflow fails\n**Purpose:** When AI summarization errors out mid-run, bypass the crawler/backup path and continue processing from CSV in Google Drive—only for the unfinished items.\n\n**How?:** \n- Turn on `Start from?`\n- Temporarily wire `Parameters` → `Download_From_Google_Drive` and disconnect `Parameters` → `Create_Sheet` to skip the crawler branch. \n- Paste the CSVfile **Google Drive file Id** (get it from `Upload_To_Google_Drive`) into `Download_From_Google_Drive`. \n- Use `Start_Row` to process only the **unfinished** rows.\n\n**Partial-run tip:** \n```js\nconst START = 0\n```\n- change \"0\" to skip those item had finished."
},
"typeVersion": 1
},
{
"id": "e03152a8-1392-4d92-b067-4d261209289a",
"name": "待機_2_Seconds",
"type": "n8n-nodes-base.wait",
"position": [
1584,
1616
],
"webhookId": "4e77c4b0-3c7d-402f-9297-212327f7d4ae",
"parameters": {
"amount": 2
},
"typeVersion": 1.1
},
{
"id": "6561ca4a-68f5-4b05-aacf-c76484d663f8",
"name": "Write_Contentdata_To_Sheet1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1408,
1424
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "VideoID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "VideoID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Duration",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Duration",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Likes",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Likes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Field",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Field",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"VideoID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": true
},
"options": {
"cellFormat": "RAW"
},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $('Parameters').item.json.Storing_Name }}"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1rvEoecYv3awJNLa41W7RwRb6YM1L8eZ6t65A0Q6wnIc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1rvEoecYv3awJNLa41W7RwRb6YM1L8eZ6t65A0Q6wnIc/edit?usp=drivesdk",
"cachedResultName": "youtuber scrape"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "i2QQ5h70aiZ7H0s3",
"name": "owen"
}
},
"retryOnFail": true,
"typeVersion": 4.7
},
{
"id": "8116cbb0-9252-4b19-bb70-44209144512a",
"name": "DeepSeek Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatDeepSeek",
"position": [
528,
1664
],
"parameters": {
"options": {}
},
"credentials": {
"deepSeekApi": {
"id": "XqASxHFKyMoe6qdX",
"name": "DeepSeek account"
}
},
"typeVersion": 1
},
{
"id": "6493519d-22c2-4450-9b2c-1699e1861252",
"name": "Extract_Alldata",
"type": "n8n-nodes-base.set",
"position": [
1200,
1408
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3c8320dd-b38e-49ff-9b3c-ca88f469ccad",
"name": "VideoID",
"type": "string",
"value": "={{ $('Process_Each_Video').item.json.id }}"
},
{
"id": "2b00dcfd-b55b-47e7-a11e-790389c90a8c",
"name": "Title",
"type": "string",
"value": "={{ $('Process_Each_Video').item.json['\\uFEFFtitle'] }}"
},
{
"id": "2ffc02ec-ae5e-440c-8e5f-1b9083dc44b0",
"name": "Duration",
"type": "string",
"value": "={{ $('Process_Each_Video').item.json.duration }}"
},
{
"id": "adc143bc-2934-4a39-a96d-e996e2b64fc2",
"name": "Date",
"type": "string",
"value": "={{ $('Process_Each_Video').item.json.date }}"
},
{
"id": "fd284be2-851b-4da9-bb09-d368e89ff590",
"name": "URL",
"type": "string",
"value": "={{ $('Process_Each_Video').item.json.url }}"
},
{
"id": "1ae57f58-5908-468c-803d-857dd72181be",
"name": "Likes",
"type": "string",
"value": "={{ $('Process_Each_Video').item.json.likes }}"
},
{
"id": "e66dedb2-609c-4d2b-8c0a-e4a8451dddb2",
"name": "Description",
"type": "string",
"value": "={{ $('Process_Each_Video').item.json.text }}"
},
{
"id": "8405d779-9f1a-4b30-9a8f-3fccc6677f22",
"name": "Field",
"type": "string",
"value": "={{ $('Data_Processing_Script').item.json.Field }}"
},
{
"id": "a11425da-157d-4bd3-a02f-ea0ae44a7034",
"name": "Summary",
"type": "string",
"value": "={{ $('Data_Processing_Script').item.json.Summary }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "2508e77d-61d2-4d5d-bdc8-71544e9370a1",
"name": "Create_Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-368,
688
],
"parameters": {
"title": "={{ $('Parameters').item.json.Storing_Name }}",
"options": {},
"operation": "create",
"documentId": {
"__rl": true,
"mode": "list",
"value": "1rvEoecYv3awJNLa41W7RwRb6YM1L8eZ6t65A0Q6wnIc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1rvEoecYv3awJNLa41W7RwRb6YM1L8eZ6t65A0Q6wnIc/edit?usp=drivesdk",
"cachedResultName": "youtuber scrape"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "i2QQ5h70aiZ7H0s3",
"name": "owen"
}
},
"retryOnFail": true,
"typeVersion": 4.7,
"alwaysOutputData": true
}
],
"pinData": {},
"connections": {
"25bff827-a101-4615-b001-babf3f205fe8": {
"main": [
[
{
"node": "2508e77d-61d2-4d5d-bdc8-71544e9370a1",
"type": "main",
"index": 0
}
]
]
},
"d1dced07-8e95-4174-a2f5-9c00fb3b4789": {
"main": [
[
{
"node": "b58658ce-ef88-476e-a610-61be50e99daf",
"type": "main",
"index": 0
}
]
]
},
"2508e77d-61d2-4d5d-bdc8-71544e9370a1": {
"main": [
[
{
"node": "Start_YouTube_Scraper",
"type": "main",
"index": 0
}
]
]
},
"Wait_2_Seconds": {
"main": [
[
{
"node": "b58658ce-ef88-476e-a610-61be50e99daf",
"type": "main",
"index": 0
}
]
]
},
"b2a81c4d-b6d1-43d1-b19b-6c5935a4b872": {
"main": [
[
{
"node": "d4f8de19-8c86-43e7-bb69-414c560533dd",
"type": "main",
"index": 0
}
]
]
},
"6493519d-22c2-4450-9b2c-1699e1861252": {
"main": [
[
{
"node": "6561ca4a-68f5-4b05-aacf-c76484d663f8",
"type": "main",
"index": 0
}
]
]
},
"Wait_15_Seconds": {
"main": [
[
{
"node": "b691c282-853a-4b97-af07-c410654538ad",
"type": "main",
"index": 0
}
]
]
},
"94dc0d4d-4d38-4229-b857-40189710e9b0": {
"main": [
[
{
"node": "d1dced07-8e95-4174-a2f5-9c00fb3b4789",
"type": "main",
"index": 0
}
]
]
},
"b691c282-853a-4b97-af07-c410654538ad": {
"main": [
[
{
"node": "ecdf2cac-ffca-4fcd-b840-1cd7d0fd9c8f",
"type": "main",
"index": 0
}
]
]
},
"b58658ce-ef88-476e-a610-61be50e99daf": {
"main": [
[
{
"node": "c128f91e-9eff-4d16-8478-09564392afe9",
"type": "main",
"index": 0
}
],
[
{
"node": "4d0ee473-3d4d-41a3-ac43-5215e5f7315d",
"type": "main",
"index": 0
}
]
]
},
"8116cbb0-9252-4b19-bb70-44209144512a": {
"ai_languageModel": [
[
{
"node": "Content_Analysis_Agent",
"type": "ai_languageModel",
"index": 0
},
{
"node": "75b5d321-80c6-4e7c-8290-34d99aea61f6",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"ecdf2cac-ffca-4fcd-b840-1cd7d0fd9c8f": {
"main": [
[
{
"node": "b6c12e18-f115-4a76-a1bb-2ce1a0bbab4e",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait_15_Seconds",
"type": "main",
"index": 0
}
]
]
},
"b6c12e18-f115-4a76-a1bb-2ce1a0bbab4e": {
"main": [
[
{
"node": "b2a81c4d-b6d1-43d1-b19b-6c5935a4b872",
"type": "main",
"index": 0
}
]
]
},
"Start_YouTube_Scraper": {
"main": [
[
{
"node": "Wait_15_Seconds",
"type": "main",
"index": 0
}
]
]
},
"Content_Analysis_Agent": {
"main": [
[
{
"node": "7958ee72-77b0-434e-800e-d20303e99ba0",
"type": "main",
"index": 0
}
]
]
},
"7958ee72-77b0-434e-800e-d20303e99ba0": {
"main": [
[
{
"node": "6493519d-22c2-4450-9b2c-1699e1861252",
"type": "main",
"index": 0
}
]
]
},
"75b5d321-80c6-4e7c-8290-34d99aea61f6": {
"ai_outputParser": [
[
{
"node": "Content_Analysis_Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"d4f8de19-8c86-43e7-bb69-414c560533dd": {
"main": [
[
{
"node": "28641279-d6e3-4836-9b33-780ea0138ad7",
"type": "main",
"index": 0
}
]
]
},
"4d0ee473-3d4d-41a3-ac43-5215e5f7315d": {
"main": [
[
{
"node": "Content_Analysis_Agent",
"type": "main",
"index": 0
}
]
]
},
"2428bea8-507e-4c35-9f74-d0830f380398": {
"ai_outputParser": [
[
{
"node": "75b5d321-80c6-4e7c-8290-34d99aea61f6",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"28641279-d6e3-4836-9b33-780ea0138ad7": {
"main": [
[
{
"node": "94dc0d4d-4d38-4229-b857-40189710e9b0",
"type": "main",
"index": 0
}
]
]
},
"6561ca4a-68f5-4b05-aacf-c76484d663f8": {
"main": [
[
{
"node": "Wait_2_Seconds",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
n8nノードの探索（可視化リファレンスライブラリ内）
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
自動化学術論文メタデータおよび変数抽出（GeminiからGoogle Sheetsへ）
論文のメタデータおよび変数抽出の自動化：GeminiからGoogle Sheetsへ
Set
Code
Wait
+
Set
Code
Wait
39 ノードOwenLee
文書抽出
WordPressブログの自動化プロフェッショナル版（先端研究）v2.1マーケットプラグイン
GPT-4o、Perplexity AI、そして多言語対応を使ったSEO最適化ブログ作成の自動化
If
Set
Xml
+
If
Set
Xml
125 ノードDaniel Ng
コンテンツ作成
BrightData の週次比較
Bright Data、GPT-4.1、Google Workspaceを使用した自動ウェブサイト変更監視
If
Set
Code
+
If
Set
Code
35 ノードDaniel Shashko
人工知能
ペットショップ 4
ペットショップ予約AIエージェント
If
Set
Code
+
If
Set
Code
187 ノードBruno Dias
人工知能
第一轮 Telegram と LinkedIn 快速通道 AI 招聘アシスタント
AI候选人筛选流程：LinkedInへTelegram，統合Gemini与Apify
If
Set
Code
+
If
Set
Code
55 ノードDean Pike
人事
