Daily Unpaid Invoice Digest Email from Google Sheets (n8n)

Get a daily plain-text email of your unpaid invoices from Google Sheets—automatically

This n8n workflow scans your Google Sheets invoices every day at 8:00 AM, builds a clean digest of all entries marked Status = "unpaid" (including totals and overdue status), and emails it to you via SMTP.

What this workflow does

• Scheduled run: Triggers daily at 8:00 AM.
• Reads invoice data from Google Sheets: Loads all rows from a specified spreadsheet and worksheet.
• Filters unpaid invoices: Selects only rows where Status is set to "unpaid".
• Computes totals and overdue status: Calculates the outstanding total amount and formats each invoice with its due/overdue indication based on the DueDate.
• Sends an email digest via SMTP: Delivers the digest (subject and body) to your configured recipient inbox.

Use cases

• Accounts receivable monitoring: Stay on top of overdue invoices without manually checking a sheet.
• Small business operations: Send yourself a daily reminder and quickly identify which clients need follow-up.
• SaaS finance workflows: Keep billing/collections teams aligned using a lightweight, spreadsheet-driven workflow.

Technical details

• Schedule Trigger: Runs every day at 8am.
• Google Sheets: Uses a service account to read invoice rows from your selected worksheet.
• Code processing: Filters unpaid invoices, calculates totals, and formats the digest into plain text.
• Email Send: Sends the digest through SMTP to the inbox you configure in the email step.

Setup checklist

• Connect Google Sheets service account and choose the spreadsheet + sheet.
• Ensure your columns include: InvoiceID, ClientName, Amount, DueDate, and Status (e.g., "unpaid").
• Add SMTP credentials and set the From/To addresses for the digest email.