Track expenses from phone notifications with Google Gemini and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 11 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and Google Gemini Chat Model.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Extract Amount (Code): runs custom JavaScript code
- Is Expense? (If): checks a condition and branches into true / false
- Categorize Expense (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model; output parser: Structured Output Parser
- Respond Skipped (Respond to Webhook): sends the response back to the webhook caller
- Google Sheets: append
- Respond Error LLM (Respond to Webhook): sends the response back to the webhook caller
- Respond Success (Respond to Webhook): sends the response back to the webhook caller
- Respond Error Sheets (Respond to Webhook): sends the response back to the webhook caller
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 (8)
- Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook - Google Sheets
n8n-nodes-base.googleSheets - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - If
n8n-nodes-base.if - Code
n8n-nodes-base.code
From the author
Quick overview This workflow receives phone push notification through FlowTrigger mobile app, extracts the transaction amount and date, uses Google Gemini to categorize the expense and adds it to a Google Sheets transactions log. How it works 1. Receives a…