WhatsApp AI Receipt Tracker: Automate Expenses with n8n

Transform your WhatsApp into a powerful AI-driven expense tracking system that automatically extracts receipt data and logs it to Google Sheets. This n8n workflow eliminates manual data entry by processing receipt photos and text messages through advanced AI, perfect for business owners and freelancers managing expenses on the go.

What this workflow does

This intelligent automation workflow creates a seamless expense tracking pipeline through WhatsApp integration. When you send a receipt photo via WhatsApp, the workflow automatically downloads the image, uploads it to Google Drive, and sends it to OpenRouter's GPT-4o-mini for AI-powered data extraction. For text messages, the content goes directly to the AI extractor. The system intelligently extracts vendor names, amounts, expense categories, and dates, then checks your Google Sheets for duplicates before appending the new expense row and sending a confirmation reply through WhatsApp.

Use cases

• Small business owners tracking daily expenses by simply photographing receipts and sending to WhatsApp
• Freelancers managing project expenses across multiple clients with automated categorization
• Field teams submitting expense reports in real-time without complex mobile apps
• Entrepreneurs maintaining accurate financial records for tax preparation and accounting
• Remote workers streamlining reimbursement processes through instant receipt processing

Technical details

Built with essential n8n nodes including webhook triggers, conditional logic (if nodes), custom code processing, WhatsApp Cloud API integration, and Google Drive connectivity. The workflow requires a WhatsApp Cloud API token from Facebook Developer App, OpenRouter API key for AI processing, and Google Sheets access. Setup involves creating a dedicated "WhatsApp Finance Log" spreadsheet with specific columns for Date, Vendor, Amount, Category, Notes, MediaURL, and MessageID.

The workflow includes built-in duplicate detection, customizable AI extraction prompts, and dry-run testing capabilities. Perfect for n8n users seeking practical automation solutions that combine modern AI capabilities with everyday business communication tools.