ソーシャルリスニング
上級
これはProduct, AI分野の自動化ワークフローで、34個のノードを含みます。主にSet, Code, Gmail, Merge, Filterなどのノードを使用、AI技術を活用したスマート自動化を実現。 AI、QuickChart、HTMLレポートジェネレーターを使った顧客フィードバック分析
前提条件
- •Googleアカウント + Gmail API認証情報
- •Google Sheets API認証情報
- •OpenAI API Key
使用ノード (34)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "DTdojLaqC01QCcXz",
"meta": {
"instanceId": "1fc85153dfc4ea22a8172f0d7347fa9f591f71e2064dc331f7bdc1d7ee422e7a",
"templateCredsSetupCompleted": true
},
"name": "Social listenning",
"tags": [],
"nodes": [
{
"id": "09244606-227e-42ee-8eee-b39fd9ec1353",
"name": "「Test workflow」クリック時",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-840,
1660
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d4f30c2d-60c5-4b25-a6ba-945c59fe29a8",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-640,
1660
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "48e81d30-2892-43a3-876c-e46011739a30",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
660,
1480
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "23fbd89a-1d14-413d-8798-2f1915651fc3",
"name": "プロンプト準備1",
"type": "n8n-nodes-base.function",
"position": [
520,
1260
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c55ccffc-d620-4162-a944-508775ba8a21",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
840,
1460
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "1e136fc1-055e-42c3-b77e-51dcb2bf60e6",
"name": "分析トピック提案",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-40,
1240
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "60bd98f4-4824-40a7-936b-466bf60b921f",
"name": "OpenAI Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-20,
1440
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "4de9964d-d2c9-42a6-bbb6-9b7da096dbc9",
"name": "Structured Output Parser1",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
160,
1440
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "55abf7b6-8c29-4f4e-bd9c-cd7813529dd9",
"name": "元テーブルとプロンプトの統合",
"type": "n8n-nodes-base.merge",
"position": [
360,
1260
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "7ed2c444-82f9-4ca3-a7c8-446f0e9ac1e6",
"name": "OpenAI Chat Model2",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1300,
1500
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "baa054dd-40cd-4176-9c5b-5c3e3efbee36",
"name": "分析用統合AIエージェント",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
660,
1260
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "d835b7ea-c636-49ff-b503-757986aee1ca",
"name": "結果の列変換",
"type": "n8n-nodes-base.code",
"position": [
1000,
1260
],
"parameters": {},
"typeVersion": 2
},
{
"id": "b57d48a5-44a7-4b0f-984b-69d648614d35",
"name": "全ユニーク要素統合",
"type": "n8n-nodes-base.code",
"position": [
1160,
1260
],
"parameters": {},
"typeVersion": 2
},
{
"id": "71e3cd1f-b1c8-4dd5-b7ad-96a638db61ea",
"name": "Structured Output Parser2",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1480,
1480
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "871c5348-be6b-4eb7-9cca-4311b7bed571",
"name": "提案改良エージェント",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1320,
1260
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "0b5e0e03-6faf-42ce-ac2b-464e76f50924",
"name": "OpenAI Chat Model3",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1860,
1840
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "7b89e91c-f849-4786-89bd-86f07d9d8ad3",
"name": "第2回分析イテレーション",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1860,
1640
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "a1a57ceb-2bf4-4fed-9e74-fd548db98491",
"name": "Structured Output Parser3",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2020,
1800
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "3ab8569d-d3cd-46a4-afe7-e2b359416b50",
"name": "統合",
"type": "n8n-nodes-base.merge",
"position": [
1680,
1640
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "921e60f6-72bf-4f32-9721-3f4636353ae3",
"name": "未分析結果の要約",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2340,
1640
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "8acb5abd-733f-492c-897c-9ef9eeaf1775",
"name": "OpenAI Chat Model4",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2340,
1900
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "51c84d52-f235-434a-a484-7a82d385be53",
"name": "Structured Output Parser4",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2500,
1840
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "ae251045-850a-4a60-a587-7162fcc78ecc",
"name": "OpenAI Chat Model5",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2660,
1880
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "c94f55ec-721c-489b-89e4-0d02ef73b25e",
"name": "最終レポート編集",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2660,
1640
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "86c00be2-5ecf-4627-8a78-67ef1a3eef16",
"name": "Structured Output Parser5",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2820,
1800
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "c916fd36-4601-486b-9da3-d441e90be074",
"name": "校正・HTMLフォーマットエージェント",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2980,
1640
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "03c2bf53-05eb-492a-924c-db708df11b11",
"name": "OpenAI Chat Model6",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2980,
1900
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "1534a011-ff33-4bbb-a9bc-3ffe0c9443fd",
"name": "先頭n行取得",
"type": "n8n-nodes-base.filter",
"position": [
-480,
1240
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "69c50f29-183a-40f3-99e0-4911cb600e57",
"name": "全結果を単一Jsonファイルに集約",
"type": "n8n-nodes-base.code",
"position": [
2180,
1640
],
"parameters": {},
"typeVersion": 2
},
{
"id": "7c04c879-bb9f-49ff-85d4-4e9b459fe065",
"name": "サンプル先行行統合",
"type": "n8n-nodes-base.code",
"position": [
-280,
1240
],
"parameters": {},
"typeVersion": 2
},
{
"id": "5677b81b-0ebe-4e8f-85d5-0c403a672763",
"name": "補完エージェント（オプション）",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
3340,
1640
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "1d02eb7f-7c33-4278-8ce9-b225bff4dd99",
"name": "OpenAI Chat Model7",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
3340,
1900
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "cb4d0d10-5301-488c-861f-98bd873ea1a8",
"name": "フィールド編集",
"type": "n8n-nodes-base.set",
"position": [
3720,
1640
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "50d0ba8f-6635-414d-946b-1d785992b5fb",
"name": "Gmail",
"type": "n8n-nodes-base.gmail",
"position": [
3940,
1640
],
"webhookId": "b2f8ff12-631f-4a39-9949-fbbc56d0ebe0",
"parameters": {},
"typeVersion": 2.1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "ac5647ac-6c15-4451-a8ff-4e2d1aed32b2",
"connections": {
"3ab8569d-d3cd-46a4-afe7-e2b359416b50": {
"main": [
[
{
"node": "7b89e91c-f849-4786-89bd-86f07d9d8ad3",
"type": "main",
"index": 0
}
]
]
},
"cb4d0d10-5301-488c-861f-98bd873ea1a8": {
"main": [
[
{
"node": "50d0ba8f-6635-414d-946b-1d785992b5fb",
"type": "main",
"index": 0
}
]
]
},
"d4f30c2d-60c5-4b25-a6ba-945c59fe29a8": {
"main": [
[
{
"node": "1534a011-ff33-4bbb-a9bc-3ffe0c9443fd",
"type": "main",
"index": 0
},
{
"node": "55abf7b6-8c29-4f4e-bd9c-cd7813529dd9",
"type": "main",
"index": 1
},
{
"node": "3ab8569d-d3cd-46a4-afe7-e2b359416b50",
"type": "main",
"index": 1
}
]
]
},
"23fbd89a-1d14-413d-8798-2f1915651fc3": {
"main": [
[
{
"node": "baa054dd-40cd-4176-9c5b-5c3e3efbee36",
"type": "main",
"index": 0
}
]
]
},
"48e81d30-2892-43a3-876c-e46011739a30": {
"ai_languageModel": [
[
{
"node": "baa054dd-40cd-4176-9c5b-5c3e3efbee36",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"60bd98f4-4824-40a7-936b-466bf60b921f": {
"ai_languageModel": [
[
{
"node": "1e136fc1-055e-42c3-b77e-51dcb2bf60e6",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"7ed2c444-82f9-4ca3-a7c8-446f0e9ac1e6": {
"ai_languageModel": [
[
{
"node": "871c5348-be6b-4eb7-9cca-4311b7bed571",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"0b5e0e03-6faf-42ce-ac2b-464e76f50924": {
"ai_languageModel": [
[
{
"node": "7b89e91c-f849-4786-89bd-86f07d9d8ad3",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"8acb5abd-733f-492c-897c-9ef9eeaf1775": {
"ai_languageModel": [
[
{
"node": "921e60f6-72bf-4f32-9721-3f4636353ae3",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"ae251045-850a-4a60-a587-7162fcc78ecc": {
"ai_languageModel": [
[
{
"node": "c94f55ec-721c-489b-89e4-0d02ef73b25e",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"03c2bf53-05eb-492a-924c-db708df11b11": {
"ai_languageModel": [
[
{
"node": "c916fd36-4601-486b-9da3-d441e90be074",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"1d02eb7f-7c33-4278-8ce9-b225bff4dd99": {
"ai_languageModel": [
[
{
"node": "5677b81b-0ebe-4e8f-85d5-0c403a672763",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"c94f55ec-721c-489b-89e4-0d02ef73b25e": {
"main": [
[
{
"node": "c916fd36-4601-486b-9da3-d441e90be074",
"type": "main",
"index": 0
}
]
]
},
"1534a011-ff33-4bbb-a9bc-3ffe0c9443fd": {
"main": [
[
{
"node": "7c04c879-bb9f-49ff-85d4-4e9b459fe065",
"type": "main",
"index": 0
}
]
]
},
"c55ccffc-d620-4162-a944-508775ba8a21": {
"ai_outputParser": [
[
{
"node": "baa054dd-40cd-4176-9c5b-5c3e3efbee36",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"1e136fc1-055e-42c3-b77e-51dcb2bf60e6": {
"main": [
[
{
"node": "55abf7b6-8c29-4f4e-bd9c-cd7813529dd9",
"type": "main",
"index": 0
}
]
]
},
"b57d48a5-44a7-4b0f-984b-69d648614d35": {
"main": [
[
{
"node": "871c5348-be6b-4eb7-9cca-4311b7bed571",
"type": "main",
"index": 0
}
]
]
},
"7c04c879-bb9f-49ff-85d4-4e9b459fe065": {
"main": [
[
{
"node": "1e136fc1-055e-42c3-b77e-51dcb2bf60e6",
"type": "main",
"index": 0
}
]
]
},
"4de9964d-d2c9-42a6-bbb6-9b7da096dbc9": {
"ai_outputParser": [
[
{
"node": "1e136fc1-055e-42c3-b77e-51dcb2bf60e6",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"71e3cd1f-b1c8-4dd5-b7ad-96a638db61ea": {
"ai_outputParser": [
[
{
"node": "871c5348-be6b-4eb7-9cca-4311b7bed571",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"a1a57ceb-2bf4-4fed-9e74-fd548db98491": {
"ai_outputParser": [
[
{
"node": "7b89e91c-f849-4786-89bd-86f07d9d8ad3",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"51c84d52-f235-434a-a484-7a82d385be53": {
"ai_outputParser": [
[
{
"node": "921e60f6-72bf-4f32-9721-3f4636353ae3",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"86c00be2-5ecf-4627-8a78-67ef1a3eef16": {
"ai_outputParser": [
[
{
"node": "c94f55ec-721c-489b-89e4-0d02ef73b25e",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"871c5348-be6b-4eb7-9cca-4311b7bed571": {
"main": [
[
{
"node": "3ab8569d-d3cd-46a4-afe7-e2b359416b50",
"type": "main",
"index": 0
}
]
]
},
"5677b81b-0ebe-4e8f-85d5-0c403a672763": {
"main": [
[
{
"node": "cb4d0d10-5301-488c-861f-98bd873ea1a8",
"type": "main",
"index": 0
}
]
]
},
"7b89e91c-f849-4786-89bd-86f07d9d8ad3": {
"main": [
[
{
"node": "69c50f29-183a-40f3-99e0-4911cb600e57",
"type": "main",
"index": 0
}
]
]
},
"baa054dd-40cd-4176-9c5b-5c3e3efbee36": {
"main": [
[
{
"node": "d835b7ea-c636-49ff-b503-757986aee1ca",
"type": "main",
"index": 0
}
]
]
},
"d835b7ea-c636-49ff-b503-757986aee1ca": {
"main": [
[
{
"node": "b57d48a5-44a7-4b0f-984b-69d648614d35",
"type": "main",
"index": 0
}
]
]
},
"c916fd36-4601-486b-9da3-d441e90be074": {
"main": [
[
{
"node": "5677b81b-0ebe-4e8f-85d5-0c403a672763",
"type": "main",
"index": 0
}
]
]
},
"09244606-227e-42ee-8eee-b39fd9ec1353": {
"main": [
[
{
"node": "d4f30c2d-60c5-4b25-a6ba-945c59fe29a8",
"type": "main",
"index": 0
}
]
]
},
"55abf7b6-8c29-4f4e-bd9c-cd7813529dd9": {
"main": [
[
{
"node": "23fbd89a-1d14-413d-8798-2f1915651fc3",
"type": "main",
"index": 0
}
]
]
},
"921e60f6-72bf-4f32-9721-3f4636353ae3": {
"main": [
[
{
"node": "c94f55ec-721c-489b-89e4-0d02ef73b25e",
"type": "main",
"index": 0
}
]
]
},
"69c50f29-183a-40f3-99e0-4911cb600e57": {
"main": [
[
{
"node": "921e60f6-72bf-4f32-9721-3f4636353ae3",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - プロダクト, 人工知能
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
アクセルレーション隊スプリント計画の自動化
OpenAI、Googleカレンダー、Gmailを使ってアジャイルチームのスプリント計画を自動化
If
Set
Code
+
If
Set
Code
52 ノードWillemijn
プロダクト
データとの対話：テキストをSQLクエリおよび可視化グラフに変換
データと対話：テキストをSQLクエリおよび可視化グラフに変換
If
Set
Merge
+
If
Set
Merge
36 ノードhippolyte-hu
エンジニアリング
自動ニュース要約AIエージェントv13
AIニュース制作チーム：24/7リポート自動化＋Perplexity引用
Set
Code
Gmail
+
Set
Code
Gmail
37 ノードDerek Cheung
プロダクト
Gmail、OpenAI、そしてGoogleスプレッドシートを使った敏捷開発の細化準備の自動化
Gmail、OpenAI、そしてGoogleシートを使った敏捷な振り返り準備の自動化
If
Set
Gmail
+
If
Set
Gmail
51 ノードWillemijn
プロダクト
ブログ投稿自動化とSNSプロモーションエージェント
GPT-4、Perplexity、WordPressを使用したSEOブログ作成の自動化＋ソーシャルメディア
Set
Code
Gmail
+
Set
Code
Gmail
79 ノードLukaszB
デザイン
AIを使ってReddit投稿を分析し、商機を見極める
AIを使ってRedditの投稿を分析してビジネスチャンスを特定する
If
Set
Gmail
+
If
Set
Gmail
22 ノードAlex Huang
プロダクト
