Verify an email column in Airtable

Why an Airtable email column needs verification

Airtable's Email field type validates format only — it accepts anything shaped like an address. Bases fill up with emails from form submissions, imports, CSV pastes, and connected apps, and plenty of those addresses are mistyped, disposable, or long dead. When you sync that base to a sender, a CRM, or a Mailchimp import, every bad row becomes a bounce.

Because Airtable is so often the source of truth that other tools pull from, a dirty email column quietly pollutes everything downstream. Verifying inside the base — and writing the verdict next to each address — means the clean/dirty decision travels with the data, so every automation and sync that reads the base can respect it.

Verifly runs a live SMTP mailbox check and returns a deliverable / undeliverable / risky verdict with disposable, role, and catch-all flags. Airtable's Scripting app and automation scripts both run standard fetch, so calling Verifly and writing the result back is a short script.

Verify the whole column with a scripting-app script

1. Grab a free Verifly key at verifly.email/api/v1/autonomous/register — 100 credits, no card, no captcha.
2. Add a single-line-text or single-select field named Email Status and (optionally) a checkbox named Disposable.
3. Open the Scripting app, paste the script below, and set your table, email field, and status field names.
4. Run it to loop the records, call Verifly for each address, and update the status field in place.
5. Filter or group by Email Status to isolate and remove the undeliverable rows before your next sync.

const table = base.getTable('Contacts')
const query = await table.selectRecordsAsync({
  fields: ['Email', 'Email Status'],
})

for (const record of query.records) {
  const email = record.getCellValueAsString('Email')
  if (!email || record.getCellValueAsString('Email Status')) continue

  const res = await fetch(
    'https://verifly.email/api/v1/verify?email=' + encodeURIComponent(email),
    { headers: { Authorization: 'Bearer vf_your_api_key' } }
  )
  const data = await res.json()

  await table.updateRecordAsync(record, {
    'Email Status': data.disposable ? 'disposable' : data.result,
  })

  await new Promise(r => setTimeout(r, 200)) // gentle pacing
}

Do it automatically on new records

To verify addresses as they arrive rather than in a batch, use an automation: trigger When a record is created (or matches a view), add a Run script action, and verify just the triggering record. Airtable passes the record ID into the script through input config, so you fetch that one email, call Verifly, and write the verdict back. This keeps the column continuously clean without anyone running the batch by hand.

const { recordId } = input.config()
const table = base.getTable('Contacts')
const record = await table.selectRecordAsync(recordId, { fields: ['Email'] })
const email = record.getCellValueAsString('Email')

const res = await fetch(
  'https://verifly.email/api/v1/verify?email=' + encodeURIComponent(email),
  { headers: { Authorization: 'Bearer vf_your_api_key' } }
)
const data = await res.json()

await table.updateRecordAsync(recordId, {
  'Email Status': data.disposable ? 'disposable' : data.result,
})