Back to Templates
This workflow turns WhatsApp messages into structured financial entries and logs them into a PostgreSQL database (or Google Sheets). It generates on-demand/scheduled summaries and sends them via WhatsApp, eliminating dashboards/spreadsheets.
date
| category
| type
| amount
| person
+1234567890
with your number)n8n_finances
financial_transactions
(schema below)Column | Type | Description |
---|---|---|
date | DATE | Transaction date (YYYY-MM-DD) |
category | TEXT | E.g., "Groceries" |
type | TEXT | "Income", "Expense", or "Debt" |
amount | NUMERIC(12,2) | Amount (e.g., 250.50) |
person | TEXT | Optional (e.g., "Employer") |
SQL Commands:
CREATE DATABASE n8n_finances;
CREATE USER n8n_user WITH PASSWORD 'your_password';
GRANT ALL PRIVILEGES ON DATABASE n8n_finances TO n8n_user;
CREATE TABLE financial_transactions (
date DATE NOT NULL,
category TEXT NOT NULL,
type TEXT NOT NULL,
amount NUMERIC(12,2) NOT NULL,
person TEXT
);
localhost
5432
n8n_finances
n8n_user
your_password
Ensure financial_transactions
table exists.
Send WhatsApp Message:
Spent 300 on Uber rides @ Uber
Workflow Output:
Uber rides
Expense
300
Uber
Confirmation:
✅ Logged: expense | Uber rides | ₹300.00 | Uber
today's report
March vs April report
Yesterday’s Total: Income ₹0 | Expenses ₹300 | Savings -₹300
Paid 1500 for Netflix @ March billing
Spent 500 on dinner @ Restaurant
Received 20000 salary @ Company
today's report
or Q1 vs Q2 report