WhatsApp Financial Assistant

Effortless Money Management—Directly Within WhatsApp

Overview
Say goodbye to spreadsheets and manual data entry. With the WhatsApp Financial Assistant, tracking expenses, logging income, and generating reports is as easy as sending a message in WhatsApp. Our automated n8n workflow, powered by LangChain and AI models via OpenRouter or OpenAI, interprets your text, stores transactions in PostgreSQL, and returns insights instantly.

Key Features

• Instant Transaction Logging

• Simply message your expense or income details in natural language.
• Example: Spent 250 on groceries @ Freshmart
  → Logged: 2025‑05‑12 | Expense | Groceries | ₹250.00 | Freshmart

• Automatic Date Handling

• If you don’t include a date, the system uses the current date by default.
• Mention explicit dates (e.g., on June 5), and the AI parser recognizes them.

• On-Demand Financial Reports

• Request daily, weekly, monthly, or custom-range summaries with simple commands.
• Example: today’s report
  → Income: ₹0.00 • Expenses: ₹250.00 • Savings: –₹250.00

• Period-to-Period Comparison

• Compare two time periods side by side, with percentage changes.
• Example: april vs may report
  → Income: April ₹3,000 vs May ₹5,500 ▲ 83%
  → Expenses: April ₹1,200 vs May ₹625 ▼ 48%

• AI-Driven Categorization & Insights

• Structured Output Parser extracts date, type, category, amount, and person.
• AI suggestions identify spending trends and saving opportunities.

How It Works

1. Chat: Send your message to the WhatsApp Business Cloud number.
2. Trigger: n8n’s WhatsApp Trigger node forwards text into the workflow.
3. Parse:
   • Tool Nodes format your text for PostgreSQL insertion.
   • LM Nodes (OpenRouter/OpenAI) translate natural language into structured JSON.
   • Structured Parser outputs fields: date, type, category, amount, person.
4. Store: PostgreSQL node inserts the record into transactions, defaulting transaction_date to CURRENT_DATE if not provided.
5. Respond: Confirmation, reports, and insights are sent back via WhatsApp API.

Setup Guide

1. Import n8n Workflow
   • Load the provided JSON file into your n8n instance.
2. Configure Credentials
   • WhatsApp Business Cloud: App ID, App Secret, Access Token in n8n’s credentials.
   • OpenRouter/OpenAI: Add your API key in the LLM credential node.
   • PostgreSQL: Provide your connection string (host, port, database, user, password).
3. Create & Link Database Table

   CREATE TABLE IF NOT EXISTS transactions (
     transaction_date DATE  DEFAULT CURRENT_DATE,
     category TEXT  NOT NULL,
     type TEXT  NOT NULL CHECK (type IN('Income','Expense')),
     amount NUMERIC(12,2) NOT NULL CHECK (amount >= 0),
     person TEXT
   );
   

   • Add these DB credentials to n8n’s PostgreSQL nodes.
4. Configure WhatsApp Nodes
   • Update Send Financial Response, Send Daily Report, and Send Custom Report nodes with your phone number and API credentials.
5. Activate & Test
   • Activate the workflow.
   • Send sample transactions and report requests on WhatsApp.
   • Confirm data logging, date stamping, and accurate report outputs.

Demo & Support
🔗 Watch the LinkedIn Demo Video

Have questions or need custom enhancements? Reach out to Roshan Ramani, creator of WhatsApp Financial Assistant.

Start messaging today—your finances, simplified!