{"product_id":"n8n-late-payment-dunning-google-sheets-openai-gmail","title":"n8n Late Payment Dunning: Google Sheets + OpenAI + Gmail","description":"\u003ch3\u003eAutomate late-payment reminders from Google Sheets—powered by OpenAI and delivered via Gmail\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Late Payment Dunning: Google Sheets + OpenAI + Gmail\u003c\/strong\u003e workflow reads your open invoices and payment history from Google Sheets every weekday morning, scores late-payment risk, and sends the right reminder tone—friendly, firm, or a follow-up call escalation with Slack.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e Executes at \u003cstrong\u003e9 AM on weekdays\u003c\/strong\u003e using an n8n schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your dunning rules:\u003c\/strong\u003e Pulls dunning thresholds and business settings, then reads invoice + payment history data from your Google Sheets workbook (e.g., \u003cem\u003eInvoices\u003c\/em\u003e and \u003cem\u003ePayment History\u003c\/em\u003e tabs).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores each unpaid invoice:\u003c\/strong\u003e Calculates a per-client payment profile and assigns a \u003cstrong\u003e0–100 late-payment risk score\u003c\/strong\u003e for every open invoice.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects a dunning tone:\u003c\/strong\u003e Chooses a reminder type (friendly, firm, or call) and applies \u003cstrong\u003ecooldown rules\u003c\/strong\u003e so reminders don’t repeat too frequently or soften unintentionally.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts emails with OpenAI:\u003c\/strong\u003e Uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to generate a short pre-due\/gentle overdue email for friendly reminders, or a clear overdue notice for firm reminders.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends via Gmail:\u003c\/strong\u003e Dispatches the generated message using n8n’s \u003cstrong\u003eGmail\u003c\/strong\u003e integration.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates calls with Slack:\u003c\/strong\u003e For call items, appends a row to the Google Sheets \u003cem\u003e“Call Tasks”\u003c\/em\u003e tab and posts an escalation to \u003cstrong\u003eSlack #collections\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs outcomes back to Google Sheets:\u003c\/strong\u003e Updates each invoice row with the latest reminder stage, reminder date, and risk score for accurate follow-up tracking.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReduce DSO by sending consistent, risk-based dunning emails to customers with overdue invoices.\u003c\/li\u003e\n  \u003cli\u003eEscalate high-risk accounts from email to a call workflow with Slack notifications.\u003c\/li\u003e\n  \u003cli\u003eKeep your collections process auditable by writing every reminder stage back to Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n schedule trigger (weekday mornings at 9 AM)\u003c\/li\u003e\n  \u003cli\u003eNodes used: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46123241799859,"sku":"N8N-20087","price":66.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/MG3rxRlhZatkG1iysSEu9_4byiI4cS.png?v=1790673775","url":"https:\/\/buyflowscripts.com\/products\/n8n-late-payment-dunning-google-sheets-openai-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}