TwitterとYouTubeのトレンドを活用してMistral AIを使ってSNSタグを生成
中級
これはContent Creation, Multimodal AI分野の自動化ワークフローで、15個のノードを含みます。主にCode, Html, Merge, GoogleSheets, SplitInBatchesなどのノードを使用。 TwitterとYouTubeのトレンドを基にMistral AIを使ってSNSタグを生成する
前提条件
- •Google Sheets API認証情報
使用ノード (15)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "d2787088d49a05164783f5a9fa37e1730a27b190e51881d2128ba2bcd8c2656e"
},
"nodes": [
{
"id": "ca4cb366-5e3c-4bb1-a219-11f0a3684089",
"name": "マージ",
"type": "n8n-nodes-base.merge",
"position": [
760,
200
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "45cf94ce-c524-45c6-96cd-7a95ba14ca1c",
"name": "デイリートリガー",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-380,
220
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "49ca40cd-2af0-4023-9398-fcc5f5c44bdc",
"name": "twitter トレンド抽出",
"type": "n8n-nodes-crawl-and-scrape.crawleeNode",
"position": [
120,
120
],
"parameters": {
"url": "https://trends24.in/",
"operation": "extractHtml"
},
"typeVersion": 1
},
{
"id": "aaf1d402-6524-4c2e-ba77-cf4c778c6de4",
"name": "YouTube トレンド抽出",
"type": "n8n-nodes-crawl-and-scrape.crawleeNode",
"position": [
120,
340
],
"parameters": {
"url": "https://youtube.trends24.in/",
"operation": "extractHtml"
},
"typeVersion": 1
},
{
"id": "f01f50bf-f46b-485c-9ec7-9abf263a37db",
"name": "Google Sheets2",
"type": "n8n-nodes-base.googleSheets",
"position": [
1700,
220
],
"parameters": {
"columns": {
"value": {
"hastag ": "={{ $json.output.hashtag }}"
},
"schema": [
{
"id": "hastag ",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "hastag ",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"hastag "
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1A9EHzMz88dlmBZm1ooQasWb4sU3OTv2tuMtuu1yBAyw/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1A9EHzMz88dlmBZm1ooQasWb4sU3OTv2tuMtuu1yBAyw",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1A9EHzMz88dlmBZm1ooQasWb4sU3OTv2tuMtuu1yBAyw/edit?usp=drivesdk",
"cachedResultName": "Hastag"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "amDdbvZuuPjcG55e",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "da2fddc5-46b7-4049-ad42-b5d401bbda48",
"name": "アイテムループ処理2",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1480,
200
],
"parameters": {
"options": {
"reset": false
}
},
"typeVersion": 3
},
{
"id": "ff8fc176-6006-43f4-bdbc-4968e2d93c11",
"name": "構造化出力パーサー1",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1280,
420
],
"parameters": {
"jsonSchemaExample": "{\n\t\n\t\"hashtag\": [\"\", \"\", \"\"]\n}"
},
"typeVersion": 1.2
},
{
"id": "d434e4a8-fb22-41d9-a208-0eacf97d1177",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"color": 5,
"width": 360,
"height": 600,
"content": "extract twitter and youtube trends from https://trends24.in/ by using crawl and scrape community node scrape the websites "
},
"typeVersion": 1
},
{
"id": "b70c5ae9-2a99-401a-a9d5-9e54008aa593",
"name": "Mistral Cloud Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatMistralCloud",
"position": [
1080,
420
],
"parameters": {
"model": "mistral-small-latest",
"options": {}
},
"credentials": {
"mistralCloudApi": {
"id": "n3lOZuA7dCVheVwc",
"name": "Mistral Cloud account"
}
},
"typeVersion": 1
},
{
"id": "da6240e4-6d9e-45cf-bf16-05ec1717aa52",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
380,
0
],
"parameters": {
"width": 480,
"height": 580,
"content": "filters hashtags out of scraper output"
},
"typeVersion": 1
},
{
"id": "68a52f28-77e6-4b5f-8864-f6880f29f9f6",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
920,
0
],
"parameters": {
"width": 540,
"height": 560,
"content": "generate hashtag related to topic we gave based on current trends "
},
"typeVersion": 1
},
{
"id": "99f60b2d-eef3-41d4-af91-85dc4639ad99",
"name": "twitter トレンドフィルター",
"type": "n8n-nodes-base.html",
"position": [
420,
120
],
"parameters": {
"options": {
"cleanUpText": true
},
"operation": "extractHtmlContent",
"dataPropertyName": "data.html",
"extractionValues": {
"values": [
{
"key": "trends",
"cssSelector": ".trend-card__list li a",
"returnArray": true,
"returnValue": "html"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "2b598d9a-89bb-4a1f-b63b-e328d88a411e",
"name": "YouTube トレンドフィルター",
"type": "n8n-nodes-base.html",
"position": [
420,
340
],
"parameters": {
"options": {
"cleanUpText": true
},
"operation": "extractHtmlContent",
"dataPropertyName": "data.html",
"extractionValues": {
"values": [
{
"key": "trends",
"cssSelector": ".keywords-list li",
"returnArray": true,
"returnValue": "html"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "af274fcf-7358-4f24-a3df-c9ea6f694268",
"name": "上位100トレンドのみ取得",
"type": "n8n-nodes-base.code",
"position": [
600,
120
],
"parameters": {
"jsCode": "return items.map(item => {\n item.json.trends = item.json.trends.slice(0, 100);\n return item;\n});\n"
},
"typeVersion": 2
},
{
"id": "cb29b201-b2be-462b-88d0-4fbd6a94feb3",
"name": "ハッシュタグジェネレーター",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1100,
200
],
"parameters": {
"text": "={{ $('Merge').item.json.trends }},{{ $('Merge').item.json.trends }}",
"options": {
"systemMessage": "=You are a professional hashtag trend strategist.\n\nYour task is to take the following list of trending hashtags and keywords and generate ONE new hashtag that is either:\n\n1. A variation of an existing hashtag,\n2. A mashup of two related trends,\n3. Or a smart, brand-safe hashtag inspired by the same themes, communities, or languages used in the list.\n4. if no related trends make one of your own\nKeep the hashtag short, all lowercase, no spaces, and catchy. Do not use special characters beyond the #. Avoid copying any exact hashtag from the list.\n\nhastag should be related to this:\n{{ $json.keywords }}\n\nTrending List:\ngive as user query\n\nReturn only a single new hashtag in this format:\n{\n \"new_hashtag\": \"#exampletag\"\n}\n\n\n\n\n\n\n\n\n\n\n\n\n"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2
}
],
"pinData": {},
"connections": {
"ca4cb366-5e3c-4bb1-a219-11f0a3684089": {
"main": [
[
{
"node": "cb29b201-b2be-462b-88d0-4fbd6a94feb3",
"type": "main",
"index": 0
}
]
]
},
"45cf94ce-c524-45c6-96cd-7a95ba14ca1c": {
"main": [
[
{
"node": "49ca40cd-2af0-4023-9398-fcc5f5c44bdc",
"type": "main",
"index": 0
},
{
"node": "aaf1d402-6524-4c2e-ba77-cf4c778c6de4",
"type": "main",
"index": 0
}
]
]
},
"f01f50bf-f46b-485c-9ec7-9abf263a37db": {
"main": [
[
{
"node": "da2fddc5-46b7-4049-ad42-b5d401bbda48",
"type": "main",
"index": 0
}
]
]
},
"da2fddc5-46b7-4049-ad42-b5d401bbda48": {
"main": [
[],
[
{
"node": "f01f50bf-f46b-485c-9ec7-9abf263a37db",
"type": "main",
"index": 0
}
]
]
},
"cb29b201-b2be-462b-88d0-4fbd6a94feb3": {
"main": [
[
{
"node": "da2fddc5-46b7-4049-ad42-b5d401bbda48",
"type": "main",
"index": 0
}
]
]
},
"2b598d9a-89bb-4a1f-b63b-e328d88a411e": {
"main": [
[
{
"node": "ca4cb366-5e3c-4bb1-a219-11f0a3684089",
"type": "main",
"index": 1
}
]
]
},
"99f60b2d-eef3-41d4-af91-85dc4639ad99": {
"main": [
[
{
"node": "af274fcf-7358-4f24-a3df-c9ea6f694268",
"type": "main",
"index": 0
}
]
]
},
"aaf1d402-6524-4c2e-ba77-cf4c778c6de4": {
"main": [
[
{
"node": "2b598d9a-89bb-4a1f-b63b-e328d88a411e",
"type": "main",
"index": 0
}
]
]
},
"49ca40cd-2af0-4023-9398-fcc5f5c44bdc": {
"main": [
[
{
"node": "99f60b2d-eef3-41d4-af91-85dc4639ad99",
"type": "main",
"index": 0
}
]
]
},
"af274fcf-7358-4f24-a3df-c9ea6f694268": {
"main": [
[
{
"node": "ca4cb366-5e3c-4bb1-a219-11f0a3684089",
"type": "main",
"index": 0
}
]
]
},
"b70c5ae9-2a99-401a-a9d5-9e54008aa593": {
"ai_languageModel": [
[
{
"node": "cb29b201-b2be-462b-88d0-4fbd6a94feb3",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"ff8fc176-6006-43f4-bdbc-4968e2d93c11": {
"ai_outputParser": [
[
{
"node": "cb29b201-b2be-462b-88d0-4fbd6a94feb3",
"type": "ai_outputParser",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - コンテンツ作成, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
Mistral AIとPollinations.aiを使用してソーシャルメディアキャンペーン画像を生成する
Mistral AI と Pollinations.ai を使用したソーシャル メディア キャンペーン用のグラフィックの生成
Set
Code
Merge
+
Set
Code
Merge
29 ノードRajeet Nair
コンテンツ作成
WordPressブログの自動化プロフェッショナル版（先端研究）v2.1マーケットプラグイン
GPT-4o、Perplexity AI、そして多言語対応を使ったSEO最適化ブログ作成の自動化
If
Set
Xml
+
If
Set
Xml
125 ノードDaniel Ng
コンテンツ作成
コンテンツ集約
Gemini AIを使ってウェブ記事からLinkedInとX/Twitterへのソーシャルメディア投稿を自動化する
If
Set
Xml
+
If
Set
Xml
34 ノードVadim
コンテンツ作成
Mistral OCRとGmailを使用して工时报表データを抽出・検証
Mistral OCRとGmailを使って工数票データを抽出し、人間の検証を行う
Set
Code
Gmail
+
Set
Code
Gmail
32 ノードRajeet Nair
コンテンツ作成
人間介入型投稿デザイナー（Mistral AI、ImageKit と LinkedIn 公開）
Mistral AI、ImageKit、LinkedIn公開を組み合わせた手動介入投稿デザイナー
S3
Set
Gmail
+
S3
Set
Gmail
25 ノードRajeet Nair
コンテンツ作成
💥 NanoBanana、Seedream 4、ChatGPT Image、Veo 3 を使って動画広告を自動化 - VIDEO
AI（NanoBanana、Seedream、GPT-4o、Veo 3）を使って動画広告キャンペーンを自動化し公開
Set
Code
Wait
+
Set
Code
Wait
63 ノードDr. Firas
コンテンツ作成
