Telegram-Google Sheets 自動化（GPT-4.1 を使用）
上級
これはContent Creation, Multimodal AI分野の自動化ワークフローで、16個のノードを含みます。主にIf, Set, Filter, Telegram, Aggregateなどのノードを使用。 GPT-4.1 を使用した Telegram / Google Sheets 自動化
前提条件
- •Telegram Bot Token
- •Google Sheets API認証情報
- •OpenAI API Key
使用ノード (16)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "40f29e455b10b3ef07629363459d0fa6954887d44ddad18e74a5539a487f2eee",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "df2d582a-6922-40a5-a37f-4e986b59fc20",
"name": "Fetch Freelancer.com RSS",
"type": "n8n-nodes-base.rssFeedRead",
"notes": "🌐 RSS FETCH — Setup\nFetches the latest jobs from Freelancer.com.\n\nCUSTOMIZE URL:\n• ?keyword=wordpress\n• &min_price=500\n• &max_price=5000\n\nExample:\nhttps://www.freelancer.com/rss.xml?keyword=wordpress&min_price=500\n\n💡 Use multiple RSS nodes for multiple keywords.",
"position": [
96,
704
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 1.2
},
{
"id": "d4650966-00dc-4f5f-9cdc-eecb0e8622d1",
"name": "Filter Job Quality",
"type": "n8n-nodes-base.filter",
"notes": "✅ QUALITY FILTER — Customize\nCurrent rules:\n• Description > 100 chars\n• Posted within last 2 hours\n\nOPTIONAL:\n• Budget thresholds (if present in feed)\n• Required/excluded keywords\n\nTIP: Start loose, tighten after 1–2 days.",
"position": [
544,
704
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 2
},
{
"id": "4efcab46-f278-401e-9161-78eda3c4c5b6",
"name": "AI Job Analyzer",
"type": "@n8n/n8n-nodes-langchain.agent",
"notes": "🧠 AI ANALYZER — Setup\nScores the job 1–10, explains reasoning, flags risks, and classifies client type.\n\nTIP: Keep wishlist specific to reduce noise.",
"position": [
768,
704
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 2.2
},
{
"id": "3b3698b9-f690-4d8e-981d-ead12a0e3061",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"notes": "🧩 OUTPUT PARSER — Stability\nForces strict JSON so downstream filters/logging never break.",
"position": [
928,
1008
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 1.3
},
{
"id": "ec090484-ec95-4880-a441-42a8707af572",
"name": "AI Proposal Generator",
"type": "@n8n/n8n-nodes-langchain.openAi",
"notes": "✍️ PROPOSAL WRITER — Customize\nEdit \"My Skills\" / \"My Experience\" and drop one relevant portfolio link.\n\n💡 90% done by AI → add 10% personal touch.",
"position": [
1344,
704
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 1.3
},
{
"id": "a97989f9-d7d6-4e79-9f26-802372548099",
"name": "Google Sheetsにログ記録",
"type": "n8n-nodes-base.googleSheets",
"notes": "📊 JOB LOGGER — Setup\nAppend/Update by Link to avoid duplicates.\n\nRecommended columns: Timestamp | Job | Description | Link | AI Score | Reasoning | Red Flags | Client Type | AI Proposal | Alert Timestamp.",
"position": [
1696,
704
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 4.4
},
{
"id": "5770b44f-d639-4852-a80e-469474e23966",
"name": "Telegramアラートを送信",
"type": "n8n-nodes-base.telegram",
"notes": "📱 TELEGRAM — Setup\nCreate bot with @BotFather → add token in credentials → DM your bot → get Chat ID via @userinfobot and paste here.\n\nTIP: Add buttons via your own webhook for Skip / Applied.",
"position": [
1920,
704
],
"webhookId": "89db660a-6dd5-482f-bdeb-df44a2508245",
"parameters": {},
"notesInFlow": true,
"typeVersion": 1.2
},
{
"id": "f18bd2e8-d87e-42b8-887a-f7b67fd259c7",
"name": "Sticky: SETUP START",
"type": "n8n-nodes-base.stickyNote",
"position": [
-912,
432
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a12e9052-8c1d-406b-95d1-7addfd5a6b31",
"name": "Schedule: 5分ごと",
"type": "n8n-nodes-base.scheduleTrigger",
"notes": "⏰ TRIGGER — Schedule\nRuns this workflow every 5 minutes.\n\n✏️ CUSTOMIZE:\n• 3 min = ultra-competitive niches\n• 10–15 min = lower API cost\n\n💡 TIP: Start at 5 min and tune after 1–2 days based on alert volume.",
"position": [
-800,
704
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 1.1
},
{
"id": "8162d357-6dfb-40ad-9623-bb68e2b9eb9a",
"name": "Settings (Keyword & Wishlist)",
"type": "n8n-nodes-base.set",
"notes": "⚙️ SETTINGS — Setup\nDefine your main keyword and your \"wish list\" criteria.\n\nExamples:\n• Job Keyword: shopify, react, seo\n• Wishlist: \"Budget > $500, clear scope, no vague fixed-price\"\n\n💡 TIP: Clone this node to run multiple keywords in parallel (merge later).",
"position": [
-576,
704
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 3.4
},
{
"id": "747c51cd-4009-4593-8b9f-676571342cbf",
"name": "Load Seen Links (Google Sheets)",
"type": "n8n-nodes-base.googleSheets",
"notes": "📥 DEDUPE SOURCE — Setup\nLoads previously processed links from your tracking sheet.\n\nSETUP:\n• Use the same spreadsheet as the logger\n• Column \"Link\" must exist\n\n🔒 Prevents duplicate alerts.",
"position": [
-352,
704
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 4.4,
"alwaysOutputData": true
},
{
"id": "49826d1a-879b-49df-9cdc-e6dea41b34e4",
"name": "Collect Seen Links",
"type": "n8n-nodes-base.aggregate",
"notes": "🧮 AGGREGATE — Setup\nBuilds a quick lookup of already seen links for the dedupe filter.",
"position": [
-128,
704
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "8482790d-f432-40bc-b7e6-a4184b4e7311",
"name": "De-duplicate by Link",
"type": "n8n-nodes-base.filter",
"notes": "🚫 DEDUPE — Customize\nOnly pass jobs whose link is not already in your sheet.\n\nTIP: If your source has unstable links, switch to a hash of (title+date).",
"position": [
320,
704
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 2.2
},
{
"id": "b19632af-88ae-4e2b-b731-df8b4124545a",
"name": "LLM (OpenAI)",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"notes": "⚙️ LLM BACKEND — Setup\nUsed by Analyzer & Proposal nodes.\n\nTIP: Use gpt-4o-mini for speed/cost unless you need richer reasoning.",
"position": [
800,
1008
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 1.2
},
{
"id": "482ded64-e1b3-472c-bb24-20c3fdf7bd93",
"name": "Gate: Score ≥",
"type": "n8n-nodes-base.if",
"notes": "🎯 SCORE GATE — Customize\nOnly pass jobs with score ≥ 7.\n\n6 = more alerts, 8 = only premium.",
"position": [
1120,
704
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 2
},
{
"id": "d5802bc6-46df-4658-9386-944b92aed5bf",
"name": "CV (Sheets Tool)",
"type": "n8n-nodes-base.googleSheetsTool",
"notes": "🛠️ SHEETS TOOL — Optional\nFor advanced automations (e.g., pulling portfolio snippets). Safe to disable initially.",
"position": [
1424,
928
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 4.7
}
],
"pinData": {},
"connections": {
"b19632af-88ae-4e2b-b731-df8b4124545a": {
"ai_languageModel": [
[
{
"node": "4efcab46-f278-401e-9161-78eda3c4c5b6",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"4efcab46-f278-401e-9161-78eda3c4c5b6": {
"main": [
[
{
"node": "482ded64-e1b3-472c-bb24-20c3fdf7bd93",
"type": "main",
"index": 0
}
]
]
},
"482ded64-e1b3-472c-bb24-20c3fdf7bd93": {
"main": [
[
{
"node": "ec090484-ec95-4880-a441-42a8707af572",
"type": "main",
"index": 0
}
]
]
},
"d5802bc6-46df-4658-9386-944b92aed5bf": {
"ai_tool": [
[
{
"node": "ec090484-ec95-4880-a441-42a8707af572",
"type": "ai_tool",
"index": 0
}
]
]
},
"d4650966-00dc-4f5f-9cdc-eecb0e8622d1": {
"main": [
[
{
"node": "4efcab46-f278-401e-9161-78eda3c4c5b6",
"type": "main",
"index": 0
}
]
]
},
"49826d1a-879b-49df-9cdc-e6dea41b34e4": {
"main": [
[
{
"node": "df2d582a-6922-40a5-a37f-4e986b59fc20",
"type": "main",
"index": 0
}
]
]
},
"a97989f9-d7d6-4e79-9f26-802372548099": {
"main": [
[
{
"node": "5770b44f-d639-4852-a80e-469474e23966",
"type": "main",
"index": 0
}
]
]
},
"ec090484-ec95-4880-a441-42a8707af572": {
"main": [
[
{
"node": "a97989f9-d7d6-4e79-9f26-802372548099",
"type": "main",
"index": 0
}
]
]
},
"8482790d-f432-40bc-b7e6-a4184b4e7311": {
"main": [
[
{
"node": "d4650966-00dc-4f5f-9cdc-eecb0e8622d1",
"type": "main",
"index": 0
}
]
]
},
"df2d582a-6922-40a5-a37f-4e986b59fc20": {
"main": [
[
{
"node": "8482790d-f432-40bc-b7e6-a4184b4e7311",
"type": "main",
"index": 0
}
]
]
},
"3b3698b9-f690-4d8e-981d-ead12a0e3061": {
"ai_outputParser": [
[
{
"node": "4efcab46-f278-401e-9161-78eda3c4c5b6",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"a12e9052-8c1d-406b-95d1-7addfd5a6b31": {
"main": [
[
{
"node": "8162d357-6dfb-40ad-9623-bb68e2b9eb9a",
"type": "main",
"index": 0
}
]
]
},
"8162d357-6dfb-40ad-9623-bb68e2b9eb9a": {
"main": [
[
{
"node": "747c51cd-4009-4593-8b9f-676571342cbf",
"type": "main",
"index": 0
}
]
]
},
"747c51cd-4009-4593-8b9f-676571342cbf": {
"main": [
[
{
"node": "49826d1a-879b-49df-9cdc-e6dea41b34e4",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - コンテンツ作成, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
再生リスト詳細設定ボットコピー
Suno、GPT-4、Runway、Creatomate を使って AI 生成の YouTube ミュージックプレイリストを作成
If
Set
Code
+
If
Set
Code
203 ノードJoseph
コンテンツ作成
Nano Banana と Veo-3 を使って Telegram メッセージから AI 動画を生成
Nano Banana と Veo-3 を使って Telegram メッセージから AI 動画を生成
If
Set
Wait
+
If
Set
Wait
26 ノードSulieman Said
コンテンツ作成
コンテンツジェネレーター v3
AI驱动ブログ自動化：使用GPT-4生成并公開SEO記事至WordPressとTwitter
If
Set
Code
+
If
Set
Code
144 ノードJay Emp0
コンテンツ作成
WordPressブログの自動化プロフェッショナル版（先端研究）v2.1マーケットプラグイン
GPT-4o、Perplexity AI、そして多言語対応を使ったSEO最適化ブログ作成の自動化
If
Set
Xml
+
If
Set
Xml
125 ノードDaniel Ng
コンテンツ作成
LinkedInおよびXウイルスのなコンテンツ自動エンジン
AIを使ってLinkedInとXにウイルスのなコンテンツを自動生成して公開する
If
Set
Wait
+
If
Set
Wait
156 ノードDiptamoy Barman
コンテンツ作成
YouTube 動画に基づく自律ブログ公開
YouTube 動画から ChatGPT、Sheets、Apify、Pexels、WordPress を使用してブログの自主公開
If
Set
Code
+
If
Set
Code
80 ノードOriol Seguí
コンテンツ作成
ワークフロー情報
難易度
上級
ノード数16
カテゴリー2
ノードタイプ14
作成者
Sulieman Said
@sulieman-said👋 Hi, I’m Sulieman – Founder of aufCopilot.de . I build custom n8n workflows, automations & AI integrations to help businesses save time and scale smarter. I share templates, answer questions and love exploring creative use cases – from lead generation to data workflows and AI-powered automations. 🚀 Always happy to connect, learn and contribute to the community. Although my profile is in English, I am a native German speaker and happy to work in both German and English projects.
外部リンク
n8n.ioで表示 →
このワークフローを共有