Skip to content

// automation and data tools

Via API

Airtable email verification with pingutil

Airtable bases double as lightweight CRMs and signup databases, so form submissions and imports drop unchecked addresses straight into the tables your team mails from. A Run a script automation action can call pingutil when a record is created and write the status, reason and any typo suggestion back into fields.

Where it connects: Automation "Run a script" action (input.config, fetch, output.set)

What goes wrong without it

  • Our Airtable form collects applications, and a chunk of them use addresses we can never reply to.
  • We send updates from the base and the bounces come back with no record of which rows were bad.
  • I want a field that says whether an email is real, filled in automatically when the record arrives.

What you can do with Airtable and pingutil

  • Verify on record creation

    Trigger "When a record is created", run the script, and fill Email status and Email reason fields so views can filter out invalid contacts.

  • Catch typos on form submissions

    Write did_you_mean into a field and use a later automation step to email the submitter or alert the owner.

  • Separate work and personal emails

    Use /v1/lookup with skip_enrichment: true to fill a Category field (company, free, disposable) for routing views.

Set it up

  1. 1

    Add single-line or single-select fields Email status, Email reason and Did you mean to your table.

  2. 2

    Create an automation with the trigger "When a record is created" (or "When record matches conditions").

  3. 3

    Add a Run a script action and define input variables recordId (the trigger record ID) and email (the email field).

  4. 4

    Paste the script below and replace the table name and the API key placeholder; Airtable automations have no secret store, so use a dedicated pingutil key.

  5. 5

    Test the action with a real record, then turn the automation on.

Run a script: verify and write back to the record
const { recordId, email } = input.config();
const PINGUTIL_KEY = 'pk_live_REPLACE_ME'; // dedicated key for this base
const table = base.getTable('Contacts');

let status = 'unverified';
let reason = '';
let suggestion = '';

try {
  const res = await fetch('https://pingutil.com/v1/verify', {
    method: 'POST',
    headers: {
      Authorization: 'Bearer ' + PINGUTIL_KEY,
      'Content-Type': 'application/json',
    },
    body: JSON.stringify({ email }),
  });
  const data = await res.json();
  if (res.ok) {
    status = data.status;
    reason = data.reason;
    suggestion = data.did_you_mean || '';
  } else {
    reason = data.error || String(res.status); // rate_limited, quota_exceeded...
  }
} catch (err) {
  reason = 'network_error';
}

await table.updateRecordAsync(recordId, {
  'Email status': status,
  'Email reason': reason,
  'Did you mean': suggestion,
});
output.set('status', status);

What to do with each result

pingutil resultAction in Airtable
status = "valid"Email status field = valid; include in mailing views
status = "risky"Keep the record, exclude from bulk sends, show reason (accept_all, role_based)
status = "invalid"Exclude from every send view; reason explains why (mailbox_not_found, no_mx)
did_you_mean not emptyLater automation step emails the owner to confirm the corrected address

Limits to plan for

  • Airtable automation scripts have a 30 second limit and cap the number of fetch requests per run; slow mail servers can take up to about 25 seconds.
  • pingutil allows 60 requests a minute and 300 verified addresses a day (3,000 a month) per account, so a large CSV import into the base will exceed it. Those are Free plan limits; Enterprise has custom limits.
  • The key sits in the script text, visible to base collaborators who can edit automations.

Airtable documentation

Airtable is a trademark of its owner. This integration uses Airtable's documented extension points; it is not an official Airtable app.

Common questions

Can I verify existing records in bulk?
Batch them: send up to 50 addresses to /v1/verify/batch per call, a few calls per script run, and stay within 300 verified addresses a day (3,000 a month).
What if the verification times out?
The script writes unverified and the record stays usable. Re-run the check later with a "When record matches conditions" automation on that status.

Stop bad addresses in Airtable today

Sign in with your email, create an API key and paste it into the step above. Test on a few real addresses first: the live demo shows exactly what your Airtable setup will receive.