ChannelCrawlerとGPTを使用してGoogle SlidesでYouTubeチャンネルプロフィールレポートを作成
中級
これはMarket Research, AI Summarization分野の自動化ワークフローで、15個のノードを含みます。主にCode, FormTrigger, HttpRequest, GoogleSlides, SplitInBatchesなどのノードを使用。 ChannelCrawlerとGPT-4を使ってGoogle Slides内でYouTubeチャンネルデータレポートを生成
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •OpenAI API Key
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "XvIOD0Q9wc7392w9",
"meta": {
"instanceId": "a01833781c2355cf72c14f621544f956f9bdfe31ca9d6f99e674faa4514926e8"
},
"name": "Create YouTube Channel Profile Reports in Google Slides with ChannelCrawler & GPT",
"tags": [],
"nodes": [
{
"id": "533d9323-5756-43aa-8008-fff04ca902e7",
"name": "フォーム送信時",
"type": "n8n-nodes-base.formTrigger",
"position": [
592,
208
],
"webhookId": "d440b07c-587f-49ee-90a3-f5b2de63cb9d",
"parameters": {
"options": {},
"formTitle": "Youtube Persona Slide Creator",
"formFields": {
"values": [
{
"fieldType": "textarea",
"fieldLabel": "Youtube URLs"
}
]
},
"formDescription": "Add the URL of the YouTube channel"
},
"typeVersion": 2.3
},
{
"id": "ecc50703-7a5d-4db8-b456-b50ce77d3d3d",
"name": "アイテムをループ処理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1088,
208
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "b379cb14-d584-4caa-87d9-3027330142d3",
"name": "Channel Crawler",
"type": "n8n-nodes-base.httpRequest",
"position": [
1328,
224
],
"parameters": {
"url": "https://api.channelcrawler.com/v1/priority/channel",
"method": "POST",
"options": {},
"jsonBody": "={\n \"channel\": \"{{ $json.url }}\"\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "httpBearerAuth"
},
"typeVersion": 4.2
},
{
"id": "46318dc5-814d-4c75-b863-332e26296996",
"name": "フォーム送信データを整理",
"type": "n8n-nodes-base.code",
"position": [
832,
208
],
"parameters": {
"language": "python",
"pythonCode": "input_data = items[0]['json']\n\n# Extract the influencers string from the \"Add list of infuencers\" field\ninfluencers_string = input_data.get(\"Youtube URLs\", \"\")\n\n# Split by \\r\\n and clean up each URL (remove extra whitespace)\nurl_list = [url.strip() for url in influencers_string.split('\\r\\n') if url.strip()]\n\n# Convert to the desired format\nresult = [{\"url\": url} for url in url_list]\n\n# Return the result as n8n expects it\nreturn result"
},
"typeVersion": 2
},
{
"id": "771f78ff-926c-4574-a850-88682f3dc618",
"name": "プロファイルにタイトルを付ける",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1520,
224
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-3.5-turbo",
"cachedResultName": "GPT-3.5-TURBO"
},
"options": {},
"messages": {
"values": [
{
"content": "=Looking at the description. Come up with a brief title for this creator for my marketing presentation. {{ $json.json.result.core.description }}"
}
]
}
},
"typeVersion": 1.8
},
{
"id": "4b5e9a1a-76ed-4ce6-a53e-2badeec9c7a7",
"name": "プロファイル概要",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1824,
224
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "chatgpt-4o-latest",
"cachedResultName": "CHATGPT-4O-LATEST"
},
"options": {},
"messages": {
"values": [
{
"content": "=Give a Summary of the following profile in a few sentences (max 4) using the provided context.\nAlways start with their name, Focus on their industry,expertise and what they talk about:\ncontext 1:{{ $('Channel Crawler').item.json.json.result.core.description }}\ncontext 2:{{ $('Channel Crawler').item.json.json.result.classification.keywords }}"
}
]
}
},
"typeVersion": 1.8
},
{
"id": "7545b969-5e6e-49d7-949b-e07e37ae6f2c",
"name": "プレゼンテーションを取得",
"type": "n8n-nodes-base.googleSlides",
"position": [
2128,
224
],
"parameters": {
"resource": "page",
"pageObjectId": "p"
},
"typeVersion": 2
},
{
"id": "6100dd80-e4a1-429b-b5eb-592c606e8d51",
"name": "新しいページを作成",
"type": "n8n-nodes-base.httpRequest",
"position": [
2304,
224
],
"parameters": {
"url": "https://slides.googleapis.com/v1/presentations/{insert_Presentation_ID}:batchUpdate",
"method": "POST",
"options": {},
"jsonBody": "={\n \"requests\": [\n {\n \"duplicateObject\": {\n \"objectId\": \"{{ $json.objectId }}\"\n }\n }\n ]\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "googleSlidesOAuth2Api"
},
"typeVersion": 4.2
},
{
"id": "00304c0c-8e39-44f3-a157-722f5afc6f08",
"name": "新しいページを取得",
"type": "n8n-nodes-base.googleSlides",
"position": [
2480,
224
],
"parameters": {
"resource": "page",
"pageObjectId": "p",
"presentationId": "={{ $json.presentationId }}"
},
"typeVersion": 2
},
{
"id": "417f8fb2-1d9d-406d-bc41-40e00b4f531b",
"name": "プロファイル画像を置換",
"type": "n8n-nodes-base.httpRequest",
"position": [
2688,
224
],
"parameters": {
"url": "https://slides.googleapis.com/v1/presentations/{insert_Presentation_ID}:batchUpdate",
"method": "POST",
"options": {},
"jsonBody": "={\n \"requests\": [\n {\n \"replaceImage\": {\n \"imageObjectId\": \"{{ $json.pageElements[3].objectId }}\",\n \"url\": \"{{ $('Channel Crawler').item.json.json.result.profile.avatar }}\",\n \"imageReplaceMethod\": \"CENTER_CROP\"\n }\n }\n ],\n \"writeControl\": {\n \"requiredRevisionId\": \"{{ $json.revisionId }}\"\n }\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "googleSlidesOAuth2Api"
},
"typeVersion": 4.2
},
{
"id": "d934cd46-7876-426a-95de-188c1e3d8231",
"name": "ページ内のテキストを置換",
"type": "n8n-nodes-base.googleSlides",
"onError": "continueRegularOutput",
"position": [
2688,
672
],
"parameters": {
"textUi": {
"textValues": [
{
"text": "={{ $('Get a new page').item.json.pageElements[5].shape.text.textElements[1].textRun.content }}",
"replaceText": "={{ $('Channel Crawler').item.json.json.result.core.title }}",
"pageObjectIds": [
"p"
]
},
{
"text": "={{ $('Get a new page').item.json.pageElements[7].shape.text.textElements[1].textRun.content }}",
"replaceText": "={{ $('Channel Crawler').item.json.json.result.classification.country.name }}",
"pageObjectIds": [
"p"
]
},
{
"text": "={{ $('Get a new page').item.json.pageElements[8].shape.text.textElements[1].textRun.content }}",
"replaceText": "=Youtube Subscribers: {{ $('Channel Crawler').item.json.json.result.core.subscribers }}",
"pageObjectIds": [
"p"
]
},
{
"text": "={{ $('Get a new page').item.json.pageElements[6].shape.text.textElements[1].textRun.content }}",
"replaceText": "={{ $('Profile Summary').item.json.message.content }}",
"pageObjectIds": [
"p"
]
},
{
"text": "={{ $('Get a new page').item.json.pageElements[9].shape.text.textElements[1].textRun.content }}",
"replaceText": "={{ $('Channel Crawler').item.json.json.result.external.links[0].url }}\n{{ $('Channel Crawler').item.json.json.result.external.links[1].url }}\n{{ $('Channel Crawler').item.json.json.result.external.links[2].url }}\n{{ $('Channel Crawler').item.json.json.result.external.links[4].url }}",
"pageObjectIds": [
"p"
]
},
{
"text": "={{ $('Get a new page').item.json.pageElements[4].shape.text.textElements[1].textRun.content }}",
"replaceText": "={{ $('Title the profile').item.json.message.content }}",
"pageObjectIds": [
"p"
]
}
]
},
"options": {},
"operation": "replaceText"
},
"typeVersion": 2
},
{
"id": "7d4c102a-4307-4243-8e4f-0355fcce4751",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-112,
-96
],
"parameters": {
"width": 640,
"height": 896,
"content": "## ChannelCrawler API to Google Slides Template\n\n**This template shows how you can use the ChannelCrawler API alongside ChatGPT (or any LLM) to generate google slides using images and texts received from the API**\n\n## How it Works\n1. A user inputs the link to the Youtube channel(s) of their target creators\n2. The list is parsed by a python script, returning it in a format that can be ran in a loop\n3. The workflow iterates over each channel url\n4. The url is passed to the ChannelCrawler API, where it returns a json of the creators profile.\n5. The OpenAI node processes the description and content of the creators profile to create a summary\n6. We retrieve the google slides presentation using the get presentation node.\n7. We use the Google Slides API to duplicate an existing page and pull back the original page as it has a new revision ID\n8. We use the Google Slides API to change the image placeholder of the of the image Presentation\n9. Lastly we update other placeholders in with text from the ChannelCrawler and ChatGPT outputs\n\n## How to Use\n- From executing the workflow, a pop up form will come up where you can insert the Youtube Channel urls\n- On submission, provided the prerequisites are set up - rest of the workflow will be triggered\n\n## Use Cases\n- You can create profiles on influencers and creators with extensive data points from the ChannelCrawler API and consistent summarisation from GPT\n\n## Prerequisites\n[ChannelCrawler Account](https://channelcrawler.com) - there's a great pay as you go options for access to the API\n[OpenAI account](https://platform.openai.com/docs/overview) - the you can access free Open AI credit if you are a first time n8n user! Check the credentials options in the node\n[Google account](https://workspace.google.com/products/slides/) (For slides) - You should have a google account or sign up for google with your non google email\n"
},
"typeVersion": 1
},
{
"id": "f4bf7a27-ae76-4e82-95bf-7322677c2b8a",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1504,
64
],
"parameters": {
"color": 7,
"width": 560,
"height": 320,
"content": "## AI Titling and Summarisation \n\nTo get a summary that aligns with your reporting needs, the OpenAI nodes need to be edited to your unique description. The response will be passed on to your persona slide"
},
"typeVersion": 1
},
{
"id": "4ed49427-8832-42b2-835d-654ea10b6647",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2096,
16
],
"parameters": {
"color": 7,
"width": 512,
"height": 368,
"content": "## Google Presentation Fetch and Duplication\n\nN8N give's an extensive [step by step](https://docs.n8n.io/integrations/builtin/credentials/google/oauth-single-service/?utm_source=n8n_app&utm_medium=credential_settings&utm_campaign=create_new_credentials_modal) on how to set up your google auth credentials - you'll need that authorisation for google to allow the slide duplication, image replacement and other text edits\n\nYou'll need to get the **Presentation ID** of your own google presentation and apply it to the API and nodes\n"
},
"typeVersion": 1
},
{
"id": "c759c6e5-27c5-4106-a4f0-72581293143b",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1104,
400
],
"parameters": {
"color": 4,
"width": 544,
"height": 304,
"content": "## Sample API Response\nThis is an example of what to expect from the ChannelCrawler call **Double-Click to see full response**\n``` {\n \"json\": {\n \"channel_id\": \"UCdcUmdOxMrhRjKMw-BX19AA\",\n \"resolved_by\": \"unofficial\",\n \"present\": true,\n \"result\": {\n \"core\": {\n \"channel_id\": \"UCdcUmdOxMrhRjKMw-BX19AA\",\n \"title\": \"Niko Omilana\",\n \"description\": \"Niko Defence League!!! Founding father of the greatest movement of all time, I also try to make youtube videos! If you like what you see... SUBSCRIBE AND JOIN THE NDL!\\n\\n\\n\\nBusiness- NikoEnquiries@gmail.com\\n\\nPromoted by Niko Omilana of Amelia House, Crescent Road, Worthing, West Sussex, England, BN11 1QR\\n\",\n \"subscribers\": 8200000,\n \"videos\": 146,\n \"views\": 707656457\n },\n \"profile\": {\n \"username\": \"@niko\",\n \"avatar\": \"https://yt3.ggpht.com/9rlHifjnNj9-wLVJuBkh6bHsKiiqUssLM1ZFB1jqm5ZVtZDJx496mqcT0Kg6Y62rz-q_0ABUacc=s800-c-k-c0x00ffffff-no-rj\",\n \"email\": \"nikoenquiries@gmail.com\"\n },\n \"timestamps\": {\n \"joined_at\": \"2011-06-21T23:57:25Z\",\n \"created_at\": \"2024-12-22T13:08:35.966897Z\",\n \"updated_at\": \"2025-11-03T08:01:47.489101Z\",\n \"latest_video_date\": \"2025-09-27T18:04:43Z\"\n },\n \"classification\": {\n \"country\": {\n \"id\": \"1\",\n \"name\": \"United Kingdom\"\n },\n \"category\": {\n \"id\": \"24\",\n \"name\": \"Entertainment\"\n },\n \"language\": {\n \"id\": \"7\",\n \"code\": \"en\",\n \"name\": \"English\"\n },\n \"topics\": [\n {\n \"category_name\": \"Entertainment & Comedy\",\n \"subcategory_name\": \"Pranks & Challenges\",\n \"confidence_score\": 0.95\n },\n {\n \"category_name\": \"Entertainment & Comedy\",\n \"subcategory_name\": \"Comedy & Sketches\",\n \"confidence_score\": 0.85\n },\n {\n \"category_name\": \"Entertainment & Comedy\",\n \"subcategory_name\": \"Humor & Satire\",\n \"confidence_score\": 0.7\n }\n ],\n \"keywords\": [\n \"Niko\",\n \"Nikolas Omilana\",\n \"How To\",\n \"Random\",\n \"Parody\",\n \"Comedy\",\n \"Skits\",\n \"UK\",\n \"England\"\n ]\n },\n \"features\": {\n \"is_verified\": true,\n \"is_made_for_kids\": false,\n \"is_monetized\": true,\n \"has_membership\": false,\n \"has_view_email\": true\n },\n \"analytics\": {\n \"growth\": {\n \"subscribers\": {\n \"percent\": {\n \"value_7d\": 0.1221,\n \"value_14d\": 0.2445,\n \"value_30d\": 0.6135,\n \"value_90d\": 1.99\n },\n \"count\": {\n \"value_7d\": 10000,\n \"value_14d\": 20000,\n \"value_30d\": 50000,\n \"value_90d\": 160000\n }\n },\n \"views\": {\n \"percent\": {\n \"value_7d\": 0.1437,\n \"value_14d\": 0.2764,\n \"value_30d\": 0.6943,\n \"value_90d\": 2.509\n },\n \"count\": {\n \"value_7d\": 1015212,\n \"value_14d\": 1950378,\n \"value_30d\": 4879194,\n \"value_90d\": 17320468\n }\n }\n },\n \"monthly_averages\": {\n \"views\": {\n \"month_1\": 4879194,\n \"month_2\": 9301575,\n \"month_3\": 3139699\n },\n \"videos\": {\n \"month_1\": 0,\n \"month_2\": 1,\n \"month_3\": 0\n }\n }\n },\n \"video_analysis\": {\n \"content\": {\n \"titles\": [\n \"I Pranked A Celebrity Movie Premiere\",\n \"Turning £0.01 Into £1,000,000\",\n \"How I Won The UK Election\",\n \"How I Scammed MrBeast For $100,000\",\n \"SNEAKING Into A BANNED Country\",\n \"We Ruined An Award Show\",\n \"SNEAKING Into WWE Match (In the ring)\",\n \"I Got Attacked By A Heavyweight Boxer\",\n \"We Pranked The Mona Lisa\",\n \"SNEAKING Into KSI's Boxing Match (In the ring)\"\n ],\n \"descriptions\": [\n \"I snuck into the biggest red carpet event of the year, this video took a turn..\\nSign up to Revolut with this link: https://get.revolut.com/z4lF/nikoyt1, and spend minimum £1, $1USD, or $1AUD to receive £20, $20USD, or $40AUD (18+. Offer expires 31/12/2025, Terms & Conditions and exclusions apply) AD\\n\\nSubscribe to Tudor @TNTtv-Tudor \\n\\nPlease consider supporting Tudor's Son: https://www.gofundme.com/f/david-sarcoma-ewing-right-calacneum \\n\\nCheck Out My Sweets! https://shadesbyniko.com/\\n\\nFollow me on Instagram- http://instagram.com/niko\\nBUY MY MERCH- https://www.shopndl.com/\\nFollow me on Twitter- https://twitter.com/NikoOmilana\\nMY SNAPCHAT: NikoOmilana\\n\\nBusiness Email - nikoenquiries@gmail.com\\n\\n🎵 Music licensed from Lickd. The biggest mainstream and stock music platform for content creators.\\nWhat Is Love (7\\\" Mix) by Haddaway, https://lickd.lnk.to/JktluDID License ID: y91Wklyd1WQ\\nIf you want to use music from famous artists, try Lickd to get track credits and unlimited stock music: https://go.lickd.co/Get-A-Free-Trial\",\n \"What happens when you try to turn a singular penny, into 1 Million Pounds?\\nCheck Out my brand new sweet, Shades, out now in a store near you!\\nhttps://shadesbyniko.com (AD)\\nNDL Clothing: https://shopndl.com/\\nFollow my Instagram- https://www.instagram.com/niko\\nBusiness Email - Nikoenquiries@gmail.com\\n\\n🎵 Music licensed from Lickd. The biggest mainstream and stock music platform for content creators.\\nFix You by Coldplay, https://lickd.lnk.to/hwlOanID!Niko+Omilana License ID: dWy5EnVnyQD\",\n \"What happens when a YouTuber runs for Prime Minister? Well this documentary will show you, enjoy my friends.\\n\\nTait's Website: https://www.tasidesigns.co.uk\\n\\nMusic:\\nMiles Away- https://youtube.com/c/MilesAwayOfficial\\n\\nNDL Clothing: https://shopndl.com/\\n\\nFollow my Instagram- http://instagram.com/niko\\nFollow me on Twitter- https://twitter.com/NikoOmilana\\nFollow me on Facebook- https://www.facebook.com/Niko\\nMY SNAPCHAT: NikoOmilana\\n\\nBusiness Email - Nikoenquiries@gmail.com\\n\\n🎵 Music licensed from Lickd. The biggest mainstream and stock music platform for content creators. I'm Gonna Be (500 Miles) by The Proclaimers, https://lickd.lnk.to/7jkAvwID!Niko+Omilana License ID: Meb7G3Yobqp If you want to use music from famous artists, try Lickd to get track credits and unlimited stock music: https://go.lickd.co/Referral-Offer\",\n \"thanks mr beast.\\nUnder One Sky- https://underoneskytogether.com\\nCheck out my 2nd channel- @NDL \\n\\nFollow me on Instagram- https://www.instagram.com/niko\\nFollow me on Twitter- https://x.com/NikoOmilana\\nMY SNAPCHAT: NikolasOmilana\\n\\r\\nMedia- Grace@NDLProduction.com\\nBusiness Email - Nikoenquiries@gmail.com\",\n \"Sneaking into a country that no one is allowed to go to!\\nSubscribe for weekly content on the @NDL channel!\\nWant me to investigate your story? Tell me your stories at ndlstories@gmail.com\\n\\nFollow me on Instagram- http://instagram.com/nikoomilana\\r\\nBUY MY MERCH- https://www.shopndl.com/\\r\\nFollow me on Twitter- https://twitter.com/NikoOmilana\\nMY SNAPCHAT: NikolasOmilana\\nMusic made by Miles- @MilesAwayOfficial \\r\\n\\nBusiness Email - Nikoenquiries@gmail.com\",\n \"The Finale of The Biggest Menace.\\nSUBSCRIBE TO @JiDion\\nBUY NDL CLOTHING- https://www.shopndl.com/\\nFollow us on Instagram\\nNiko- http://instagram.com/niko\\nJiDion- http://instagram.com/jidion_\\nThanks to Miles Away for Music- @MilesAwayOfficial \\nFollow me on Twitter- https://twitter.com/NikoOmilana\\nMY SNAPCHAT: NikoOmilana\\n\\nBusiness Email - Nikoenquiries@gmail.com\",\n \"Time to take on the WWE.\\nSUBSCRIBE TO @JiDion \\nFollow us on Instagram\\nNiko- http://instagram.com/niko\\nJiDion- http://instagram.com/jidion_\\nThanks to Miles Away for Music- @MilesAwayOfficial \\nBUY MY MERCH- https://www.shopndl.com/\\nFollow me on Twitter- https://twitter.com/NikoOmilana\\nMY SNAPCHAT: NikoOmilana\\n\\nBusiness Email - Nikoenquiries@gmail.com\",\n \"Shannon Briggs gets his revenge.\\nSUBSCRIBE TO @JiDion \\nFollow us on Instagram\\nNiko- http://instagram.com/niko\\nJiDion- http://instagram.com/jidion_\\nThanks to Miles Away for Music- @MilesAwayOfficial \\nBUY MY MERCH- https://www.shopndl.com/\\nFollow me on Twitter- https://twitter.com/NikoOmilana\\nMY SNAPCHAT: NikoOmilana\\n\\nBusiness Email - Nikoenquiries@gmail.com\",\n \"To start off the Biggest Menace series I have challenged JiDion to prank the Mona Lisa.\\nSUBSCRIBE TO @JiDion \\nFollow us on Instagram\\nNiko- http://instagram.com/niko\\nJiDion- http://instagram.com/jidion_\\nThanks to Miles Away for Music- @MilesAwayOfficial \\r\\nBUY MY MERCH- https://www.shopndl.com/\\r\\nFollow me on Twitter- https://twitter.com/NikoOmilana\\r\\nMY SNAPCHAT: NikoOmilana\\r\\n\\r\\nBusiness Email - Nikoenquiries@gmail.com\",\n \"I pranked KSI and the whole internet by sneaking into his first boxing match in years, in a prime bottle mascot. Enjoy my friends.\\nPls subscribe to Kysha- https://www.youtube.com/c/KyshaSwordy\\nFollow me on Instagram- http://instagram.com/niko\\nCourtesy of Dazn for all fight footage- https://www.dazn.com/\\n\\r\\nBUY MY MERCH- https://www.shopndl.com/\\r\\nFollow me on Twitter- https://twitter.com/NikoOmilana\\nMusic made by Miles- https://www.youtube.com/channel/UCy_bbwPsSwNmdlYpExi9fYQ\\nDiscovery Song By Scott Buckley- https://youtu.be/VeYRaOV0I_Y\\nSpecial mention to Batson- https://www.youtube.com/c/Batsonn\\n\\nBusiness Email - Nikoenquiries@gmail.com\"\n ],\n \"tags\": [\n \"mona lisa\",\n \"mona lisa prank\",\n \"Niko omilana\",\n \"Niko\",\n \"Jidion\",\n \"The Biggest Menace\",\n \"NDL\"\n ]\n },\n \"metrics\": {\n \"engagement\": {\n \"engagement_rate_last_10\": 5,\n \"engagement_rate_last_50\": 6.06,\n \"comments_views_ratio_last_10\": 0.0011,\n \"comments_views_ratio_last_50\": 0.0014,\n \"likes_views_ratio_last_10\": 0.0489,\n \"likes_views_ratio_last_50\": 0.0592,\n \"views_subs_ratio_last_10\": 13.6318,\n \"views_subs_ratio_last_50\": 59.7115\n },\n \"averages\": {\n \"views_per_video_last_10\": 11178078.4,\n \"views_per_video_last_50\": 9992544.898,\n \"typical_views_per_video_last_10\": 10050808,\n \"typical_views_per_video_last_50\": 7751593,\n \"overall_views_per_video\": 4846962.0342,\n \"views\": 9950972,\n \"likes\": 586739,\n \"comments\": 14723,\n \"length\": 1225\n },\n \"upload_patterns\": {\n \"max_upload_gap\": 915\n }\n },\n \"links\": [\n {\n \"id\": \"3okCoydVBRM\",\n \"url\": \"https://go.lickd.co/Get-A-Free-Trial\",\n \"domain\": \"go.lickd.co\",\n \"views\": 6587711,\n \"published_at\": \"2025-07-11T17:00:28Z\",\n \"engagement_rate\": 6.1598\n },\n {\n \"id\": \"3okCoydVBRM\",\n \"url\": \"https://lickd.lnk.to/JktluDID\",\n \"domain\": \"lickd.lnk.to\",\n \"views\": 6587711,\n \"published_at\": \"2025-07-11T17:00:28Z\",\n \"engagement_rate\": 6.1598\n },\n {\n \"id\": \"3okCoydVBRM\",\n \"url\": \"https://twitter.com/NikoOmilana\",\n \"domain\": \"twitter.com\",\n \"views\": 6587711,\n \"published_at\": \"2025-07-11T17:00:28Z\",\n \"engagement_rate\": 6.1598\n },\n {\n \"id\": \"3okCoydVBRM\",\n \"url\": \"https://www.shopndl.com/\",\n \"domain\": \"shopndl.com\",\n \"views\": 6587711,\n \"published_at\": \"2025-07-11T17:00:28Z\",\n \"engagement_rate\": 6.1598\n },\n {\n \"id\": \"3okCoydVBRM\",\n \"url\": \"http://instagram.com/niko\",\n \"domain\": \"instagram.com\",\n \"views\": 6587711,\n \"published_at\": \"2025-07-11T17:00:28Z\",\n \"engagement_rate\": 6.1598\n },\n {\n \"id\": \"3okCoydVBRM\",\n \"url\": \"https://shadesbyniko.com/\",\n \"domain\": \"shadesbyniko.com\",\n \"views\": 6587711,\n \"published_at\": \"2025-07-11T17:00:28Z\",\n \"engagement_rate\": 6.1598\n },\n {\n \"id\": \"3okCoydVBRM\",\n \"url\": \"https://www.gofundme.com/f/david-sarcoma-ewing-right-calacneum\",\n \"domain\": \"gofundme.com\",\n \"views\": 6587711,\n \"published_at\": \"2025-07-11T17:00:28Z\",\n \"engagement_rate\": 6.1598\n },\n {\n \"id\": \"3okCoydVBRM\",\n \"url\": \"https://get.revolut.com/z4lF/nikoyt1\",\n \"domain\": \"get.revolut.com\",\n \"views\": 6587711,\n \"published_at\": \"2025-07-11T17:00:28Z\",\n \"engagement_rate\": 6.1598\n },\n {\n \"id\": \"G1h9-IrC-Uo\",\n \"url\": \"https://lickd.lnk.to/hwlOanID!Niko+Omilana\",\n \"domain\": \"lickd.lnk.to\",\n \"views\": 7525502,\n \"published_at\": \"2025-05-30T16:59:59Z\",\n \"engagement_rate\": 3.7471\n },\n {\n \"id\": \"G1h9-IrC-Uo\",\n \"url\": \"https://www.instagram.com/niko\",\n \"domain\": \"instagram.com\",\n \"views\": 7525502,\n \"published_at\": \"2025-05-30T16:59:59Z\",\n \"engagement_rate\": 3.7471\n },\n {\n \"id\": \"G1h9-IrC-Uo\",\n \"url\": \"https://shopndl.com/\",\n \"domain\": \"shopndl.com\",\n \"views\": 7525502,\n \"published_at\": \"2025-05-30T16:59:59Z\",\n \"engagement_rate\": 3.7471\n },\n {\n \"id\": \"G1h9-IrC-Uo\",\n \"url\": \"https://shadesbyniko.com\",\n \"domain\": \"shadesbyniko.com\",\n \"views\": 7525502,\n \"published_at\": \"2025-05-30T16:59:59Z\",\n \"engagement_rate\": 3.7471\n },\n {\n \"id\": \"GtXoxMyQ3VM\",\n \"url\": \"http://instagram.com/jidion_\",\n \"domain\": \"instagram.com\",\n \"views\": 11582833,\n \"published_at\": \"2023-03-26T19:00:15Z\",\n \"engagement_rate\": 6.0418\n },\n {\n \"id\": \"Jb8T9X5K1AA\",\n \"url\": \"http://instagram.com/nikoomilana\",\n \"domain\": \"instagram.com\",\n \"views\": 10323403,\n \"published_at\": \"2023-07-28T18:00:25Z\",\n \"engagement_rate\": 4.5124\n },\n {\n \"id\": \"VeYRaOV0I_Y\",\n \"url\": \"https://www.youtube.com/c/Batsonn\",\n \"domain\": \"youtube.com\",\n \"views\": 26535624,\n \"published_at\": \"2022-09-05T18:27:48Z\",\n \"engagement_rate\": 5.6235\n },\n {\n \"id\": \"VeYRaOV0I_Y\",\n \"url\": \"https://youtu.be/VeYRaOV0I_Y\",\n \"domain\": \"youtu.be\",\n \"views\": 26535624,\n \"published_at\": \"2022-09-05T18:27:48Z\",\n \"engagement_rate\": 5.6235\n },\n {\n \"id\": \"VeYRaOV0I_Y\",\n \"url\": \"https://www.youtube.com/channel/UCy_bbwPsSwNmdlYpExi9fYQ\",\n \"domain\": \"youtube.com\",\n \"views\": 26535624,\n \"published_at\": \"2022-09-05T18:27:48Z\",\n \"engagement_rate\": 5.6235\n },\n {\n \"id\": \"VeYRaOV0I_Y\",\n \"url\": \"https://www.dazn.com/\",\n \"domain\": \"dazn.com\",\n \"views\": 26535624,\n \"published_at\": \"2022-09-05T18:27:48Z\",\n \"engagement_rate\": 5.6235\n },\n {\n \"id\": \"VeYRaOV0I_Y\",\n \"url\": \"https://www.youtube.com/c/KyshaSwordy\",\n \"domain\": \"youtube.com\",\n \"views\": 26535624,\n \"published_at\": \"2022-09-05T18:27:48Z\",\n \"engagement_rate\": 5.6235\n },\n {\n \"id\": \"ZRLYscVjA5c\",\n \"url\": \"https://go.lickd.co/Referral-Offer\",\n \"domain\": \"go.lickd.co\",\n \"views\": 10050808,\n \"published_at\": \"2025-03-14T18:23:00Z\",\n \"engagement_rate\": 3.4722\n },\n {\n \"id\": \"ZRLYscVjA5c\",\n \"url\": \"https://lickd.lnk.to/7jkAvwID!Niko+Omilana\",\n \"domain\": \"lickd.lnk.to\",\n \"views\": 10050808,\n \"published_at\": \"2025-03-14T18:23:00Z\",\n \"engagement_rate\": 3.4722\n },\n {\n \"id\": \"ZRLYscVjA5c\",\n \"url\": \"https://www.facebook.com/Niko\",\n \"domain\": \"facebook.com\",\n \"views\": 10050808,\n \"published_at\": \"2025-03-14T18:23:00Z\",\n \"engagement_rate\": 3.4722\n },\n {\n \"id\": \"ZRLYscVjA5c\",\n \"url\": \"https://youtube.com/c/MilesAwayOfficial\",\n \"domain\": \"youtube.com\",\n \"views\": 10050808,\n \"published_at\": \"2025-03-14T18:23:00Z\",\n \"engagement_rate\": 3.4722\n },\n {\n \"id\": \"ZRLYscVjA5c\",\n \"url\": \"https://www.tasidesigns.co.uk\",\n \"domain\": \"tasidesigns.co.uk\",\n \"views\": 10050808,\n \"published_at\": \"2025-03-14T18:23:00Z\",\n \"engagement_rate\": 3.4722\n },\n {\n \"id\": \"vdfjYDJzaGU\",\n \"url\": \"https://x.com/NikoOmilana\",\n \"domain\": \"x.com\",\n \"views\": 8354996,\n \"published_at\": \"2024-06-24T19:30:01Z\",\n \"engagement_rate\": 4.5371\n },\n {\n \"id\": \"vdfjYDJzaGU\",\n \"url\": \"https://underoneskytogether.com\",\n \"domain\": \"underoneskytogether.com\",\n \"views\": 8354996,\n \"published_at\": \"2024-06-24T19:30:01Z\",\n \"engagement_rate\": 4.5371\n }\n ]\n },\n \"external\": {\n \"links\": [\n {\n \"title\": \"Instagram\",\n \"url\": \"https://instagram.com/niko\",\n \"domain\": \"instagram\"\n }\n ]\n }\n },\n \"cost\": {\n \"total\": 5\n }\n }\n} ```"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "74bcb6b3-4322-4a3e-b508-dc51b44e48bd",
"connections": {
"00304c0c-8e39-44f3-a157-722f5afc6f08": {
"main": [
[
{
"node": "417f8fb2-1d9d-406d-bc41-40e00b4f531b",
"type": "main",
"index": 0
}
]
]
},
"b379cb14-d584-4caa-87d9-3027330142d3": {
"main": [
[
{
"node": "771f78ff-926c-4574-a850-88682f3dc618",
"type": "main",
"index": 0
}
]
]
},
"ecc50703-7a5d-4db8-b456-b50ce77d3d3d": {
"main": [
[],
[
{
"node": "b379cb14-d584-4caa-87d9-3027330142d3",
"type": "main",
"index": 0
}
]
]
},
"4b5e9a1a-76ed-4ce6-a53e-2badeec9c7a7": {
"main": [
[
{
"node": "7545b969-5e6e-49d7-949b-e07e37ae6f2c",
"type": "main",
"index": 0
}
]
]
},
"7545b969-5e6e-49d7-949b-e07e37ae6f2c": {
"main": [
[
{
"node": "6100dd80-e4a1-429b-b5eb-592c606e8d51",
"type": "main",
"index": 0
}
]
]
},
"6100dd80-e4a1-429b-b5eb-592c606e8d51": {
"main": [
[
{
"node": "00304c0c-8e39-44f3-a157-722f5afc6f08",
"type": "main",
"index": 0
}
]
]
},
"771f78ff-926c-4574-a850-88682f3dc618": {
"main": [
[
{
"node": "4b5e9a1a-76ed-4ce6-a53e-2badeec9c7a7",
"type": "main",
"index": 0
}
]
]
},
"533d9323-5756-43aa-8008-fff04ca902e7": {
"main": [
[
{
"node": "46318dc5-814d-4c75-b863-332e26296996",
"type": "main",
"index": 0
}
]
]
},
"d934cd46-7876-426a-95de-188c1e3d8231": {
"main": [
[
{
"node": "ecc50703-7a5d-4db8-b456-b50ce77d3d3d",
"type": "main",
"index": 0
}
]
]
},
"46318dc5-814d-4c75-b863-332e26296996": {
"main": [
[
{
"node": "ecc50703-7a5d-4db8-b456-b50ce77d3d3d",
"type": "main",
"index": 0
}
]
]
},
"417f8fb2-1d9d-406d-bc41-40e00b4f531b": {
"main": [
[
{
"node": "d934cd46-7876-426a-95de-188c1e3d8231",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は?
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか?
中級 - 市場調査, AI要約
有料ですか?
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス(OpenAI APIなど)は別途料金が発生する場合があります。
関連ワークフロー
Google Analytics、Firecrawl、InfraNodusを使用して最適化された優れたウェブサイトコンテンツ
Google Analytics、Firecrawl、InfraNodusを使用してトップウェブサイトのコンテンツを分析と最適化
Code
Form
Form Trigger
+
Code
Form
Form Trigger
17 ノードInfraNodus
市場調査
アイデア捕集テンプレート
Reddit、YouTube、Xを分析してコンテンツ戦略レポートを生成するGeminiの使用
If
Set
Code
+
If
Set
Code
34 ノードSheryl
市場調査
GPT-4とApifyを基盤としたAI駆動型競合他社・市場インテリジェンスシステム
GPT-4とApifyを基盤としたAI駆動型競合他社・市場インテリジェンスシステム
Code
Merge
Slack
+
Code
Merge
Slack
12 ノードMarth
市場調査
SEOブログの分析
AIを使ってブログのSEOを分析:GPT-4とコンプライアンス準拠のクロールに基づく包括のな評価
If
Set
Code
+
If
Set
Code
20 ノードinderjeet Bhambra
市場調査
GPT-4o-miniとGmailを使ってYouTubeチャンネルを分析し、パフォーマンスレポートを送信
GPT-4o-miniとGmailを使ってYouTubeチャンネルを分析し、パフォーマンスレポートを送信する
Code
Email Send
Http Request
+
Code
Email Send
Http Request
20 ノードRahul Joshi
市場調査
テンプレート - Google レビュー分析
SerpAPI、GPT-4、Google Sheetsを使用してGoogleレビューを分析と要約
If
Code
Http Request
+
If
Code
Http Request
14 ノードkeisha kalra
市場調査