Scan WhatsApp receipt photos and track expenses using Wati and GPT-4o
UnknownWhat this workflow does
This workflow has 11 nodes and runs on Wati events (message received). Along the way it connects Google Sheets and Wati (community). It also calls api.openai.com over HTTP.
How it runs
Trigger: On Wati events (message received).
- Route Message (Switch): routes items into 2 branches
- Get a media file (Wati): get media
- Google Sheets: uses Google Sheets
- Prepare Image for OpenAI (Code): runs custom JavaScript code
- Build Monthly Report (Code): runs custom JavaScript code
- OpenAI – Extract Receipt Data (HTTP Request): calls api.openai.com (POST)
- Send Expenditure Report - month (Wati): uses Wati
- Parse & Validate Expense (Code): runs custom JavaScript code
- Google Sheets: append
- Send Expenditure message (Wati): uses Wati
Services it uses
HTTP calls to: api.openai.com
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 2 community packages, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-wati is verified or supports 3.0 (used in Wati Trigger).
- Check that n8n-nodes-wati is verified or supports 3.0 (used in Get a media file1, Send Expenditure message, Send Expenditure Report - month).
Nodes used (6)
- Switch
n8n-nodes-base.switch - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Wati Trigger
n8n-nodes-wati.watiTrigger - Wati
n8n-nodes-wati.wati
From the author
Transform messy receipt photos into a structured, searchable expense database in seconds. This workflow automates the entire journey from a WhatsApp message to a live Google Sheets entry by combining WATI for communication, OpenAI Vision for extraction, and…