// automation and data tools
Via APIAirtable 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
Add single-line or single-select fields Email status, Email reason and Did you mean to your table.
- 2
Create an automation with the trigger "When a record is created" (or "When record matches conditions").
- 3
Add a Run a script action and define input variables recordId (the trigger record ID) and email (the email field).
- 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
Test the action with a real record, then turn the automation on.
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 result | Action 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 empty | Later 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.