運用
Invoice Payment Reminders
Email Italian payment reminders for unpaid invoices that are overdue or due within three days, every weekday morning.
ワークフローをダウンロード
Read invoices from Google Sheets at 08:00 on weekdays and send one Italian reminder per unpaid invoice due within three days or already overdue.
Setup
Create a sheet named Invoices with these headers:
| Numero | Cliente | Importo | Scadenza | Stato | |
|---|---|---|---|---|---|
| INV-001 | Ada | ada@example.com | 120.00 | 13/11/2026 | da pagare |
Use DD/MM/YYYY for due dates. The exact status pagata marks a paid invoice, ignoring case and surrounding whitespace. Other statuses remain eligible. Every unpaid overdue invoice is included, regardless of its age.
For Open Flow, import the JSON and configure:
| Node | Configuration |
|---|---|
| Weekday morning | Confirm the schedule timezone; the template starts with UTC. |
| Read invoices | Connect Google Sheets and replace YOUR_SPREADSHEET_ID. The default range is 'Invoices'!A:F. |
| Prepare reminders | Set timezone to the same timezone as the schedule and edit signature. |
| Send reminder | Connect Gmail for the Send Email action. |
For n8n, connect Google Sheets and Gmail, configure the spreadsheet in Leggi fatture, and edit the company signature in Trova scadenze imminenti. Confirm the workflow timezone before enabling it; the template starts with UTC.
Publish and enable the configured workflow. A run reads the complete configured sheet range, filters invoices, and sends reminders in sheet order. Empty results send no messages. A send failure stops later reminders. The workflow does not update invoice statuses or record delivery, so eligible invoices receive another reminder on the next weekday run. Retrying a partially completed run can resend earlier reminders.
Open Flow sends each reminder through a separate Connector execution in the visible feedback loop. There is no 100-reminder total cap. The full sheet range, prepared messages and accumulated send identifiers must fit the platform’s Code input and result budgets; the inspected host allows 1 MiB for each. A limit failure stops the run, and reminders already sent can repeat if you rerun it. A sent message identifier confirms Gmail accepted the request; it does not prove recipient delivery. Inspect Sent before retrying an unconfirmed send.
Changes to the source
- Reject impossible dates such as 31 February instead of rolling them into another month. Missing and malformed dates are skipped.
- Compare calendar dates in the configured timezone, including daylight saving changes.
- Validate eligible recipients before sending any reminders.
- Send plain-text email so the Italian message retains its paragraphs.
- Provide the required sheet headers, spreadsheet placeholder, signature, and explicit UTC starting timezone.
Adapted from Automatic payment reminders from Google Sheets (Italian) in enescingoz/awesome-n8n-templates.
Source collection notice: © 2024–2026 Enes Cingoz, CC BY 4.0. The source export does not identify a separate template author or license. See repository licensing for the scope of OOMOL contributions and third-party material.