Expense Logging with Telegram to Google Sheets using AI Voice & Text Parsing
Ready for 3.0What this workflow does
This AI workflow has 16 nodes and runs on Telegram events (message). Along the way it connects OpenAI Chat Model, Google Sheets, Telegram and OpenAI.
How it runs
Trigger: On Telegram events (message).
- Check if Audio file (If): checks a condition and branches into true / false
- Get File (Telegram): work with file
- Set field (Edit Fields (Set)): sets 1 field: text
- Transcribe audio (OpenAI): transcribe (audio)
- Parse Expenses with AI (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Split Out: splits a list into separate items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Build Expense Summary Text (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
- Append to Google Sheet (Google Sheets): append
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (14)
- OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait - Telegram
n8n-nodes-base.telegram - Split Out
n8n-nodes-base.splitOut - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Telegram Trigger
n8n-nodes-base.telegramTrigger - If
n8n-nodes-base.if - OpenAI
@n8n/n8n-nodes-langchain.openAi - Edit Fields (Set)
n8n-nodes-base.set - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code
From the author
Use Cases -Personal or family budget tracking. -Small business expense logging via Telegram -Hands-free logging (using voice messages) --- How it works: -Trigger receives text or voice. -Optional branch transcribes audio to text. -AI parses into a structured…