A daily report keeps late payments from slipping. A schedule starts the automation every morning, a view lists the invoices that are overdue, and a loop sends one email per invoice to the person who owns it. The view does the filtering, so the report always reflects today's data.
Note:
One email per overdue invoice. Emails sent with Tape's own email account count toward your organization's 24-hour sending quota. Emails sent through your own email account don't.
The loop does nothing for an empty list. When no invoice is overdue, no email goes out.
What you'll need
A database app
Invoiceswith the fieldsTitle,Amount(number),Due date(date),Status(category with the optionPaid), andAccount manager(person).A view of
InvoicesnamedOverdue invoiceswith the conditionsDue dateIs beforeCurrent dateandStatusIs notPaid. To create it, openInvoicesand selectFilterin the toolbar. Without filters, it opens the field list right away. Choose the field and the condition, then selectAdd filterfor the second one. Then selectSave→Create new view.
Build the daily report
Open the
Invoicesapp and click the automations icon at the top right (Create and view automations).Select
New automation, then selectOn a scheduled time or interval.In the trigger, select
One timeand chooseEvery day. Select8:00 AMto change the time. The start time uses the automation's time zone. To see or change it, hover over the top of the editor and selectTime zone, for exampleTime zone UTC+01:00.Select
Add action→Get view. Select the appInvoicesand the viewOverdue invoices. Open the action's menu and turn onLimit results. The action now readsand limit results to 1. Select the number and enter 200.Select
Add action→Loop actions. Set it tofor each, and choose the records fromGet view.Inside the loop, select
Add action→Send email.In
To, type@and choose theEmailof the invoice'sAccount managerfield. The invoice's fields appear underCollected / Invoice. InSubject, enter "Overdue: " and insert theTitlefield.Write the message, for example "This invoice of " followed by
Amount, " was due on " followed byDue date. Insert the invoice'sRecord URLso the recipient can open the invoice.Select
Show previewto check the email, then selectCreate automation.
The result
At 8:00 AM, each account manager gets an email for every overdue invoice they own, with the amount, the due date, and a link. Paid invoices leave the view, so they stop appearing the day after payment is recorded.
Variations
Report to one person. Enter one address in
To, for example[email protected]. The loop then sends that person one email per invoice. For a single email with a table of all invoices, see Build an HTML table from records →.Skip the loop. Replace
Loop actionsandSend emailwithSend email to collected. It sends one email per collected record. Learn more about Send email to collected →Weekdays only. Choose
Every week, then select the weekday afteronand pick Monday to Friday.Another rhythm. You can also repeat every few hours, days, weeks, or months, and pick a day of the month, including
Last day.Escalate. Add a second view for invoices more than 30 days late, and a second loop that emails the finance lead.
Learn more
FAQs
Can I test the report without waiting for the morning?
Can I test the report without waiting for the morning?
Yes, select Manual run to run it once. A manual run sends real emails, so test with a view that only contains an invoice of yours.
Why did I not get an email today?
Why did I not get an email today?
If no email arrived, it could be because:
No invoice is overdue, so the view is empty.
The sending quota for the last 24 hours was used up.
The automation is
Paused.
How many invoices can the report cover?
How many invoices can the report cover?
A collection holds at most 1,000 records, and a run lasts three minutes at most. If your list is longer, work through it in batches. Learn more about batches →
Are you a developer using the Tape API for automations?
Are you a developer using the Tape API for automations?
The automation API has its own documentation for developers. Full reference: for_loop in the developer docs →
Still have more questions? Find answers and get help from community experts in the Tape community →.
