Daily email of overdue tasks from Airtable

A morning email that lists what's overdue keeps a project base honest. Here is a setup that works for one person, a whole team, or each assignee separately.

Step 1: the overdue view

In your Tasks table, create a grid view called Overdue with these filters (all conditions must match):

Due date is before today (use is on or before to include tasks due today);
Status is not Done (or a Completed checkbox is not checked);
Due date is not empty.

Sort by due date, oldest first, and show only the useful columns: task, assignee, due date, project, status. Optionally add a formula field for the days overdue: DATETIME_DIFF(TODAY(), {Due date}, 'days').

Step 2: one email for everyone, or one per person?

Team digest: one view, sent to the team lead or a shared address.
Per assignee: duplicate the view per person with an extra filter Assignee is that person, and send each view to that person only. With a handful of people this is simpler and more private than one big list.

Step 3: send it every morning

With an Airtable automation

Trigger At a scheduled time (daily, weekdays), Find records from the Overdue view, then Send email with the records as a grid. Good for short lists. Keep in mind that the email shows at most 100 records, that test runs only preview the first 10, and that daily runs on every weekday add up against your plan's automation run limit.

As a CSV attachment

If the list is long, or a manager wants to filter it in Excel, send the view as a CSV file. With ViewCourier you pick the Overdue view, choose daily at 08:00 in your timezone, and add the recipients; every run attaches the full view as a CSV and the subject shows the row count, so "Overdue: 0 rows" tells you at a glance that everything is on track. If you'd rather hear nothing on good days, tick Don't send scheduled emails when the view has no records; the email then only arrives when something is actually overdue.

Tips

Skip weekends in the automation's schedule settings, or run a weekly summary on Monday instead.
Check the timezone of the Due date field. "Before today" is evaluated in the field's timezone setting; if that's GMT and your team is in Asia or the Americas, tasks flip to overdue at an odd hour.
Use the same view in an Interface so people can fix their overdue tasks straight from the email's context.

Let ViewCourier do it

Connect a read-only Airtable token, pick a view, and choose daily, weekly or monthly at your time and timezone. Every run emails a clean CSV attachment to up to five people. The free trial lasts 14 days and needs no credit card.

Start free trial