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.
Related Templates
Subscribe to new releases of a Github repository via Gmail
This is a very simple workflow that lets you subscribe to any github repository for the latest release (using n8n as ex...
Generate Food Recipes from Gmail & Form Requests with Ollama & Llama 3.2
This n8n template demonstrates how to create an intelligent food recipe assistant that accepts requests via Gmail and we...
Generate Product Ad Copy & CTAs with GPT-4 for Slack and Airtable
⚡ AI Copywriter Pro: Instant Ad Copy & CTA Generator Transform product details into compelling marketing copy in second...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments