If you keep track of invoices and payment dates in a Google Sheet, this automation will ensure that you stay on top of past due invoices and get paid.
This automation checks to see if today's date matches an invoice date specified in a spreadsheet and automatically sends a reminder email if TRUE.
Lido connects to anywhere your invoices due dates live, most commonly Google Sheets.
IF(TODAY() = C2,SENDGMAIL(<tim@gmail.com>,B2,”Invoice overdue", "Invoice #13 is due”….)
Send a personalized reminder email from Gmail or Outlook account for each upcoming or past due invoice.
SENDGMAIL(<sender-credential>,B2,"Important: Overdue Invoice Reminder","[Name] your invoice is 3 days past due")