Find the records somebody left half-filled · Airtable | Claritty
Operations automations

Find the records somebody left half-filled

Reads an Airtable table each morning and emails you the rows with fields still empty.

Add this automation

Free, and no card. It runs for real, five times.

What it does on a run

  1. 1Read the table
  2. 2Find the gaps without being told the columns
  3. 3Email me what needs filling in

When it runs

Every weekday at 9am. You can change the schedule in plain words after you start it.

What it needs

AirtableGmail

Connected once, then reused by every automation that needs them.

What you fill in

Asked once, on the review screen, before it runs for the first time. Everything else it works out for itself.

  • Airtable base idrequired
  • Airtable table id or namerequired
  • Send the gaps tooptional

Where it stops

It halts before the irreversible part and shows you what it is about to do. You see the message, the recipient and the data it read, and nothing is sent until you say so. Once you trust it, you can tell it to stop asking.

Free, and no card. It runs for real, five times.