Send weekly unpaid invoice summaries with Google Sheets and Gmail

Quick overview This workflow runs every Monday at 8:00 and reads your Invoices tab from Google Sheets, builds an HTML digest of unpaid and recently paid invoices (late, due soon, paused, and broken rows), and emails the weekly summary to you via Gmail.

How it works Runs on a cron schedule every Monday at 08:00. Loads your configuration values (Google Sheet URL, recipient email, timezone, and currency/date defaults). Reads all rows from the Invoices sheet in Google Sheets. Categorizes invoices by status and dates to calculate totals per currency and group items as late, due in the next 7 days, paused, recently paid, or unreadable/missing data. Generates a formatted HTML email with sectioned tables and a subject line based on how many invoices are late and marked for follow-up. Sends the digest email to your address using Gmail.

Setup Create or update a Google Sheet with a tab named Invoices and the expected columns (InvoiceID, Client, ClientEmail, Amount, Currency, DueDate, Status, PaidDate; optional: LastStage and Notes). Add a Google Sheets credential and paste your spreadsheet URL into the sheetUrl setting. Add a Gmail credential and set yourEmail (and adjust timezone, defaultCurrency, and dateOrder as needed) before activating the workflow.

0
Downloads
0
Views
8.18
Quality Score
beginner
Complexity
Author:Hieu Nguyen(View Original →)
Created:11/18/2026
Updated:11/18/2026

🔒 Please log in to import templates to n8n and favorite templates

Workflow Visualization

Loading...

Preparing workflow renderer

Comments (0)

Login to post comments