How to send a weekly digest of new Airtable records

"Can Airtable email me every record that was added this week?" is one of the most common automation questions. It takes two pieces: a view that contains exactly this week's records, and something that sends that view on a schedule.

Step 1: make sure you have a created date

Add a Created time field to the table if it doesn't have one. It fills in automatically for existing records too, because Airtable knows when every record was created. (A formula field with CREATED_TIME() does the same.)

Step 2: build the "this week" view

"This week" can mean three different things. Pick the one your readers expect:

The last 7 days (rolling). Filter: Created time is within past week. Airtable's support docs define this as the past 7 days from today, not the calendar week. Good for a digest sent on any day.
The current calendar week. Filter: Created time is within this calendar week. Good when the digest goes out on Friday afternoon.
The previous calendar week. There is no built-in filter for it, so add a formula field such as IF(DATETIME_FORMAT(CREATED_TIME(), 'YYYY-WW') = DATETIME_FORMAT(DATEADD(TODAY(), -7, 'days'), 'YYYY-WW'), 1, 0) and filter on it being 1. Good for a Monday-morning recap of last week. Check it once around New Year, when week numbers wrap.

Then hide the fields nobody needs, and sort the view (for example by created time, newest first). Whatever the view shows is what the digest should contain.

Step 3: send it every week

Option A: an Airtable automation (short lists)

Trigger At a scheduled time (weekly), action Find records using the view from step 2, then Send email with the found records inserted as a list or grid. This is free and built in. The limits:

the list in the email body is capped at 100 records, with no warning when more were found;
the records arrive as text in the email, so nobody can sort, filter or open them in Excel;
each run counts toward your plan's monthly automation runs.

Option B: a CSV attachment of the whole view

If the week can have more than 100 records, or the recipients want a spreadsheet, send the view as a CSV file instead. ViewCourier does this without code: connect a read-only token, choose the base, table and the "this week" view, set weekly, Monday 08:00 in your timezone, and add up to five recipients. Every run emails a dated CSV of every record in the view, with the view's visible fields and sort order. Quiet weeks don't have to produce an empty email: tick Don't send scheduled emails when the view has no records and nothing is sent when there's nothing new.

Tips

Match the filter to the send time. A "previous calendar week" view sent on Monday morning covers Monday to Sunday of last week. A rolling "past week" view sent on Monday overlaps with nothing and misses nothing if you send it every 7 days.
Check where your week starts. Create a test record on a Sunday or Monday and confirm it lands in the week you expect before relying on the digest.
Time zones: TODAY() and date filters use the base's or field's timezone settings. Records created late at night can land in the "wrong" day if those differ from yours.

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