About

Project Overview I need an experienced automation engineer to build a complete, production-ready WhatsApp expense logging system from scratch. The goal is to allow employees to send expense messages through WhatsApp, have those messages parsed with AI, stored in a database, and confirmed back to the sender automatically. This system must support multiple separate client accounts using a single workflow. Tech stack: n8n Cloud – workflow engine WhatsApp Business Cloud API – inbound and outbound communication Supabase – database and authentication Lovable.dev – frontend UI for client settings and management OpenAI – structured AI parsing What You Will Build End-to-End 1. WhatsApp to n8n inbound messaging Configure WhatsApp Cloud API Implement webhook validation Receive employee messages containing expenses Extract: phone number in E164 format message text sender name timestamps 2. Multi-tenant account identification One workflow must support dozens of different client accounts. You will build logic to: Match incoming phone number to a client account via Supabase If number is not assigned, send automated "not linked" reply Prevent data mixing between different accounts 3. AI expense parsing with OpenAI Create an AI step that reads messages such as: 84.23 Chevron gas Paid rent 3500 for April Payroll 14,500 this week AI should output consistently structured JSON-like fields, including: amount as numeric category vendor notes type expense or income currency date in ISO style confidence score The AI must output clean data only, no markdown or text outside the fields. If amount or category is missing, the system must automatically send a WhatsApp message asking the user for clarification. 4. Supabase write operations Create the necessary tables: account_phone_numbers expenses pending_expenses Write records into Supabase including: account_id phone number timestamp date amount category vendor notes raw_message source as "whatsapp" 5. Automatic WhatsApp replies Build all WhatsApp outbound messaging steps: Expense logged confirmation Requests for missing details Monthly totals Error messages 6. Monthly totals logic Query Supabase for monthly totals per account and reply to the user with the running total. 7. Optional frontend integration in Lovable.dev Build a simple settings page where clients can: Assign phone numbers View expense history Manage WhatsApp connection Configure categories (Not required but a big bonus.) Deliverables Fully functioning automation running on my n8n Cloud account WhatsApp Cloud API integrated and tested AI parsing logic implemented Supabase inserts and queries working Automated reply messages functional Documentation for: Adding new client accounts Connecting phone numbers System overview Optional: Frontend UI components in Lovable.dev Requirements Must have experience with: n8n at an advanced level WhatsApp Business Cloud API Supabase including service role operations OpenAI for structured extraction Multi-tenant automation design Webhook-driven systems Experience with Lovable.dev Background in expense or accounting workflows To Apply Send: Examples of similar automation work you’ve done WhatsApp API or Twilio WhatsApp projects Your Supabase experience Your hourly or project rate When you can start