{"product_id":"whatsapp-bill-splitter-n8n-workflow-waha-gemini-sheets","title":"WhatsApp Bill Splitter n8n Workflow: WAHA + Gemini + Sheets","description":"\u003ch3\u003eSplit WhatsApp bills automatically—receipt OCR, calculated shares, and playful reminders in one n8n workflow\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eWhatsApp Bill Splitter n8n Workflow\u003c\/strong\u003e uses \u003cstrong\u003eWAHA\u003c\/strong\u003e to run a WhatsApp bill-splitting bot, \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to extract receipt totals via OCR, \u003cstrong\u003eOpenRouter\u003c\/strong\u003e to generate humorous bill and reminder messages, and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e to track sessions, contacts, bills, and payment status—plus daily reminders at \u003cstrong\u003e7 PM\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives group instructions via WhatsApp\u003c\/strong\u003e using a WAHA webhook, and \u003cstrong\u003eignores messages\u003c\/strong\u003e from numbers not on a `whitelist`.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses receipt images\u003c\/strong\u003e: when a message includes receipt media, the workflow downloads the image via WAHA and uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to extract items\/tax\/total.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects item assignments\u003c\/strong\u003e: it asks the group to reply in the format \u003cem\u003e“Name: item1, item2”\u003c\/em\u003e, then stores the OCR session result in a \u003cstrong\u003eGoogle Sheets Session\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates proportional shares\u003c\/strong\u003e when a follow-up assignment arrives: it loads the latest OCR session and contacts from Google Sheets, matches item keywords to receipt items, and computes each person’s portion including \u003cstrong\u003eproportional tax\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends personalized bills\u003c\/strong\u003e: for each participant, it uses \u003cstrong\u003eOpenRouter\u003c\/strong\u003e to generate a short humorous bill message and sends it via WAHA, logging unpaid entries in the \u003cstrong\u003eGoogle Sheets Bills\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMarks payments as done\u003c\/strong\u003e when a message contains payment confirmation (e.g., “paid”\/“done”), updating the newest matching unpaid bill by WhatsApp number (or name fallback).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomates daily reminders\u003c\/strong\u003e at \u003cstrong\u003e7 PM\u003c\/strong\u003e: pulls unpaid bills from Google Sheets, applies a same-day anti-spam guard, generates the reminder tone (gentle\/firm\/savage) with OpenRouter, sends via WAHA, and updates the reminder tracking field (\u003ccode\u003elastR...\u003c\/code\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFriends splitting restaurant bills in a WhatsApp group—receipt photo in, balances out.\u003c\/li\u003e\n  \u003cli\u003eEvent teams tracking expenses without spreadsheets—assign items by name and get instant bill requests.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying a production-ready WhatsApp bot with OCR, messaging, and Sheets-based state.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: WAHA (WhatsApp webhook + media download + send), \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e (receipt OCR extraction), \u003cstrong\u003eOpenRouter\u003c\/strong\u003e (humorous bills + reminders), \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (Sessions, Contacts, Bills, status updates).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic\u003c\/strong\u003e: if, set, code, merge, plus date-based scheduling for the 7 PM reminder run.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192876880051,"sku":"N8N-20449","price":12.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/TYupQlh57beNJGX1mghRB_oHOPDxfJ.png?v=1791538061","url":"https:\/\/buyflowscripts.com\/products\/whatsapp-bill-splitter-n8n-workflow-waha-gemini-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}