See llms.txt for all machine-readable content.

Back to Templates

Send daily invoice due reminders with Google Sheets and email

Created by

Created by: Notoriousbrick || notoriousbrick
Notoriousbrick

Last update

Last update 6 hours ago

Categories

Quick overview

Built for Italian freelancers and small businesses who track invoices in Google Sheets. Every morning it reads the Fatture tab, skips paid invoices and emails a summary of the ones due today or within N days, plus a "to check" section for rows with a missing or invalid date.

How it works

  1. Runs every day at 08:00 (Europe/Rome) on a schedule.
  2. Loads configuration values such as sender/recipient email, the Google Sheets document ID/URL, and the notice period in days.
  3. Reads all rows from the Google Sheets tab named “Fatture”.
  4. Filters out invoices marked as paid and parses the due date, collecting invoices due today/within the notice period and separately listing rows with missing or invalid dates.
  5. Stops without sending anything if there are no due invoices and no rows to check.
  6. Builds a plain-text email summary (including amounts and days-until-due) and sends it via SMTP to the configured recipient.

Setup

  1. Add a Google Sheets credential with access to the spreadsheet and set the spreadsheet URL/ID in the configuration values.
  2. Add an SMTP email credential (for example, Gmail with an app password) and set the sender and recipient addresses in the configuration values.
  3. Ensure your spreadsheet has a sheet/tab named “Fatture” with columns for Cliente, Numero (NumeroFattura), Importo, Scadenza, and Stato, and set “Stato” to values like “Pagata/Saldata/Incassata” for paid invoices.

Requirements

  • n8n 2.x (tested on 2.44.6, Cloud or self-hosted); a Google account with the invoices sheet; an SMTP mailbox. Standard nodes only, no community nodes.

Customization

  • Change the time or frequency in the Schedule Trigger; change giorniPreavviso in Configurazione to be warned earlier; replace Send Email with Telegram or Slack for a chat notification.

Additional info

Node names, the Configurazione node and the section notes are in Italian (the overview and setup sticky notes are in English). Dates are accepted as Sheets date cells or as text in DD/MM/YYYY or YYYY-MM-DD; "Pagata", "Saldata" and "Incassata" count as paid. The reminder is sent every day an invoice is within the notice window (no "already reminded" memory). Part of the Italian "Pack n8n per PMI e partite IVA" by NotoriousBrick: https://notoriousbrick.gumroad.com/l/n8n-pmi