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

Description and use

The n8n template enables quick expense capture via Telegram, converting voice and text messages into structured Google Sheets entries, simplifying accounting.

Problem

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

Outcome

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.

Workflow

• 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

Evidence

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

Source

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.

Source