January 22, 2026

YouTube to Google Sheets, ranked video ideas fast

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

You open YouTube for “quick research,” then lose an hour bouncing between tabs, copying titles, and trying to remember which videos looked promising. By the time you’ve gathered 20 links, you’re already second-guessing the data (and honestly, your own notes).

This YouTube Sheets automation hits content strategists first, but marketing managers and agency leads feel it too. You get a ranked, shareable list of video ideas in Google Sheets, built from real YouTube search results and scored for performance.

Below, you’ll see how the workflow pulls video and channel stats, scores each result, and appends everything into a clean Sheet you can actually use.

How This Automation Works

See how this solves the problem:

n8n Workflow Template: YouTube to Google Sheets, ranked video ideas fast

Click to explore

flowchart LR

    subgraph sg0["On form submission Flow"]
        direction LR
        n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Get Video Data"]
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Get Video IDs"]
        n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Extract IDs"]
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Extract Video Data"]
        n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Video Performance"]
        n5@{ icon: "mdi:database", form: "rounded", label: "Append row in sheet", pos: "b", h: 48 }
        n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/form.svg' width='40' height='40' /></div><br/>On form submission"]
        n7["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Get Channel Statistics"]
        n8["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Merge"]
        n9["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Channel Data"]
        n10["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Code"]
        n11@{ icon: "mdi:swap-vertical", form: "rounded", label: "Loop Over Items", pos: "b", h: 48 }
        n12@{ icon: "mdi:cog", form: "rounded", label: "Wait", pos: "b", h: 48 }
        n13@{ icon: "mdi:swap-vertical", form: "rounded", label: "Set you keys", pos: "b", h: 48 }
        n10 --> n5
        n12 --> n11
        n8 --> n10
        n2 --> n11
        n9 --> n8
        n13 --> n1
        n1 --> n2
        n0 --> n3
        n0 --> n7
        n11 --> n0
        n4 --> n8
        n3 --> n4
        n6 --> n13
        n5 --> n12
        n7 --> n9
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n6 trigger
    class n5 database
    class n0,n1,n7 api
    class n2,n3,n4,n9,n10 code
    classDef customIcon fill:none,stroke:none
    class n0,n1,n2,n3,n4,n6,n7,n8,n9,n10 customIcon

The Challenge: YouTube Research That Never Stays Organized

YouTube research sounds simple until you try to do it consistently. You search a topic, open 15 videos, check views, skim comments, peek at the channel, then paste a few links into a doc you’ll never find again. Next week you repeat the whole process because your “research” doesn’t include enough context to be reusable. The worst part is the mental load: you’re making judgment calls with half the data, and your shortlist ends up biased toward whatever caught your eye first.

It adds up fast. Here’s where it usually breaks down.

You copy titles and URLs manually, then forget to capture the numbers that actually matter (views, likes, comments, publish date).
Channel context is missing, so you can’t tell if a “viral” video is impressive or just normal for that creator.
Different teammates track research differently, which turns sharing into a cleanup project.
You can’t compare results across searches because the format changes every time.

The Fix: Bulk YouTube Scoring Sent Straight to Google Sheets

This n8n workflow turns messy YouTube browsing into a repeatable research machine. You submit a search term in a simple form, choose the video format (short, medium, or long), and decide how many results you want to analyze. From there, the workflow talks to the YouTube API to pull a batch of video IDs, fetches detailed video metrics, then also fetches channel statistics for each creator. It merges those streams, calculates performance signals (including a quick “view ratio” style classification), and scores each video with an easy label so you can sort and decide fast. Finally, it appends a clean row into Google Sheets with the thumbnail, URL, stats, and scoring.

The workflow starts with a form submission. Then it gathers video identifiers, loops through them in batches, and fetches both video details and channel stats. When everything is combined and scored, Google Sheets becomes your living research library, not a one-off pastebin.

What Changes: Before vs. After

What This Eliminates

Impact You’ll See

Manually collecting video URLs and trying to keep them in order.
Checking views, likes, and comments one video at a time.
Opening extra tabs to investigate each channel’s context.
Reformatting research so your team can actually review it.

Most teams go from “half a day of research” to about 20 minutes.
A consistent scoring label makes sorting and prioritizing much faster.
Cleaner comparisons because every row has the same data fields.
Fewer bad picks, since channel stats sit next to video stats.
A shareable Sheet you can reuse for every new topic.

Real-World Impact

Say you research 3 topics per week and pull 25 videos per topic. Manually, you might spend about 3 minutes per video to capture the URL, title, views, likes, comments, and a quick channel check, which is roughly 4 hours weekly. With this workflow, you spend about 5 minutes submitting the forms, then wait while n8n fetches and scores everything and appends it to Google Sheets. You get most of that time back, and your list is standardized every time.

Requirements

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets for storing and sharing the ranked list
YouTube Data API to fetch video and channel stats
Google API Key (get it from Google Developers Console)

Skill level: Intermediate. You’ll connect credentials, paste a Sheet ID, and run a form-triggered workflow.

Need help implementing this? Talk to an automation expert (free 15-minute consultation).

The Workflow Flow

A form submission kicks it off. You enter a search term, pick a format (short/medium/long), and choose how many videos to pull. n8n stores those inputs so every downstream request uses the same settings.

YouTube search results are fetched and cleaned. The workflow retrieves video identifiers via HTTP requests, then derives video IDs so it can request full details without messy parsing later.

Video metrics and channel stats get combined. For each video (processed in batches), n8n pulls video details, then pulls channel statistics, and merges both streams. That’s what makes the scoring more meaningful than “views only.”

Scoring and classification happen before the export. Code steps parse metrics, score performance, and classify view ratios so the final result is easier to sort in Google Sheets. A Wait node spaces out cycles to reduce failed calls during bulk runs.

You can easily modify the scoring rules to match your niche (for example, weighting comments more heavily) based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Form Trigger

Set up the form that will collect the search term, format, and video count to drive the workflow.

Add a Form Submission Trigger node as the trigger.
Set Form Title to test and Form Description to tets.
Confirm the form fields include Share your idea?, Format (dropdown with short, medium, long), and Number of Videos.

Step 2: Connect YouTube API Inputs and Search

Map form values into API parameters and search YouTube for matching videos.

In Assign API Inputs, set api_key to your key (replace [CONFIGURE_YOUR_API_KEY]).
Set search_term to {{ $json["Share your idea?"] }}, format to {{ $json.Format }}, and videoLimit to {{ $json["Number of Videos"] }}.
In Retrieve Video Identifiers, set URL to https://www.googleapis.com/youtube/v3/search and keep query parameters like maxResults as {{ $json.videoLimit || 1}} and q as {{ $json.search_term }}.
Ensure the API key parameter uses {{ $json.api_key }}.

⚠️ Common Pitfall: If the form field labels change, update the expressions in Assign API Inputs to match the new names.

Step 3: Set Up ID Extraction and Video Iteration

Extract video IDs and iterate through them in batches for detail retrieval.

In Derive Video IDs, keep the JavaScript code that maps videoItem?.id?.videoId into a videoid field.
Connect Derive Video IDs to Iterate Video Items to process each ID.
Leave Iterate Video Items options as default unless you want to limit batch size.

Step 4: Fetch Video and Channel Details in Parallel

Pull video statistics and channel statistics, then combine the results for scoring and classification.

In Fetch Video Details, set URL to https://www.googleapis.com/youtube/v3/videos and keep id as {{ $json.videoid }} and key as {{ $('Assign API Inputs').item.json.api_key }}.
Fetch Video Details outputs to both Parse Video Metrics and Fetch Channel Stats in parallel.
In Fetch Channel Stats, keep id as {{ $json.items[0].snippet.channelId }} and key as {{ $('Assign API Inputs').item.json.api_key }}.
Keep Parse Video Metrics and Channel Metrics code blocks as-is to normalize fields.
In Score Video Performance, leave the scoring logic intact to calculate performance and performanceText.
Merge the two data streams in Combine Streams using Mode combine and Combine By combineAll.
Classify the view-to-subscriber ratio in Classify View Ratio to add label and viewToSubRatio.

⚠️ Common Pitfall: If the YouTube API returns missing channel data, Fetch Channel Stats may fail. Validate API quota and response structure.

Step 5: Configure the Google Sheets Output

Append the final enriched metrics into your spreadsheet.

Open Append Sheet Row and select the target spreadsheet Document and Sheet.
Keep Operation as append and Use Append enabled.
Confirm the columns include fields like viewCount, subscriberCount, performance, performanceText, label, and viewToSubRatio.
Credential Required: Connect your googleSheetsOAuth2Api credentials.

Step 6: Test and Activate Your Workflow

Run a full test from the form to ensure data flows correctly into Google Sheets, then activate the workflow.

Use the Form Submission Trigger test form to submit a sample query.
Verify that Retrieve Video Identifiers returns results and that Fetch Video Details runs for each ID.
Check that Combine Streams outputs unified records and Append Sheet Row writes new rows.
Click Activate to enable production execution after a successful test.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Watch Out For

YouTube Data API credentials can expire or hit quota limits. If things break, check your Google Cloud Console quotas and the API key stored in n8n credentials first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Common Questions

How quickly can I implement this YouTube Sheets automation?

Usually under an hour once your API key and Sheet are ready.

Can non-technical teams implement this video research automation?

Yes. You’ll mostly connect accounts, paste a Sheet ID, and run the form trigger.

Is n8n free to use for this YouTube Sheets automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in YouTube Data API usage (it’s quota-based, and heavy bulk pulls can consume daily limits).

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

How do I adapt this YouTube Sheets automation solution to my specific challenges?

You can change the inputs in the “Assign API Inputs” step to support different search rules, like region, language, or upload recency. If you want a different scoring model, adjust the “Score Video Performance” and “Classify View Ratio” code steps to weight the metrics you care about. Many teams also add extra columns before “Append Sheet Row,” like a niche label, campaign name, or an “assigned to” owner for review.

Why is my YouTube connection failing in this workflow?

Usually it’s an invalid or restricted API key, or you’ve hit a quota limit for the day. Regenerate the key (or adjust restrictions) in Google Cloud Console, then update the credential in n8n. Also check that the YouTube Data API is enabled for the project you created. If failures happen mid-run, increase the workflow’s wait time so you’re not hammering the API during bulk batches.

What’s the capacity of this YouTube Sheets automation solution?

It’s mostly constrained by YouTube API quota and how aggressively you batch. On self-hosted n8n there’s no execution cap, but bulk runs can still be slowed by rate limits, so plan on processing in batches and letting the Wait node pace requests.

Is this YouTube Sheets automation better than using Zapier or Make?

Often, yes, because this workflow isn’t a simple “trigger then log a row.” You’re doing multiple API calls per item (search results, video details, channel stats), plus merges and custom scoring logic. n8n handles branching and code-based transformations cleanly without pushing you into expensive task pricing for every little step. Zapier or Make can still work if you keep the scope small, but it gets clunky when you want batching and richer scoring. If you’re unsure, Talk to an automation expert and we’ll map it to your volume.

You don’t need more “ideas.” You need a repeatable way to prove which ideas are worth making, then share that proof in one place.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"name": "YouTube Video Research Automation",
"meta": {
"instanceId": "00f55835d1d48afe77fbd5c67f11b38f82b8990f4d49ad4931b242fa0549c5c2",
"templateId": null,
"templateCredsSetupCompleted": null
},
"nodes": [
{
"id": "flowpast-topbar-6427",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 805,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "fa800f3c-f679-4d51-a3dc-30c07531e7e1",
"name": "Fetch Video Details",
"type": "n8n-nodes-base.httpRequest",
"position": [
225,
385
],
"parameters": {
"url": "https://www.googleapis.com/youtube/v3/videos",
"options": [],
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "part",
"value": "snippet,statistics,contentDetails,status,topicDetails,recordingDetails,liveStreamingDetails,localizations,player"
},
{
"name": "id",
"value": "={{ $json.videoid }}"
},
{
"name": "key",
"value": "={{ $('Assign API Inputs').item.json.api_key }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Accept",
"value": "application/json"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "7d1d2e06-a1ab-4e37-8e27-fe30abe312fd",
"name": "Retrieve Video Identifiers",
"type": "n8n-nodes-base.httpRequest",
"position": [
260,
120
],
"parameters": {
"url": "https://www.googleapis.com/youtube/v3/search",
"options": [],
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "part",
"value": "snippet"
},
{
"name": "maxResults",
"value": "={{ $json.videoLimit || 1}}"
},
{
"name": "order",
"value": "viewCount"
},
{
"name": "publishedAfter",
"value": "={{ $now.minus({days: 7}).startOf('day').toISO() }}"
},
{
"name": "publishedBefore",
"value": "={{ $now.toISO() }}"
},
{
"name": "q",
"value": "={{ $json.search_term }}"
},
{
"name": "type",
"value": "video"
},
{
"name": "videoDuration",
"value": "={{ $json.format }}"
},
{
"name": "key",
"value": "={{ $json.api_key }}"
},
{
"name": "regionCode",
"value": "US"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Accept",
"value": "application/json"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "9c779f52-da65-4d4d-943f-982eb87a6170",
"name": "Derive Video IDs",
"type": "n8n-nodes-base.code",
"position": [
0,
145
],
"parameters": {
"jsCode": "const items = $input.all();\nreturn items.flatMap(item => \n  (item.json?.items || []).map(videoItem => ({\n    json: {\n      videoid: videoItem?.id?.videoId || null\n    }\n  }))\n);"
},
"typeVersion": 2
},
{
"id": "05d526bd-92ec-4ff4-8fa1-526fc44eace7",
"name": "Parse Video Metrics",
"type": "n8n-nodes-base.code",
"position": [
515,
325
],
"parameters": {
"jsCode": "const items = $input.all();\nreturn items.flatMap(item =>\n  (item.json?.items || []).map(videoItem => ({\n    json: {\n      channelTitle: videoItem.snippet?.channelTitle || '',\n      channel:\"https://www.youtube.com/channel/\"+$input.first().json.items[0].snippet.channelId,\n      title: videoItem.snippet?.title || '',\n      viewCount: videoItem.statistics?.viewCount || 0,\n      likeCount: videoItem.statistics?.likeCount || 0,\n      commentCount: videoItem.statistics?.commentCount || 0,\n      videoURL: `https://www.youtube.com/watch?v=${videoItem.id || ''}`,\n      thumbnail: videoItem.snippet?.thumbnails?.maxres?.url || '',\n      thumbnailPreview:`=IMAGE(\"${videoItem.snippet?.thumbnails?.maxres?.url || ''}\" ,4,200,150)`\n    }\n  }))\n);"
},
"typeVersion": 2
},
{
"id": "51b68aa9-1ee9-434d-8509-2f7488764969",
"name": "Score Video Performance",
"type": "n8n-nodes-base.code",
"position": [
670,
390
],
"parameters": {
"jsCode": "const items = $input.all();\nreturn items.map(item => {\n  const viewCount = parseInt(String(item.json?.viewCount || '0'), 10);\n  const likeCount = parseInt(String(item.json?.likeCount || '0'), 10);\n  const commentCount = parseInt(String(item.json?.commentCount || '0'), 10);\n\n  \n  let performance = 0;\n  \n  if (viewCount > 0) {\n    // Calculate engagement rate and scale by 10x for more realistic YouTube scores\n    const engagementRate = ((likeCount + commentCount) / viewCount) * 1000; // 10x boost\n    performance = Math.min(Math.max(engagementRate, 0), 100);\n  }\n  \n  const roundedPerformance = Math.round(performance);\n  \n  let performanceText = \"\ud83d\udc80 Dead\";\n  \n  // Adjusted thresholds for realistic YouTube engagement rates (much stricter)\n  if (roundedPerformance >= 80) {\n    performanceText = \"\ud83d\ude80 HOLY HELL\"; // 8%+ engagement = truly exceptional/viral\n  } else if (roundedPerformance >= 60) {\n    performanceText = \"\ud83d\udd25 INSANE\"; // 6%+ engagement = insane performance\n  } else if (roundedPerformance >= 40) {\n    performanceText = \"\ud83d\udcaa CRUSHING IT\"; // 4%+ engagement = crushing it\n  } else if (roundedPerformance >= 30) {\n    performanceText = \"\u2b50 Stellar\"; // 3%+ engagement = stellar\n  } else if (roundedPerformance >= 20) {\n    performanceText = \"\ud83d\udcaa Strong\"; // 2%+ engagement = strong\n  } else if (roundedPerformance >= 15) {\n    performanceText = \"\ud83d\ude0a Good\"; // 1.5%+ engagement = good\n  } else if (roundedPerformance >= 10) {\n    performanceText = \"\ud83d\ude42 Decent\"; // 1%+ engagement = decent\n  } else if (roundedPerformance >= 5) {\n    performanceText = \"\ud83d\ude10 Average\"; // 0.5%+ engagement = average\n  } else {\n    // Use switch for very low scores (0-4%)\n    switch(roundedPerformance) {\n      case 0: performanceText = \"\ud83d\udc80 Dead\"; break;\n      case 1: performanceText = \"\ud83d\ude34 Sleeping\"; break;\n      case 2: performanceText = \"\ud83d\ude10 Meh\"; break;\n      case 3: performanceText = \"\ud83d\ude15 Not good\"; break;\n      case 4: performanceText = \"\ud83d\ude1e Poor\"; break;\n      default: performanceText = \"\ud83d\udc80 Dead\";\n    }\n  }\n  $input.first().json.performance = performance;\n  $input.first().json.performanceText = performanceText;\n  \n  \n  return {\n    ...$json\n  };\n});"
},
"typeVersion": 2
},
{
"id": "8bf37e0f-9b9c-4f16-be2e-02ea952c4488",
"name": "Append Sheet Row",
"type": "n8n-nodes-base.googleSheets",
"position": [
250,
595
],
"parameters": {
"columns": {
"value": [],
"schema": [
{
"id": "viewCount",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "viewCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subscriberCount",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "subscriberCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "hiddenSubscriberCount",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "hiddenSubscriberCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "videoCount",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "videoCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "channelTitle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "channelTitle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "channel",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "channel",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "likeCount",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "likeCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "commentCount",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "commentCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "videoURL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "videoURL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "thumbnail",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "thumbnail",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "thumbnailPreview",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "thumbnailPreview",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "performance",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "performance",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "performanceText",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "performanceText",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "youtubeUrl",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "youtubeUrl",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "label",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "label",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "viewToSubRatio",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "viewToSubRatio",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"useAppend": true
},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=0",
"cachedResultName": "Youtube Videos"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit?usp=drivesdk",
"cachedResultName": "YouTube Viral Videos"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.6
},
{
"id": "433ee6cf-2c84-4131-9bf8-a0f00d1c04ca",
"name": "Form Submission Trigger",
"type": "n8n-nodes-base.formTrigger",
"position": [
705,
130
],
"webhookId": "77ab6399-3597-439f-a2b2-3641e7a4fceb",
"parameters": {
"options": [],
"formTitle": "test",
"formFields": {
"values": [
{
"fieldLabel": "Share your idea?",
"placeholder": "Eg. Best automation tool",
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "Format",
"fieldOptions": {
"values": [
{
"option": "short"
},
{
"option": "medium"
},
{
"option": "long"
}
]
},
"requiredField": true
},
{
"fieldType": "number",
"fieldLabel": "Number of Videos",
"placeholder": "Enter number of video to research by default 1",
"requiredField": true
}
]
},
"formDescription": "tets"
},
"typeVersion": 2.2
},
{
"id": "e7daac48-5d66-4ba3-8753-614f46d40515",
"name": "Fetch Channel Stats",
"type": "n8n-nodes-base.httpRequest",
"position": [
325,
215
],
"parameters": {
"url": "https://www.googleapis.com/youtube/v3/channels",
"options": {
"redirect": {
"redirect": []
}
},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "part",
"value": "snippet,statistics,contentDetails"
},
{
"name": "id",
"value": "={{ $json.items[0].snippet.channelId }}"
},
{
"name": "key",
"value": "={{ $('Assign API Inputs').item.json.api_key }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "f06636a4-df6c-4de4-bfed-6b44b5835c85",
"name": "Combine Streams",
"type": "n8n-nodes-base.merge",
"position": [
675,
580
],
"parameters": {
"mode": "combine",
"options": [],
"combineBy": "combineAll"
},
"typeVersion": 3.2
},
{
"id": "d97a43b5-4646-4e2b-b6f3-e815dac5eeed",
"name": "Channel Metrics",
"type": "n8n-nodes-base.code",
"position": [
455,
235
],
"parameters": {
"jsCode": "// Loop over input items and add a new field called 'myNewField' to the JSON of each one\nvar json = {}\n\njson = $input.first().json.items[0].statistics;\n\n\nreturn [json];"
},
"typeVersion": 2
},
{
"id": "2856d447-5cc2-428b-a443-d6cd9d0d2ecd",
"name": "Classify View Ratio",
"type": "n8n-nodes-base.code",
"position": [
405,
645
],
"parameters": {
"jsCode": "return $input.all().map(item => {\n  const views = parseInt(item.json.viewCount || '0');\n  const subs = parseInt(item.json.subscriberCount || '0');\n\n  let label = '';\n  const ratio = subs > 0 ? views / subs : 0;\n\n  if ((subs < 500 && views > 5000) || (ratio > 1 && subs > 1000)) {\n    label = 'Outlier';\n  } else if (ratio < 0.02) {\n    label = 'Bad';\n  } else if (ratio >= 0.02 && ratio < 0.1) {\n    label = 'Okay';\n  } else if (ratio >= 0.1) {\n    label = 'Good';\n  } else {\n    label = 'Uncategorized';\n  }\n\n  return {\n    json: {\n      ...item.json,\n      label,\n      viewToSubRatio: ratio.toFixed(4)\n    }\n  };\n});\n"
},
"typeVersion": 2
},
{
"id": "2d5c7fe7-ae08-4919-937b-d089dcacb07a",
"name": "Iterate Video Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
70,
330
],
"parameters": {
"options": []
},
"typeVersion": 3
},
{
"id": "cffd4aad-67c7-405b-b1bf-816e93db3c01",
"name": "Delay Cycle",
"type": "n8n-nodes-base.wait",
"position": [
20,
640
],
"webhookId": "7f98e718-4009-410d-8039-6ef89e198c97",
"parameters": {
"amount": 2
},
"typeVersion": 1.1
},
{
"id": "e0e91135-4c24-4566-8eb2-4d23fc133b1c",
"name": "Assign API Inputs",
"type": "n8n-nodes-base.set",
"position": [
420,
155
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "e04aa951-a569-4adc-ae0f-727e5b678ed9",
"name": "api_key",
"type": "string",
"value": "[CONFIGURE_YOUR_API_KEY]"
},
{
"id": "490f5e38-e3eb-463e-8716-9ac1f92651c8",
"name": "search_term",
"type": "string",
"value": "={{ $json[\"Share your idea?\"] }}"
},
{
"id": "69b72b2f-6edc-4a00-b4e9-3e72a48e1322",
"name": "format",
"type": "string",
"value": "={{ $json.Format }}"
},
{
"id": "545e6c23-0b63-4461-b9e2-dd8ff1fd00bd",
"name": "videoLimit",
"type": "string",
"value": "={{ $json[\"Number of Videos\"] }}"
}
]
}
},
"typeVersion": 3.4
}
],
"pinData": [],
"connections": {
"Classify View Ratio": {
"main": [
[
{
"node": "Append Sheet Row",
"type": "main",
"index": 0
}
]
]
},
"Delay Cycle": {
"main": [
[
{
"node": "Iterate Video Items",
"type": "main",
"index": 0
}
]
]
},
"Combine Streams": {
"main": [
[
{
"node": "Classify View Ratio",
"type": "main",
"index": 0
}
]
]
},
"Derive Video IDs": {
"main": [
[
{
"node": "Iterate Video Items",
"type": "main",
"index": 0
}
]
]
},
"Channel Metrics": {
"main": [
[
{
"node": "Combine Streams",
"type": "main",
"index": 0
}
]
]
},
"Assign API Inputs": {
"main": [
[
{
"node": "Retrieve Video Identifiers",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Video Identifiers": {
"main": [
[
{
"node": "Derive Video IDs",
"type": "main",
"index": 0
}
]
]
},
"Fetch Video Details": {
"main": [
[
{
"node": "Parse Video Metrics",
"type": "main",
"index": 0
},
{
"node": "Fetch Channel Stats",
"type": "main",
"index": 0
}
]
]
},
"Iterate Video Items": {
"main": [
[],
[
{
"node": "Fetch Video Details",
"type": "main",
"index": 0
}
]
]
},
"Score Video Performance": {
"main": [
[
{
"node": "Combine Streams",
"type": "main",
"index": 1
}
]
]
},
"Parse Video Metrics": {
"main": [
[
{
"node": "Score Video Performance",
"type": "main",
"index": 0
}
]
]
},
"Form Submission Trigger": {
"main": [
[
{
"node": "Assign API Inputs",
"type": "main",
"index": 0
}
]
]
},
"Append Sheet Row": {
"main": [
[
{
"node": "Delay Cycle",
"type": "main",
"index": 0
}
]
]
},
"Fetch Channel Stats": {
"main": [
[
{
"node": "Channel Metrics",
"type": "main",
"index": 0
}
]
]
}
},
"versionId": null
}