Googleテーブル経由Telegramでの収支追跡の自動化
上級
これはPersonal Productivity分野の自動化ワークフローで、31個のノードを含みます。主にCode, Switch, Telegram, GoogleSheets, TelegramTriggerなどのノードを使用。 Telegram を使って Google スプレッドシートで収支追跡を自動化
前提条件
- •Telegram Bot Token
- •Google Sheets API認証情報
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "ba73835d772fb31a8c93dbcda773c1ef34e21227b9c152c1ee6fdf0eab995f28",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "326fd72f-6856-47f8-a033-7adbb2eea738",
"name": "Telegram - 受信 Webhook",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-100,
200
],
"webhookId": "d38ec46a-5c4e-48af-a415-400392021f4c",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "f8d79eab-fbcd-46e2-822d-b64f6cdf2343",
"name": "メッセージタイプを検出",
"type": "n8n-nodes-base.code",
"position": [
80,
200
],
"parameters": {},
"typeVersion": 2
},
{
"id": "cd68fd6e-653a-4cd1-92a4-ebcc7821c36e",
"name": "入力タイプでルーティング",
"type": "n8n-nodes-base.switch",
"position": [
260,
200
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "4e054ecd-82dc-4e39-97f1-5bc2eb3e2e40",
"name": "/startまたはメッセージ入力を処理",
"type": "n8n-nodes-base.switch",
"position": [
480,
0
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "35faafd8-42c9-44cb-8612-deaa5270f186",
"name": "収入/支出オプションを表示",
"type": "n8n-nodes-base.telegram",
"position": [
700,
-160
],
"webhookId": "34ce0d27-2e04-4402-beef-cbfc0b0c2c7f",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "83d3e6b4-c30c-418b-bc09-53876fd047a3",
"name": "入力形式を検証",
"type": "n8n-nodes-base.code",
"position": [
700,
20
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8bfb1fac-30ce-4c3a-b7af-2c8ffe6fb259",
"name": "データタイプを抽出",
"type": "n8n-nodes-base.code",
"position": [
940,
20
],
"parameters": {},
"typeVersion": 2
},
{
"id": "50185b94-d3ce-4c5b-b88a-eb48712abc1b",
"name": "データタイプに基づきルーティング",
"type": "n8n-nodes-base.switch",
"position": [
1140,
20
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "dfa8ee96-8dee-4cf6-b14d-58aad6fb2c66",
"name": "収入データを解析",
"type": "n8n-nodes-base.code",
"position": [
1340,
-100
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ba76cb99-365d-4b49-8935-ca44a17662b6",
"name": "収入をシートに保存",
"type": "n8n-nodes-base.googleSheets",
"position": [
1540,
-100
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "ea50a3b1-40ff-48d3-940c-badc9c474526",
"name": "ユーザーに収入記録を通知",
"type": "n8n-nodes-base.telegram",
"position": [
1740,
-100
],
"webhookId": "39b21e24-7b4f-4c83-b410-e0824d8f1089",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "9d8399a5-f689-4589-b5ab-2b5735613a12",
"name": "支出データを解析",
"type": "n8n-nodes-base.code",
"position": [
1340,
40
],
"parameters": {},
"typeVersion": 2
},
{
"id": "73831130-fb6a-4040-8857-b256203b8502",
"name": "支出をシートに保存",
"type": "n8n-nodes-base.googleSheets",
"position": [
1540,
40
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "fa0c19ae-f044-4533-b885-9ddc26522344",
"name": "ユーザーに保留中の支出を通知",
"type": "n8n-nodes-base.telegram",
"position": [
1740,
40
],
"webhookId": "baf321e6-3b8f-4451-aaa3-a2c768635d55",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "f06a85ad-5f76-485c-94cf-8465aae0ea50",
"name": "承認リクエストを送信",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
40
],
"webhookId": "3745c927-de23-40f5-9149-9085fd62c886",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "4e3b3a12-3b18-4bd2-ac24-25e39e1c171b",
"name": "コールバック応答を解析",
"type": "n8n-nodes-base.code",
"position": [
480,
360
],
"parameters": {},
"typeVersion": 2
},
{
"id": "775e82a0-083b-4d1d-b31c-ce6069572e36",
"name": "コールバックタイプに基づきルーティング",
"type": "n8n-nodes-base.switch",
"position": [
700,
320
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "45561880-459f-4b5b-97b4-0f0d8185be2d",
"name": "承認ステータスを更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
940,
220
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "a5990c44-03a0-4fe5-b822-be593b352559",
"name": "承認済み行を取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
1140,
220
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "ca1d1ff9-9d0c-44eb-8e64-4c2785692c35",
"name": "承認結果をユーザーに通知",
"type": "n8n-nodes-base.telegram",
"position": [
1340,
220
],
"webhookId": "8a346a95-d9a8-43e7-9b7e-46efcdfa53c9",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "e5142ba0-50d8-450a-bbd1-45488cf6c386",
"name": "詳細表示用の行を取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
940,
420
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "fe629ffa-ded8-4e94-bda9-a4206a928e06",
"name": "支出詳細メッセージをフォーマット",
"type": "n8n-nodes-base.code",
"position": [
1140,
420
],
"parameters": {},
"typeVersion": 2
},
{
"id": "fd3f93a9-6664-4821-9a37-8e63bcafdd8d",
"name": "支出詳細を監督者に送信",
"type": "n8n-nodes-base.telegram",
"position": [
1340,
420
],
"webhookId": "0c007b17-b53c-4c0d-92e5-f9a7f5a270e5",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "461f7a4e-035b-4ed9-baa1-cd79586d2e3e",
"name": "収入入力形式を表示",
"type": "n8n-nodes-base.code",
"position": [
940,
580
],
"parameters": {},
"typeVersion": 2
},
{
"id": "afbeeb5b-21a3-4a89-b85d-cc85ff6fe19a",
"name": "支出入力形式を表示",
"type": "n8n-nodes-base.code",
"position": [
940,
740
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a7efd0d0-363f-4d27-9744-81e3eb9587a5",
"name": "収入形式メッセージを送信",
"type": "n8n-nodes-base.telegram",
"position": [
1140,
580
],
"webhookId": "ad996647-1e41-4a81-9e31-001dc890cead",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "710ecddd-d353-41e7-8749-9a11e5816607",
"name": "支出形式メッセージを送信",
"type": "n8n-nodes-base.telegram",
"position": [
1140,
740
],
"webhookId": "6307cfda-748c-47a6-8e6d-1428c69ee157",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "936e41c7-727c-47db-a093-c0ad14b86f0e",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1460,
-1000
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "aca473db-b4b3-4b48-8bb8-9f213af8fd0f",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1700,
100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8065e1bb-a036-43dd-8427-1e98d9335339",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1000,
100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "75124148-3558-4cba-84fd-eb2dafba86a6",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1460,
840
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"a5990c44-03a0-4fe5-b822-be593b352559": {
"main": [
[
{
"node": "ca1d1ff9-9d0c-44eb-8e64-4c2785692c35",
"type": "main",
"index": 0
}
]
]
},
"8bfb1fac-30ce-4c3a-b7af-2c8ffe6fb259": {
"main": [
[
{
"node": "50185b94-d3ce-4c5b-b88a-eb48712abc1b",
"type": "main",
"index": 0
}
]
]
},
"dfa8ee96-8dee-4cf6-b14d-58aad6fb2c66": {
"main": [
[
{
"node": "ba76cb99-365d-4b49-8935-ca44a17662b6",
"type": "main",
"index": 0
}
]
]
},
"9d8399a5-f689-4589-b5ab-2b5735613a12": {
"main": [
[
{
"node": "73831130-fb6a-4040-8857-b256203b8502",
"type": "main",
"index": 0
}
]
]
},
"f8d79eab-fbcd-46e2-822d-b64f6cdf2343": {
"main": [
[
{
"node": "cd68fd6e-653a-4cd1-92a4-ebcc7821c36e",
"type": "main",
"index": 0
}
]
]
},
"cd68fd6e-653a-4cd1-92a4-ebcc7821c36e": {
"main": [
[
{
"node": "4e054ecd-82dc-4e39-97f1-5bc2eb3e2e40",
"type": "main",
"index": 0
}
],
[
{
"node": "4e3b3a12-3b18-4bd2-ac24-25e39e1c171b",
"type": "main",
"index": 0
}
]
]
},
"ba76cb99-365d-4b49-8935-ca44a17662b6": {
"main": [
[
{
"node": "ea50a3b1-40ff-48d3-940c-badc9c474526",
"type": "main",
"index": 0
}
]
]
},
"73831130-fb6a-4040-8857-b256203b8502": {
"main": [
[
{
"node": "fa0c19ae-f044-4533-b885-9ddc26522344",
"type": "main",
"index": 0
}
]
]
},
"f06a85ad-5f76-485c-94cf-8465aae0ea50": {
"main": [
[]
]
},
"83d3e6b4-c30c-418b-bc09-53876fd047a3": {
"main": [
[
{
"node": "8bfb1fac-30ce-4c3a-b7af-2c8ffe6fb259",
"type": "main",
"index": 0
}
]
]
},
"45561880-459f-4b5b-97b4-0f0d8185be2d": {
"main": [
[
{
"node": "a5990c44-03a0-4fe5-b822-be593b352559",
"type": "main",
"index": 0
}
]
]
},
"e5142ba0-50d8-450a-bbd1-45488cf6c386": {
"main": [
[
{
"node": "fe629ffa-ded8-4e94-bda9-a4206a928e06",
"type": "main",
"index": 0
}
]
]
},
"4e3b3a12-3b18-4bd2-ac24-25e39e1c171b": {
"main": [
[
{
"node": "775e82a0-083b-4d1d-b31c-ce6069572e36",
"type": "main",
"index": 0
}
]
]
},
"50185b94-d3ce-4c5b-b88a-eb48712abc1b": {
"main": [
[
{
"node": "dfa8ee96-8dee-4cf6-b14d-58aad6fb2c66",
"type": "main",
"index": 0
}
],
[
{
"node": "9d8399a5-f689-4589-b5ab-2b5735613a12",
"type": "main",
"index": 0
}
],
[]
]
},
"461f7a4e-035b-4ed9-baa1-cd79586d2e3e": {
"main": [
[
{
"node": "a7efd0d0-363f-4d27-9744-81e3eb9587a5",
"type": "main",
"index": 0
}
]
]
},
"afbeeb5b-21a3-4a89-b85d-cc85ff6fe19a": {
"main": [
[
{
"node": "710ecddd-d353-41e7-8749-9a11e5816607",
"type": "main",
"index": 0
}
]
]
},
"fa0c19ae-f044-4533-b885-9ddc26522344": {
"main": [
[
{
"node": "f06a85ad-5f76-485c-94cf-8465aae0ea50",
"type": "main",
"index": 0
}
]
]
},
"326fd72f-6856-47f8-a033-7adbb2eea738": {
"main": [
[
{
"node": "f8d79eab-fbcd-46e2-822d-b64f6cdf2343",
"type": "main",
"index": 0
}
]
]
},
"775e82a0-083b-4d1d-b31c-ce6069572e36": {
"main": [
[
{
"node": "45561880-459f-4b5b-97b4-0f0d8185be2d",
"type": "main",
"index": 0
}
],
[
{
"node": "45561880-459f-4b5b-97b4-0f0d8185be2d",
"type": "main",
"index": 0
}
],
[
{
"node": "e5142ba0-50d8-450a-bbd1-45488cf6c386",
"type": "main",
"index": 0
}
],
[
{
"node": "461f7a4e-035b-4ed9-baa1-cd79586d2e3e",
"type": "main",
"index": 0
}
],
[
{
"node": "afbeeb5b-21a3-4a89-b85d-cc85ff6fe19a",
"type": "main",
"index": 0
}
]
]
},
"fe629ffa-ded8-4e94-bda9-a4206a928e06": {
"main": [
[
{
"node": "fd3f93a9-6664-4821-9a37-8e63bcafdd8d",
"type": "main",
"index": 0
}
]
]
},
"4e054ecd-82dc-4e39-97f1-5bc2eb3e2e40": {
"main": [
[
{
"node": "35faafd8-42c9-44cb-8612-deaa5270f186",
"type": "main",
"index": 0
}
],
[
{
"node": "83d3e6b4-c30c-418b-bc09-53876fd047a3",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 個人の生産性
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
Telegram を使った Pollinations による画像生成、そして Gemini 2.5 でブログ記事生成
Telegram を使って Pollinations で画像を生成し、Gemini 2.5 でブログ記事を生成
If
Set
Code
+
If
Set
Code
34 ノードFahmi Oktafian
コンテンツ作成
Gemini、音声・画像生成を使ってマルチモーダルTelegram AIアシスタントを構築
Gemini、音声・画像生成を使ってマルチモーダルTelegramAIアシスタントを構築
If
Set
Code
+
If
Set
Code
95 ノードIniyavan JC
個人の生産性
Telegram、AIMLAPI、Google Sheetsを使用してマルチモデルAIチャットボットを作成
Telegram、AIMLAPI、Google スプレッドシートを使って多模型AIチャットボットを作成
If
Set
Code
+
If
Set
Code
25 ノードAI/ML API | D1m7asis
個人の生産性
Telegram 新規 Notion タスク
GPT-3.5を使ってTelegramメッセージからNotionタスクを作成
Code
Switch
Telegram
+
Code
Switch
Telegram
11 ノードJason Krol
個人の生産性
TelegramとGoogle Sheetsを使った費用記録：週次サマリーと予算アラート
TelegramとGoogle Sheetsによる費用記録：週次サマリーと予算アラート
Code
Telegram
Google Sheets
+
Code
Telegram
Google Sheets
15 ノードGtaras
個人の生産性
🍳 料理の相棒 — 30ステップワークフロー (Telegram + Google Sheets + LLM)
AI駆動のTelegramボットとGoogle Sheetsデータベースでレシピを管理する
Switch
Function
Telegram
+
Switch
Function
Telegram
41 ノードIssam AGGOUR
個人の生産性
ワークフロー情報
難易度
上級
ノード数31
カテゴリー1
ノードタイプ6
作成者
Fahmi Oktafian
@fahmi3322Hi! I’m Fahmi Oktafian, a developer and automation enthusiast with expertise in n8n, Node.js, and API integrations. I specialize in building smart, scalable workflows — from auto-publishing content to WordPress, sending automated Telegram notifications, to processing AI-based summaries and paraphrase. I’m passionate about helping businesses save time, increase efficiency, and automate their digital processes with clean and user-friendly solutions.
外部リンク
n8n.ioで表示 →
このワークフローを共有