{"product_id":"n8n-whatsapp-invoice-reminder-workflow-google-sheets","title":"n8n WhatsApp Invoice Reminder Workflow (Google Sheets)","description":"\u003ch3\u003eGet WhatsApp invoice reminders sent on schedule—automatically from your Google Sheets\u003c\/h3\u003e\n\u003cp\u003eStop letting overdue invoices slip. This \u003cstrong\u003en8n WhatsApp Invoice Reminder Workflow (Google Sheets)\u003c\/strong\u003e automatically reads your open invoices, calculates how many days they’re overdue, and sends the right \u003cstrong\u003eHebrew WhatsApp reminder\u003c\/strong\u003e at \u003cstrong\u003e7, 14, and 30 days\u003c\/strong\u003e—with friendly-to-firmer messaging and full logging back to your sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily\u003c\/strong\u003e: A \u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e fires every morning at \u003cstrong\u003e09:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads open invoices\u003c\/strong\u003e: The workflow reads rows from your Google Sheet tab \u003cstrong\u003eInvoices\u003c\/strong\u003e where \u003cstrong\u003eStatus = open\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates overdue days\u003c\/strong\u003e: A \u003cstrong\u003eCode\u003c\/strong\u003e node computes days overdue and selects the reminder tier for \u003cstrong\u003eexactly 7, 14, or 30 days\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicate tier sends\u003c\/strong\u003e: It ensures a customer is \u003cstrong\u003enever messaged twice for the same tier\u003c\/strong\u003e using \u003cstrong\u003eLastReminder\u003c\/strong\u003e \/ \u003cstrong\u003eLastReminderDate\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends via WhatsApp\u003c\/strong\u003e: The reminder is sent through your \u003cstrong\u003eWAHA server\u003c\/strong\u003e, with throttling to stay WhatsApp-friendly.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs sends back to Google Sheets\u003c\/strong\u003e: Each message is recorded with the tier and date so your invoice tracking stays accurate.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eYou manage invoices in Google Sheets and want consistent follow-ups without manually chasing customers.\u003c\/li\u003e\n  \u003cli\u003eYou run a small business and need polite reminders early (7 days), firmer follow-up (14 days), and a final notice (30 days).\u003c\/li\u003e\n  \u003cli\u003eYou operate SaaS or manage ops and want a reliable \u003cstrong\u003en8n automation workflow\u003c\/strong\u003e that works with your existing sheet-based process.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ components\u003c\/strong\u003e: \u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eCode\u003c\/strong\u003e, \u003cstrong\u003eHTTP request\u003c\/strong\u003e, and a \u003cstrong\u003eSticky Note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired sheet tab\/columns\u003c\/strong\u003e: Tab name \u003cem\u003eInvoices\u003c\/em\u003e with \u003cstrong\u003eInvoiceID | CustomerName | Phone | Amount | DueDate | Status | LastReminder | LastReminderDate\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWhatsApp integration\u003c\/strong\u003e: Send through \u003cstrong\u003eWAHA\u003c\/strong\u003e using your \u003cstrong\u003eHTTP node\u003c\/strong\u003e (update \u003cem\u003eYOUR-WAHA-SERVER\u003c\/em\u003e) and \u003cstrong\u003eHeader Auth\u003c\/strong\u003e with \u003cstrong\u003eX-Api-Key\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCustomization\u003c\/strong\u003e: Update the three Hebrew reminder messages (and optionally the 7\/14\/30-day tiers) inside the \u003cstrong\u003eCode\u003c\/strong\u003e node.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cem\u003eBuilt by Achiya Automation (https:\/\/achiya-automation.com).\u003c\/em\u003e\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45837469909171,"sku":"N8N-18198","price":37.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/qChuQwDNOpeHBXGwaoV6h_Cm8YuZNc.png?v=1786794816","url":"https:\/\/buyflowscripts.com\/products\/n8n-whatsapp-invoice-reminder-workflow-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}