WhatsApp Expense Tracker with PostgreSQL Database & AI-Powered Reports
    100%
    Automation
    0(0 reviews)
    293 downloads

    WhatsApp Expense Tracker with PostgreSQL Database & AI-Powered Reports

    NM

    Curated by n8n Markets team

    Last updated: March 8, 2026

    # Track Personal Finances with WhatsApp and AI Assistant Transform your WhatsApp into a powerful personal finance command center. This AI-powered workflow converts natural language messages into structured financial data, automates record-keeping, and delivers instant insights—all within your favorite messaging app. ## Who is this for? This template is perfect for: - Personal finance enthusiasts who want effortless expense tracking - Small business owners managing personal and business expenses - Freelancers tracking income and expenses across projects - Anyone who prefers messaging over complex finance apps - Users seeking privacy with self-hosted financial data ## What problem is this workflow solving? Traditional expense tracking requires switching between apps, manual data entry, and complex spreadsheets. Most people abandon these systems within weeks. This workflow solves the friction by: - Eliminating app-switching—everything happens in WhatsApp - Converting natural language to structured data automatically - Providing instant confirmations and reports - Requiring zero learning curve or behavior change ## What this workflow does ### Smart Transaction Processing Send natural messages like `Spent 300 on groceries at Walmart` and the AI automatically extracts: - Date: Today's date (or specified date) - Category: Groceries - Type: Expense/Income/Debt - Amount: 300 - Person/Company: Walmart ### Intelligent Message Classification The workflow automatically routes messages to three processing branches: - Branch 1: Reports and analytics (`show March expenses`) - Branch 2: Transaction logging (`spent 50 on coffee`) - Branch 3: General financial chat (`how can I save money?`) ### Advanced Reporting Generate instant reports by messaging: - `today's report` → Daily income/expense summary - `March vs April report` → Monthly comparisons with percentages - `show groceries spending` → Category-specific analysis - Automatic daily summaries at your preferred time ### Database Integration All transactions are stored in PostgreSQL with proper schema: ```sql CREATE TABLE financial_transactions ( date DATE NOT NULL, category TEXT NOT NULL, type TEXT NOT NULL, amount NUMERIC(12,2) NOT NULL, person TEXT ); ``` ## Setup ## Prerequisites - n8n instance (self-hosted or n8n.cloud) - WhatsApp Business Cloud API credentials - PostgreSQL database (version 12+) - OpenRouter API key for AI processing ## Quick Setup Steps 1. Import the workflow template into your n8n instance 2. Configure credentials: - WhatsApp Business Cloud API (App Token + Phone Number ID) - PostgreSQL connection details - OpenRouter API key for AI processing 3. Create database table using the provided SQL schema 4. Test the connection by sending a sample message 5. Customize the scheduled report timing (default: 8 AM daily) ## Verification Checklist - [ ] WhatsApp webhook receives messages - [ ] AI correctly parses transaction messages - [ ] Database insertions work properly - [ ] Confirmation messages are sent back - [ ] Reports generate with accurate data # How to customize this workflow to your needs ## AI Model Configuration - Default: Uses OpenRouter with GPT-3.5-turbo for cost efficiency - Upgrade: Switch to GPT-4 or Claude for better accuracy - Local: Replace with self-hosted Ollama for complete privacy ## Database Options - PostgreSQL: Recommended for production use - Google Sheets: Alternative for simpler setups (nodes included) - MySQL/SQLite: Easily adaptable with minor SQL modifications ## Message Classification Customize the classification system: - 0: Reports (modify SQL queries for different analytics) - 1: Transactions (adjust parsing rules for your language/currency) - 2: Chat (customize AI responses for financial advice) ## Reporting Customization - Scheduled reports: Change timing, format, and recipients - Custom periods: Add quarterly, yearly, or custom date ranges - Categories: Modify auto-categorization rules for your spending patterns - Currency: Update formatting for your local currency ## Advanced Features - Multi-user support: Add user identification for family/team use - Receipt photos: Extend workflow to process image receipts via OCR - Budgets: Add budget tracking and overspend alerts - Integrations: Connect to banks via Plaid or other financial APIs # Complete Package Included When you download this template, you get everything needed for immediate implementation: ## Ready-to-Use n8n Workflow - Fully configured nodes with descriptive names explaining each step - Color-coded sticky notes throughout the workflow explaining: - What each branch does (Reports/Transactions/Chat) - How the AI classification works - Database connection requirements - Error handling and troubleshooting tips ## Comprehensive Documentation Bundle - Quick Start Guide: Get running in under 10 minutes - Detailed Setup Guide: Complete configuration walkthrough with screenshots - Branch Explanation Guide: Deep

    What's Included

    • Complete n8n workflow template with 0 nodes. Ready to import and customize.

    Requirements

    n8n instance (self-hosted or cloud). credentials.

    How to Use

    1. Download the workflow JSON 2. Import into your n8n instance 3. Configure credentials for 4. Activate and enjoy automation

    Apps in this n8n workflow

    How to import this template into n8n

    1. Download the workflow JSON file from this page.
    2. In n8n, open Workflows, create a new workflow and choose Import from File.
    3. Open each node that shows a warning and connect your own credentials.
    4. Run the workflow once manually to check the output before you activate it.
    Included in Pro
    • Importable n8n workflow JSON file
    • Download with Builder Pro or Agency Unlimited
    • Built for n8n v1.0++
    • Setup time: 5-15 min

    Included in Builder Pro — $19/mo, 4,177 premium workflows

    Before you activate

    Templates are reviewed before they are listed. Test with your own credentials and data before running it in production.

    Updated Mar 2026
    v1.0
    SSL
    Secure
    GDPR

    100% Secure Checkout

    Refund requests within 7 days of a new subscription

    Dependencies & Requirements

    PostgreSQL
    Database

    ⚠️ 1 service require credentials. Make sure you have accounts set up before importing.

    Reviews

    0

    No reviews yet

    See all 0 reviews ↓
    —

    0 reviews

    5★
    0
    4★
    0
    3★
    0
    2★
    0
    1★
    0

    No reviews yet.

    Questions & Answers

    0

    Log in to ask a question.

    No questions yet. Be the first to ask!

    People Also Bought