{"product_id":"daily-unpaid-invoice-digest-email-from-google-sheets-n8n","title":"Daily Unpaid Invoice Digest Email from Google Sheets (n8n)","description":"\u003ch3\u003eGet a daily plain-text email of your unpaid invoices from Google Sheets—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your Google Sheets invoices every day at \u003cstrong\u003e8:00 AM\u003c\/strong\u003e, builds a clean digest of all entries marked \u003cstrong\u003eStatus = \"unpaid\"\u003c\/strong\u003e (including totals and overdue status), and emails it to you via \u003cstrong\u003eSMTP\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled run:\u003c\/strong\u003e Triggers daily at \u003cstrong\u003e8:00 AM\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads invoice data from Google Sheets:\u003c\/strong\u003e Loads all rows from a specified spreadsheet and worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters unpaid invoices:\u003c\/strong\u003e Selects only rows where \u003cstrong\u003eStatus\u003c\/strong\u003e is set to \u003cstrong\u003e\"unpaid\"\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes totals and overdue status:\u003c\/strong\u003e Calculates the outstanding total amount and formats each invoice with its due\/overdue indication based on the \u003cstrong\u003eDueDate\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an email digest via SMTP:\u003c\/strong\u003e Delivers the digest (subject and body) to your configured recipient inbox.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAccounts receivable monitoring:\u003c\/strong\u003e Stay on top of overdue invoices without manually checking a sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSmall business operations:\u003c\/strong\u003e Send yourself a daily reminder and quickly identify which clients need follow-up.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS finance workflows:\u003c\/strong\u003e Keep billing\/collections teams aligned using a lightweight, spreadsheet-driven workflow.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger:\u003c\/strong\u003e Runs every day at \u003cstrong\u003e8am\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e Uses a service account to read invoice rows from your selected worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode processing:\u003c\/strong\u003e Filters unpaid invoices, calculates totals, and formats the digest into plain text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail Send:\u003c\/strong\u003e Sends the digest through \u003cstrong\u003eSMTP\u003c\/strong\u003e to the inbox you configure in the email step.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup checklist\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eConnect Google Sheets service account and choose the spreadsheet + sheet.\u003c\/li\u003e\n  \u003cli\u003eEnsure your columns include: \u003cstrong\u003eInvoiceID\u003c\/strong\u003e, \u003cstrong\u003eClientName\u003c\/strong\u003e, \u003cstrong\u003eAmount\u003c\/strong\u003e, \u003cstrong\u003eDueDate\u003c\/strong\u003e, and \u003cstrong\u003eStatus\u003c\/strong\u003e (e.g., \u003cstrong\u003e\"unpaid\"\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003eAdd SMTP credentials and set the \u003cstrong\u003eFrom\u003c\/strong\u003e\/\u003cstrong\u003eTo\u003c\/strong\u003e addresses for the digest email.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46067913949363,"sku":"N8N-19785","price":11.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Lpx-XjyfGZswVKLiIsOQ__4iexVvgw.png?v=1789981340","url":"https:\/\/buyflowscripts.com\/products\/daily-unpaid-invoice-digest-email-from-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}