{"product_id":"n8n-whatsapp-payment-reminder-automation-from-google-sheets","title":"n8n WhatsApp Payment Reminder Automation from Google Sheets","description":"\u003ch3\u003eNever miss a WhatsApp payment reminder—automate it from Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e payment rows every day and sends \u003cstrong\u003eWhatsApp Business Cloud API\u003c\/strong\u003e template reminders for upcoming, due, and overdue invoices. After each send attempt, it writes the outcome back to the same sheet so you always know what was (and wasn’t) delivered.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 09:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads all rows\u003c\/strong\u003e from the \u003ccode\u003epayments\u003c\/code\u003e sheet using the spreadsheet URL provided in workflow settings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips rows marked as paid\u003c\/strong\u003e, so only outstanding payments are considered.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates due dates and phone numbers\u003c\/strong\u003e to avoid failed sends and incorrect targeting.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetermines reminder timing\u003c\/strong\u003e based on configured day milestones:\n    \u003cul\u003e\n      \u003cli\u003eBefore the due date (upcoming reminder)\u003c\/li\u003e\n      \u003cli\u003eDue today (due reminder)\u003c\/li\u003e\n      \u003cli\u003eOverdue at specified intervals (overdue reminders)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends WhatsApp template messages\u003c\/strong\u003e via the WhatsApp Business Cloud API, using variables for \u003cstrong\u003ename\u003c\/strong\u003e, \u003cstrong\u003eamount\u003c\/strong\u003e, and \u003cstrong\u003edue date\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eOn success: writes \u003ccode\u003elast_reminder\u003c\/code\u003e and a sent note.\u003c\/li\u003e\n      \u003cli\u003eOn failure\/validation issues: writes an error or validation reason into \u003ccode\u003ereminder_note\u003c\/code\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS and services businesses who collect payments via invoices and want reliable customer follow-ups.\u003c\/li\u003e\n  \u003cli\u003eOperations teams tracking receivables in Google Sheets and needing automated WhatsApp reminders.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a repeatable n8n pattern for WhatsApp reminders driven by spreadsheet data.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth connection; reads the \u003ccode\u003epayments\u003c\/code\u003e tab; writes \u003ccode\u003elast_reminder\u003c\/code\u003e and \u003ccode\u003ereminder_note\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWhatsApp Business Cloud API (Meta)\u003c\/strong\u003e: sends approved templates (e.g., \u003ccode\u003epayment_reminder_before\u003c\/code\u003e, plus due\/overdue templates as configured).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n logic nodes\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, and supporting nodes including \u003cstrong\u003eWhatsApp\u003c\/strong\u003e plus workflow notes\/sticky notes for clarity.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eBring your WhatsApp payment reminder automation to life—connect your Google Sheets, approve your WhatsApp templates, and let n8n handle the follow-ups daily.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146444034227,"sku":"N8N-20214","price":70.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/VE0xs6svUWKObCDFCACQa_fqVb1BOb.png?v=1790846943","url":"https:\/\/buyflowscripts.com\/products\/n8n-whatsapp-payment-reminder-automation-from-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}