{"product_id":"n8n-workflow-google-sheets-invoice-reminder-emails-via-gmail","title":"n8n Workflow: Google Sheets Invoice Reminder Emails via Gmail","description":"\u003ch3\u003eAutomate overdue invoice reminders with n8n + Google Sheets + Gmail\u003c\/h3\u003e\n\u003cp\u003eStop manually chasing payments. This \u003cstrong\u003en8n Workflow\u003c\/strong\u003e automatically checks your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e invoices every weekday at \u003cstrong\u003e09:00\u003c\/strong\u003e and sends \u003cstrong\u003epayment reminder emails via Gmail\u003c\/strong\u003e at \u003cstrong\u003e3, 7, and 14 days past due\u003c\/strong\u003e, updating your invoice records and writing an audit trail to a \u003cstrong\u003eLog\u003c\/strong\u003e tab.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules reminders\u003c\/strong\u003e: Runs every weekday at \u003cstrong\u003e09:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads invoice data\u003c\/strong\u003e: Loads reminder settings (cadence days, minimum gap between reminders, and a per-run safety cap) and scans the \u003cstrong\u003eInvoices\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects the right invoices\u003c\/strong\u003e: Targets invoices that are overdue by the next configured reminder day, \u003cstrong\u003eskips\u003c\/strong\u003e closed\/paid statuses, validates required fields (like \u003cstrong\u003ecustomer email\u003c\/strong\u003e, \u003cstrong\u003eamount\u003c\/strong\u003e, and \u003cstrong\u003edue date\u003c\/strong\u003e), and avoids reminding customers too frequently.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends staged Gmail emails\u003c\/strong\u003e: Builds a personalized email subject and body (optionally including a \u003cstrong\u003epayment link\u003c\/strong\u003e) and sends the reminder through \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates tracking fields\u003c\/strong\u003e: Writes back \u003cstrong\u003estatus\u003c\/strong\u003e, \u003cstrong\u003eattempts\u003c\/strong\u003e, \u003cstrong\u003elast reminder date\u003c\/strong\u003e, and computed \u003cstrong\u003enext reminder date\u003c\/strong\u003e to the matching row.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates an audit log\u003c\/strong\u003e: Appends a row to the \u003cstrong\u003eLog\u003c\/strong\u003e tab for each successfully sent reminder.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators sending automated payment nudges for overdue invoices stored in Google Sheets\u003c\/li\u003e\n  \u003cli\u003eOperations teams reducing late payments without building a full billing system\u003c\/li\u003e\n  \u003cli\u003en8n users who need clear invoice status updates and email send auditing\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: Google Sheets (read, update, and log) and \u003cstrong\u003eGmail\u003c\/strong\u003e (send reminders)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used\u003c\/strong\u003e: \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003eno op\u003c\/em\u003e, \u003cem\u003egmail\u003c\/em\u003e, \u003cem\u003efilter\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExpected sheet tabs\/fields\u003c\/strong\u003e: An \u003cstrong\u003eInvoices\u003c\/strong\u003e tab with columns including \u003cem\u003einvoice_id\u003c\/em\u003e, \u003cem\u003ecustomer_email\u003c\/em\u003e, \u003cem\u003ecustomer_name\u003c\/em\u003e, \u003cem\u003eamount\u003c\/em\u003e, \u003cem\u003ecurrency\u003c\/em\u003e, \u003cem\u003edue_date\u003c\/em\u003e, \u003cem\u003estatus\u003c\/em\u003e, \u003cem\u003eattempts\u003c\/em\u003e, \u003cem\u003elast_reminder_at\u003c\/em\u003e, \u003cem\u003enext_reminder_at\u003c\/em\u003e, plus relevant settings\/logging fields, and a \u003cstrong\u003eLog\u003c\/strong\u003e tab for audit entries\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46288989356211,"sku":"N8N-21692","price":54.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/W_TA1VKtu8qIApTi2TTUk_WBGQrXS3.png?v=1793005626","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-invoice-reminder-emails-via-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}