Export only new or changed Airtable records every day

Full exports are great for backups, but a lot of daily reporting only needs the delta: what was added or changed since yesterday. Airtable can't export "changes" directly, but a filtered view gets you there.

Step 1: add a Last modified time field

Add a field of type Last modified time. By default it updates when any field changes. You can restrict it to specific fields (for example Status and Amount), which is usually what you want: a change to an internal note shouldn't put a record in the client's daily file.

Edits made by automations, scripts and integrations count as changes too, so restrict the field if a sync tool touches every record.

Step 2: build the delta view

Changed in the last few days (rolling): Last modified is within the past number of days, with the number you need. Simple, but consecutive files can overlap.
Changed yesterday (whole calendar day): Last modified is yesterday. Send it early in the morning and each file covers exactly one day with no overlap.
New records only: use a Created time field with the same filters instead.

Hide fields the recipient doesn't need and sort by the modified time. Add a Created time column too, so the reader can tell new records from edited ones.

Step 3: deliver it every day

An Airtable automation can find the records and put them in an email body, but it can't attach them as a file, and the email list stops at 100 records. For a file that imports cleanly into Excel, Google Sheets or another system:

DIY: a scheduled script calls the Airtable API with the view's ID, pages through 100 records at a time with offset, writes CSV and sends it somewhere. You maintain it.
ViewCourier: pick the delta view, choose daily at 06:00 in your timezone, and every recipient gets Changes-2026-03-02.csv before work. The file name template can include the date, so the files sort themselves. Days without changes can be skipped, so no empty files land in anyone's inbox.

What the delta can't tell you

Deleted records don't appear in any view. If deletions matter, keep a periodic full export to compare against, or replace deleting with a "Archived" checkbox.
Which field changed isn't in the export; the record's revision history in Airtable shows that.

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.