TelegramとGoogle Sheetsを使った費用記録：週次サマリーと予算アラート
中級
これはPersonal Productivity, Miscellaneous, Multimodal AI分野の自動化ワークフローで、15個のノードを含みます。主にCode, Telegram, GoogleSheets, ScheduleTrigger, TelegramTriggerなどのノードを使用。 TelegramとGoogle Sheetsによる費用記録：週次サマリーと予算アラート
前提条件
- •Telegram Bot Token
- •Google Sheets API認証情報
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "19e5bdcaace8da818cec75a5b6c7d27485bb3218a7ba566cbf475ddfd436a339",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "ce1bf9d0-73d3-44d7-89e6-7a255be132f2",
"name": "付箋 - 概要",
"type": "n8n-nodes-base.stickyNote",
"position": [
-96,
112
],
"parameters": {
"width": 640,
"height": 308,
"content": "# 💸 Telegram Expense Tracker with Google Sheets\nThis workflow lets you log daily expenses from Telegram into Google Sheets, send a **weekly summary**, and fire **budget alerts** when you cross your limit.\n\n- Log an expense: `/spent 5 coffee`\n- Weekly summary every Sunday at 11:00\n- Budget alert threshold default: €100 (edit in *Check Weekly Budget* code)\n\n👉 Read the setup sticky note for configuration."
},
"typeVersion": 1
},
{
"id": "8a39a922-2230-4d47-896e-722009ffcf61",
"name": "付箋 - 日次記録",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
400
],
"parameters": {
"color": 4,
"width": 1232,
"height": 304,
"content": "## Daily logged expenses in sheets\n"
},
"typeVersion": 1
},
{
"id": "d25a775e-f537-4e28-851d-ebf02dc67531",
"name": "付箋 - 週次合計",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
704
],
"parameters": {
"color": 5,
"width": 1056,
"height": 272,
"content": "## Weekly Total \n"
},
"typeVersion": 1
},
{
"id": "e8295340-df45-4f59-a79c-d34284171769",
"name": "Telegram - 支出コマンド取得",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
624,
496
],
"webhookId": "b794fd0e-d6fa-442c-b916-0eb73f65f448",
"parameters": {
"updates": [
"message"
],
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "qFp0dReFa2R5lsei",
"name": "Telegram account"
}
},
"typeVersion": 1.2
},
{
"id": "424fbab2-7a0d-4752-87cf-c678af551858",
"name": "Telegramメッセージ解析",
"type": "n8n-nodes-base.code",
"position": [
816,
496
],
"parameters": {
"jsCode": "const msg = $json.message.text; // e.g. \"/spent 4 coffee\"\nconst parts = msg.split(\" \"); // [\"/spent\", \"4\", \"coffee\"]\nreturn [{\n json: {\n amount: parseFloat(parts[1]),\n description: parts.slice(2).join(\" \"),\n date: new Date().toISOString().split(\"T\")[0] // YYYY-MM-DD\n }\n}];\n"
},
"typeVersion": 2
},
{
"id": "fe60d073-a130-40c4-b44c-d9f7047d6432",
"name": "Google Sheets - 支出記録",
"type": "n8n-nodes-base.googleSheets",
"position": [
1008,
496
],
"parameters": {
"columns": {
"value": {
"Date ": "={{ $json.date }}",
"Amount ": "={{ $json.amount }}",
"Description": "={{ $json.description }}"
},
"schema": [
{
"id": "Date ",
"type": "string",
"display": true,
"required": false,
"displayName": "Date ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Amount ",
"type": "string",
"display": true,
"required": false,
"displayName": "Amount ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "<YOUR_SHEET_ID>"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ktGp50kJq6nhFH5q",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "89969a35-a406-46a2-80b9-68b91d06eee3",
"name": "週次集計トリガー",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
640,
800
],
"parameters": {
"rule": {
"interval": [
{
"field": "weeks",
"triggerAtHour": 11
}
]
}
},
"typeVersion": 1.2
},
{
"id": "538c8dec-9443-429f-830f-964af2e09092",
"name": "週次合計計算",
"type": "n8n-nodes-base.code",
"position": [
1056,
800
],
"parameters": {
"jsCode": "const rows = items.map(item => item.json);\n\nconst now = new Date();\nconst weekAgo = new Date();\nweekAgo.setDate(now.getDate() - 7);\n\nlet total = 0;\nfor (let r of rows) {\n // Handle column name issues (trim spaces in keys)\n const dateStr = r[\"Date\"] || r[\"Date \"] || r[\"date\"];\n const amountStr = r[\"Amount\"] || r[\"Amount \"] || r[\"amount\"];\n\n // Try parsing date safely (Google Sheets often gives YYYY-MM-DD if set to ISO)\n const d = new Date(dateStr);\n\n if (!isNaN(d)) {\n if (d >= weekAgo && d <= now) {\n total += parseFloat(amountStr) || 0;\n }\n }\n}\n\nreturn [{\n json: { summary: `💰 Your total expenses this week: €${total.toFixed(2)}` }\n}];\n"
},
"typeVersion": 2
},
{
"id": "f2fb125e-a966-4e4b-ac87-729eee25771f",
"name": "Telegram - 週次集計送信",
"type": "n8n-nodes-base.telegram",
"position": [
1264,
800
],
"webhookId": "cd477ad5-32ee-4d4f-a864-694323cdf656",
"parameters": {
"text": "={{$json[\"summary\"]}}",
"chatId": "<YOUR_CHAT_ID>",
"additionalFields": {
"appendAttribution": false
}
},
"credentials": {
"telegramApi": {
"id": "qFp0dReFa2R5lsei",
"name": "Telegram account"
}
},
"typeVersion": 1.2
},
{
"id": "de30a959-b686-4868-b526-008cfad554e8",
"name": "付箋 - セットアップガイド",
"type": "n8n-nodes-base.stickyNote",
"position": [
16,
416
],
"parameters": {
"color": 6,
"width": 528,
"height": 496,
"content": "# 🛠️ Setup Guide \n**Author:** [Giorgos Tarasidis]\n\n---\n### 1️⃣ Create a telegram bot\n- Go to botfather in telegram and press /newbot.\nFrom there get your API key \n- Visit: https://api.telegram.org/bot<YOUR_BOT_TOKEN>/getUpdates\n- Look for the \"chat\" object in the response - the \"id\" field is your chat ID\n\n---\n\n#### 2️⃣ Expense bot sheet (Google Sheets) \n🔗 **[Make a copy of the template](https://docs.google.com/spreadsheets/d/1uyQpX9_ZZUhLtBhyxfjdU80D6Q6cqbMV286MnhF5QBY/edit?usp=sharing)** \n- Set up your Google Sheets credentials \n- Connect your Google credential \n- Customize the sheet as needed (optional)\n---\n"
},
"typeVersion": 1
},
{
"id": "2f11e041-b267-4ee3-b097-13b64250acfc",
"name": "Google Sheets - クリーンアップ（オプション）",
"type": "n8n-nodes-base.googleSheets",
"position": [
1472,
800
],
"parameters": {
"operation": "delete",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "<YOUR_SHEET_ID>"
},
"numberToDelete": 30
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ktGp50kJq6nhFH5q",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "77d677fc-5c20-4d6a-934f-6c11b03d2b62",
"name": "Google Sheets - 週次支出取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
848,
800
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "<YOUR_SHEET_ID>"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ktGp50kJq6nhFH5q",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "1a7dd79f-cfe3-4612-9efc-3995ad521e5e",
"name": "Google Sheets - 支出取得（リアルタイム）",
"type": "n8n-nodes-base.googleSheets",
"position": [
1232,
496
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "<YOUR_SHEET_ID>"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ktGp50kJq6nhFH5q",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "d3a25a1b-e05a-4984-8ab3-8c22d90b8a1b",
"name": "週次予算確認",
"type": "n8n-nodes-base.code",
"position": [
1440,
496
],
"parameters": {
"jsCode": "const rows = items.map(item => item.json);\n\nlet total = 0;\nfor (let r of rows) {\n const amountStr = r[\"Amount\"] || r[\"Amount \"] || r[\"amount\"];\n total += parseFloat(amountStr) || 0;\n}\n\nif (total > 100) {\n return [{\n json: {\n alert: `⚠️ Warning Giorgos! You have exceeded your weekly budget of 100€ (€${total.toFixed(2)})`\n }\n }];\n} else {\n return [];\n}"
},
"typeVersion": 2
},
{
"id": "6b30f059-d3d0-4117-bb06-0d027f0d95eb",
"name": "Telegram - 予算アラート送信",
"type": "n8n-nodes-base.telegram",
"position": [
1632,
496
],
"webhookId": "5d273b13-40db-441d-8dc5-f753e7b8256e",
"parameters": {
"text": "={{$json[\"alert\"]}}",
"chatId": "<YOUR_CHAT_ID>",
"additionalFields": {
"appendAttribution": false
}
},
"credentials": {
"telegramApi": {
"id": "qFp0dReFa2R5lsei",
"name": "Telegram account"
}
},
"typeVersion": 1.2
}
],
"pinData": {},
"connections": {
"d3a25a1b-e05a-4984-8ab3-8c22d90b8a1b": {
"main": [
[
{
"node": "6b30f059-d3d0-4117-bb06-0d027f0d95eb",
"type": "main",
"index": 0
}
]
]
},
"538c8dec-9443-429f-830f-964af2e09092": {
"main": [
[
{
"node": "f2fb125e-a966-4e4b-ac87-729eee25771f",
"type": "main",
"index": 0
}
]
]
},
"424fbab2-7a0d-4752-87cf-c678af551858": {
"main": [
[
{
"node": "fe60d073-a130-40c4-b44c-d9f7047d6432",
"type": "main",
"index": 0
}
]
]
},
"89969a35-a406-46a2-80b9-68b91d06eee3": {
"main": [
[
{
"node": "77d677fc-5c20-4d6a-934f-6c11b03d2b62",
"type": "main",
"index": 0
}
]
]
},
"fe60d073-a130-40c4-b44c-d9f7047d6432": {
"main": [
[
{
"node": "1a7dd79f-cfe3-4612-9efc-3995ad521e5e",
"type": "main",
"index": 0
}
]
]
},
"e8295340-df45-4f59-a79c-d34284171769": {
"main": [
[
{
"node": "424fbab2-7a0d-4752-87cf-c678af551858",
"type": "main",
"index": 0
}
]
]
},
"f2fb125e-a966-4e4b-ac87-729eee25771f": {
"main": [
[
{
"node": "2f11e041-b267-4ee3-b097-13b64250acfc",
"type": "main",
"index": 0
}
]
]
},
"77d677fc-5c20-4d6a-934f-6c11b03d2b62": {
"main": [
[
{
"node": "538c8dec-9443-429f-830f-964af2e09092",
"type": "main",
"index": 0
}
]
]
},
"1a7dd79f-cfe3-4612-9efc-3995ad521e5e": {
"main": [
[
{
"node": "d3a25a1b-e05a-4984-8ab3-8c22d90b8a1b",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - 個人の生産性, その他, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
水道料金
Telegram、Gemini AI、そして Google Sheets を使って水道料金の計算を自動化
Set
Code
Switch
+
Set
Code
Switch
15 ノードMiftah Rahmat
その他
💥 NanoBanana と Seedance を使ってウイルスの広告を作成し、upload-post でソーシャルメディアに VIDE II を投稿
AI を使ってウイルスのなマルチメディア広告の作成：NanoBanana、Seedance、Suno を使ったソーシャルメディア
If
Set
Code
+
If
Set
Code
45 ノードDr. Firas
その他
毎日のMLB投手対バッター対戦分析（Google Sheets + Telegram）
Google シートとTelegramを使用したMLBピッチャー対バッティングマッチアップ分析毎日
Code
Telegram
Http Request
+
Code
Telegram
Http Request
14 ノードTheStock
その他
Telegramフォーラムペルス：コミュニティモニタリングのためのGeminiとGroq AIモデル
Telegramフォーラムペルス：GeminiとGroq AIモデルを使ったコミュニティ監視
If
Set
Code
+
If
Set
Code
59 ノードNguyen Thieu Toan
その他
💥NanoBananaとVEO3でAIウイルス動画を作成し、BlotatoでSNSに共有 - 動画
NanoBananaとVEO3でAIウイルス動画を生成し、BlotatoでSNSで共有する
Set
Code
Wait
+
Set
Code
Wait
47 ノードDr. Firas
その他
Gemini、Tavily および人間の審査を使用して SEO 最適化された WordPress ブログを生成
Gemini、Tavily、そして人間の審査を使ってSEO最適化されたWordPressブログを生成する
If
Set
Code
+
If
Set
Code
38 ノードAryan Shinde
コンテンツ作成
