Track employee expense receipts from Telegram with GPT-4o-mini and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 34 nodes and runs on Telegram events (message) (plus 1 other trigger). Along the way it connects Telegram, OpenAI, Google Sheets and Gmail.
How it runs
Trigger: On Telegram events (message) (plus 1 other trigger).
- Check for Receipt Photo (If): checks a condition and branches into true / false
- Gather Expenses for Report (Google Sheets): uses Google Sheets
- Prepare Submission Data (Edit Fields (Set)): sets 9 fields: chat_id, message_id, user_id…
- Request Receipt Photo (Telegram): uses Telegram
- Filter: keeps only the items that match a condition
- AI Analyze Receipt Photo (OpenAI): analyze (image)
- Create Monthly Expense Report (Code): runs custom JavaScript code
- Extract Expense Details (Code): runs custom JavaScript code
- Record AI Error State (Edit Fields (Set)): sets 3 fields: chat_id, message_id, error_message
- Send Monthly Report via Email (Gmail): uses Gmail
…plus 21 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 (13)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Telegram
n8n-nodes-base.telegram - OpenAI
@n8n/n8n-nodes-langchain.openAi - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Switch
n8n-nodes-base.switch - No Operation, do nothing
n8n-nodes-base.noOp - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Filter
n8n-nodes-base.filter - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow collects receipt photos via Telegram, uses OpenAI GPT-4o-mini Vision to extract expense details, checks them against a Google Sheets policy and existing claims, routes items for auto-approval or manager approval in Telegram,…