WhatsApp と Telegram の AI トークン追跡ツール - AI 使用状況を Google スプレッドシートに保存
上級
これはFinance, AI, IT Ops分野の自動化ワークフローで、37個のノードを含みます。主にIf, Set, Code, Filter, Switchなどのノードを使用、AI技術を活用したスマート自動化を実現。 WhatsAppとTelegramのAIトークントラッカー - AI使用状況をGoogleスプレッドシートに保存
前提条件
- •HTTP Webhookエンドポイント（n8nが自動生成）
- •Telegram Bot Token
- •Googleアカウント + Gmail API認証情報
- •ターゲットAPIの認証情報が必要な場合あり
- •Airtable API Key
- •Google Sheets API認証情報
- •OpenAI API Key
使用ノード (37)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "aeYhwC8OyRGijiTb",
"meta": {
"instanceId": "b79da95dcb1b69eebc3470f6fd833d7e53e389c229c716386bdb8e7c291ad2b9"
},
"name": "📊 AI Token Tracker for WhatsApp & Telegram – Save AI Usage to Google Sheets",
"tags": [
{
"id": "mhx5MJAkz32rJgeQ",
"name": "iloveflows.com",
"createdAt": "2025-05-09T14:28:31.509Z",
"updatedAt": "2025-05-09T14:28:31.509Z"
}
],
"nodes": [
{
"id": "bbfc6da2-6c99-4907-b46f-a32df9308aef",
"name": "メール送信",
"type": "n8n-nodes-base.gmailTool",
"disabled": true,
"position": [
660,
280
],
"webhookId": "18eaba1a-1821-4b08-b623-7496a908f4d3",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "3e402e46-f5f9-432f-bee1-9b7c5f98c2b4",
"name": "連絡先取得",
"type": "n8n-nodes-base.airtableTool",
"disabled": true,
"position": [
760,
280
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "36d8be2b-76a9-4ee1-b42e-185d867552e8",
"name": "ログ",
"type": "n8n-nodes-base.googleSheets",
"position": [
1160,
0
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "54800e58-3348-4ea7-b1f2-f3b330441add",
"name": "イベント作成",
"type": "n8n-nodes-base.googleCalendarTool",
"disabled": true,
"position": [
860,
280
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "ce41257e-356f-4b7a-b92e-90a766a29ce5",
"name": "クリーンアップ",
"type": "n8n-nodes-base.code",
"position": [
1020,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a91da594-54cc-4bba-83ae-db4a3d5a6aa6",
"name": "エラー",
"type": "n8n-nodes-base.googleSheets",
"position": [
1160,
280
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "431a8770-0a6b-4d63-ad40-2be04216ebdc",
"name": "エラーレスポンス",
"type": "n8n-nodes-base.telegram",
"position": [
1720,
280
],
"webhookId": "4129bcc4-aa42-4404-8cf4-9731422f7e86",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "b649cc8a-4814-4730-a18a-ed3a40c79701",
"name": "レスポンス",
"type": "n8n-nodes-base.telegram",
"position": [
1720,
0
],
"webhookId": "e71223d1-8880-4a0f-98b1-d7b002378954",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "e86b5d5d-05a2-46f9-82a7-1fca39ec88ce",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-680,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4277b9b8-2be1-4e7a-a89e-e446287007df",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "540d74a0-e4e8-426d-b39f-5553ffd8d203",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f8fdc426-f97e-4d51-affe-7443b368d3a5",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1bb5794e-82ff-4d59-a640-db42fd043604",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "13b54670-f5c8-4ffd-b746-0f3a8e5301d2",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "46aa0a5e-719f-4e15-9723-60a02bdc82c8",
"name": "クリーンアップ",
"type": "n8n-nodes-base.code",
"position": [
1020,
280
],
"parameters": {},
"typeVersion": 2
},
{
"id": "e48dbb12-ddd1-4891-84b2-5afbfe5eab28",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
"name": "AIエージェント",
"type": "@n8n/n8n-nodes-langchain.agent",
"onError": "continueErrorOutput",
"position": [
580,
-20
],
"parameters": {},
"typeVersion": 1.9
},
{
"id": "07cf1d5a-7f4f-4827-bf33-fa4deca0fb8b",
"name": "付箋8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1220,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "eafbda63-9d18-4c5b-8528-ec6f99b6d513",
"name": "Evolution API",
"type": "n8n-nodes-base.webhook",
"position": [
-620,
80
],
"webhookId": "08b83c00-ab4b-4753-8415-93168690ce57",
"parameters": {},
"typeVersion": 2
},
{
"id": "631e3652-49d3-4a53-8f8f-44baab5fc4fb",
"name": "メディア取得",
"type": "n8n-nodes-base.httpRequest",
"position": [
-20,
-20
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "85ae2fa7-17af-408f-9c98-03ca6e8c8e57",
"name": "付箋19",
"type": "n8n-nodes-base.stickyNote",
"position": [
-300,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4a23d554-a01f-4eed-9325-01a9d8464279",
"name": "付箋20",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3195e145-a460-40b0-92e4-aba90f60ee42",
"name": "音声/テキスト分離",
"type": "n8n-nodes-base.if",
"position": [
-240,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "73ec0645-70f4-40d2-abe2-14a64dc1bcff",
"name": "ファイル変換",
"type": "n8n-nodes-base.convertToFile",
"position": [
120,
-20
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "8f4c5346-4a0f-4f48-b2a7-00863d7305db",
"name": "音声文字起こし",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
260,
-20
],
"parameters": {},
"typeVersion": 1.6
},
{
"id": "b338cf7b-1a87-4a66-8b20-e20357dc81fd",
"name": "Telegram",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-620,
260
],
"webhookId": "dcfa2f69-f5d4-4f3d-926f-d14f6e3e59f3",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "30d66342-6afb-4bc6-801e-b04359204feb",
"name": "付箋21",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "72bd6f8f-ebad-4f38-8028-520fb76d6f6c",
"name": "フィルター",
"type": "n8n-nodes-base.filter",
"position": [
260,
280
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "733a7a45-b428-4bc9-806b-16a08749e8eb",
"name": "テキストマッピング",
"type": "n8n-nodes-base.set",
"position": [
-20,
280
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "96e1ec07-f9d5-4d7f-93ba-fb20b94fec6e",
"name": "チャットモデル",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
500,
300
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c0b0c08a-01f5-4c18-a4f4-c930e3bfc6ed",
"name": "入力ソース",
"type": "n8n-nodes-base.switch",
"position": [
1340,
-20
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "96279412-1dad-4af2-a327-280f9cd8e866",
"name": "マップ",
"type": "n8n-nodes-base.set",
"position": [
-480,
80
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "614e597e-e7a5-4296-be51-d3b9649d00f8",
"name": "マップ1",
"type": "n8n-nodes-base.set",
"position": [
-480,
260
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "be1d7967-70bd-403b-8d1f-7b3949ae7deb",
"name": "WhatsApp",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
-80
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "c6cb3ba8-0655-405d-b440-563f2c7f2de6",
"name": "WhatsApp エラー",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
200
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "a375dd86-192c-4bc8-b62f-d92a17c6d0c2",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bd7b5899-0060-4cf9-a776-486c94186124",
"name": "入力ソース1",
"type": "n8n-nodes-base.switch",
"position": [
1340,
260
],
"parameters": {},
"typeVersion": 3.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "d3370083-c273-4631-83e3-9df174874430",
"connections": {
"36d8be2b-76a9-4ee1-b42e-185d867552e8": {
"main": [
[
{
"node": "c0b0c08a-01f5-4c18-a4f4-c930e3bfc6ed",
"type": "main",
"index": 0
}
]
]
},
"96279412-1dad-4af2-a327-280f9cd8e866": {
"main": [
[
{
"node": "3195e145-a460-40b0-92e4-aba90f60ee42",
"type": "main",
"index": 0
}
]
]
},
"614e597e-e7a5-4296-be51-d3b9649d00f8": {
"main": [
[
{
"node": "733a7a45-b428-4bc9-806b-16a08749e8eb",
"type": "main",
"index": 0
}
]
]
},
"a91da594-54cc-4bba-83ae-db4a3d5a6aa6": {
"main": [
[
{
"node": "bd7b5899-0060-4cf9-a776-486c94186124",
"type": "main",
"index": 0
}
]
]
},
"72bd6f8f-ebad-4f38-8028-520fb76d6f6c": {
"main": [
[
{
"node": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
"type": "main",
"index": 0
}
]
]
},
"e7435546-bbc0-4d9c-9e11-23f882cb0077": {
"main": [
[
{
"node": "46aa0a5e-719f-4e15-9723-60a02bdc82c8",
"type": "main",
"index": 0
}
],
[
{
"node": "46aa0a5e-719f-4e15-9723-60a02bdc82c8",
"type": "main",
"index": 0
}
]
]
},
"46aa0a5e-719f-4e15-9723-60a02bdc82c8": {
"main": [
[
{
"node": "a91da594-54cc-4bba-83ae-db4a3d5a6aa6",
"type": "main",
"index": 0
}
]
]
},
"b338cf7b-1a87-4a66-8b20-e20357dc81fd": {
"main": [
[
{
"node": "614e597e-e7a5-4296-be51-d3b9649d00f8",
"type": "main",
"index": 0
}
]
]
},
"631e3652-49d3-4a53-8f8f-44baab5fc4fb": {
"main": [
[
{
"node": "73ec0645-70f4-40d2-abe2-14a64dc1bcff",
"type": "main",
"index": 0
}
]
]
},
"96e1ec07-f9d5-4d7f-93ba-fb20b94fec6e": {
"ai_languageModel": [
[
{
"node": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"bbfc6da2-6c99-4907-b46f-a32df9308aef": {
"ai_tool": [
[
{
"node": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
"type": "ai_tool",
"index": 0
}
]
]
},
"54800e58-3348-4ea7-b1f2-f3b330441add": {
"ai_tool": [
[
{
"node": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
"type": "ai_tool",
"index": 0
}
]
]
},
"3e402e46-f5f9-432f-bee1-9b7c5f98c2b4": {
"ai_tool": [
[
{
"node": "e7435546-bbc0-4d9c-9e11-23f882cb0077",
"type": "ai_tool",
"index": 0
}
]
]
},
"c0b0c08a-01f5-4c18-a4f4-c930e3bfc6ed": {
"main": [
[
{
"node": "be1d7967-70bd-403b-8d1f-7b3949ae7deb",
"type": "main",
"index": 0
}
],
[
{
"node": "b649cc8a-4814-4730-a18a-ed3a40c79701",
"type": "main",
"index": 0
}
]
]
},
"733a7a45-b428-4bc9-806b-16a08749e8eb": {
"main": [
[
{
"node": "72bd6f8f-ebad-4f38-8028-520fb76d6f6c",
"type": "main",
"index": 0
}
]
]
},
"eafbda63-9d18-4c5b-8528-ec6f99b6d513": {
"main": [
[
{
"node": "96279412-1dad-4af2-a327-280f9cd8e866",
"type": "main",
"index": 0
}
]
]
},
"bd7b5899-0060-4cf9-a776-486c94186124": {
"main": [
[
{
"node": "c6cb3ba8-0655-405d-b440-563f2c7f2de6",
"type": "main",
"index": 0
}
],
[
{
"node": "431a8770-0a6b-4d63-ad40-2be04216ebdc",
"type": "main",
"index": 0
}
]
]
},
"73ec0645-70f4-40d2-abe2-14a64dc1bcff": {
"main": [
[
{
"node": "8f4c5346-4a0f-4f48-b2a7-00863d7305db",
"type": "main",
"index": 0
}
]
]
},
"8f4c5346-4a0f-4f48-b2a7-00863d7305db": {
"main": [
[
{
"node": "733a7a45-b428-4bc9-806b-16a08749e8eb",
"type": "main",
"index": 0
}
]
]
},
"3195e145-a460-40b0-92e4-aba90f60ee42": {
"main": [
[
{
"node": "631e3652-49d3-4a53-8f8f-44baab5fc4fb",
"type": "main",
"index": 0
}
],
[
{
"node": "733a7a45-b428-4bc9-806b-16a08749e8eb",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 財務, 人工知能, IT運用
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
[テンプレート] AIペットショップ v8
AIペットショップアシスタント - GPT-4o、Googleカレンダー、WhatsApp/Instagram/Facebookを統合
If
N8n
Set
+
If
N8n
Set
244 ノードAmanda Benks
営業
AI エージェント レストラン [テンプレート]
🤖 WhatsApp、Instagram、MessengerのAIレストランアシスタント
If
N8n
Set
+
If
N8n
Set
239 ノードAmanda Benks
その他
ペットショップ 4
ペットショップ予約AIエージェント
If
Set
Code
+
If
Set
Code
187 ノードBruno Dias
人工知能
スマート资金管理器
基于Telegram、Google SheetsとOpenAIのAI驱动收据と支出追踪器
If
Set
Code
+
If
Set
Code
50 ノードKhairul Muhtadin
財務
個人 - TRMの申請
Telegram ボットと AI 日付認識でコロンビアペソ為替レートを取得
If
Set
Code
+
If
Set
Code
31 ノードJuan Sanchez
財務
🤖 WhatsApp AI个人アシスタント：GPT-4o、记忆と日程安排功能
AI个人アシスタント：統合GPT-4o、RAGと语音功能，使用SupabaseのWhatsAppアシスタント
If
Set
Wait
+
If
Set
Wait
76 ノードAmanda Benks
人工知能
ワークフロー情報
難易度
上級
ノード数37
カテゴリー3
ノードタイプ18
作成者
Amanda Benks
@amandaHi loves! I've been making workflows for n8n for two years, and I hope you like my flows <3
外部リンク
n8n.ioで表示 →
このワークフローを共有