n8n’s Telegram Expense Template Turns Voice and Text Into Google Sheets Entries

说明与用途

n8n 模板通过 Telegram 将语音和文本消息转换为结构化的 Google Sheets 条目，实现快速记录支出，简化会计流程。

问题

Capturing expenses quickly and accurately at the point of purchase, avoiding delayed manual spreadsheet updates.

结果

The workflow enables users to send a single Telegram message (text or voice) describing one or more purchases, which AI parses into structured expense items that are automatically logged as individual rows in a Google Sheet, reducing manual entry friction.

工作流

• Create/authorize a Telegram bot connection in n8n
• Prepare a Google Sheet with headers (Date, Category, Merchant, Amount, Note)
• Connect Google and OpenAI credentials and select preferred AI models (e.g., GPT‑4o‑mini for parsing, Whisper for transcription)
• Map parsed fields to Google Sheet columns
• Test with text and voice messages
• Add brief waits to prevent race conditions
• Verify multi‑item messages create separate rows

证据

The workflow connects four functional stages: message capture, transcription when needed, AI-based extraction, and spreadsheet logging.

来源

The template’s sample run includes “Gas 34.67, Groceries 82.45, Coffee 6.25, Lunch 14.90,” showing that one message can be parsed into multiple expense items before each is logged separately.

来源