← Back to projectsAutomation · Real project
Invoice & Payment Reminder Automation
PythonsmtplibTwilioSQLitecron
Python script that scans unpaid invoices, sends progressive reminders via email and WhatsApp at 7, 14 and 30 days, auto-escalates the tone of communication, and logs every received payment in a local database.
app.dtdigital.it/solleciti● Automation active
Invoice reminders
Scans unpaid invoices · sends reminders · tracks payments
Outstanding4160,00 €4 open invoices
Reminders sent0this month
Invoices paid1+ after reminder
Hours saved0
Invoice statusClick a row to send now
| Client | Invoice | Amount | Status |
|---|---|---|---|
| SAStudio Arch. Bianchi32 days overdue | FAT-2024-087 | 1200,00 € | Overdue |
| FRFerramenta Rossi srl14 days overdue | FAT-2024-091 | 540,00 € | Pending |
| MHMara Hair Studio7 days overdue | FAT-2024-094 | 320,00 € | Pending |
| BCBar Centrale sncSettled | FAT-2024-098 | 780,00 € | Paid |
| OMOfficina Mec. Ferrari5 days overdue | FAT-2024-102 | 2100,00 € | Pending |
Pipeline
ScanComposeSendLog
Reminder logLive
Waiting for next scan...
What it does automatically
Sends reminder at 7, 14 and 30 daysEscalates tone if no responseLogs payment when received
