Personalized cold email drafts from Airtable + Wiza + Gmail

Build me an agent workflow that turns new prospects in Airtable into personalized cold email drafts in Gmail.

Trigger: Airtable poll trigger on the new_record event for my 'Prospects to Email' table. The table has a LinkedIn profile URL column for each row. Fire once per new row.

For each new prospect row, the agent should:

1. Call Wiza Start Individual Reveal with the LinkedIn profile URL using the 'full' enrichment level so I get both verified work email and phone. (Note: 'full' costs more Wiza credits than 'partial'. If I only need email, the agent should be configured to use 'partial' instead, and skip the phone field write-back.)

2. Poll Wiza Get Individual Reveal with the returned reveal ID until status is 'finished'. Back off sensibly between polls and give up cleanly if it never finishes.

3. If the reveal does not return a verified work email, skip this prospect entirely. Do not create a draft and do not update the Airtable row. Log the skip so I can review.

4. Otherwise, extract the verified work email, current job title, and current company from the reveal. Then call Wiza Company Enrichment for the prospect's current company to grab firmographic context: industry, company size or employee count, headquarters location, and any recent funding or growth signals available.

5. Use my pitch context (configured once when the workflow is set up: what I sell, who it's for, the value prop, and tone) plus the prospect's role, company, industry, size, and recent signals to draft a short cold email. The draft must include a subject line under 60 characters and an 80 to 120 word body that opens with a specific reference to the prospect's role or company, not a generic intro. Close with one clear, low-pressure call to action.

6. Call Gmail Create a Draft addressed to the verified work email with the generated subject and body. From and Reply-To should be my connected Gmail account. Do not send the email. Capture the draft's message ID.

7. Call Airtable Update Record on the same row that triggered the workflow and write back: verified work email, verified phone (when present), current title, current company, and the Gmail draft message ID. Use whatever column names I configure for those fields.

Other requirements: handle Wiza rate limits and the 'queued / processing / finished' lifecycle gracefully. Keep all writes idempotent so re-running the same row does not create duplicate drafts. Use the agent workflow type with natural-language instructions.

Additional information

What does this prompt do?

Watches an Airtable table of prospects and reacts the moment a new row with a LinkedIn URL appears.
Uses Wiza to find the prospect's verified work email, current title, company, and a phone number when available.
Pulls firmographic context like industry, company size, and recent signals so the email opener feels researched.
Writes a short, personalized cold email straight into your Gmail Drafts so you can review and send manually.
Updates the original Airtable row with the verified contact info and a link to the saved draft.

What do I need to use this?

An Airtable base with a 'Prospects to Email' table that includes a LinkedIn URL column.
A Wiza account with API access enabled and enough credits for individual reveals and company lookups.
A Gmail account you want the drafts created in.
A short pitch blurb describing what you sell and the angle you want every email to take.

How can I customize it?

Switch Wiza from a full reveal (email plus phone) to a partial reveal if you only need email and want to save credits.
Tune the email voice, length, or opening style by editing the pitch context the agent uses.
Add filters so only rows tagged with a specific segment, campaign, or owner trigger the workflow.
Change which Airtable columns the verified email, phone, and draft link are written back into.
Swap Gmail Create a Draft for Send a Message later if you trust the output enough to skip manual review.

Frequently asked questions

Will it actually send the email automatically?

No. By design it stops at a Gmail draft so you can read it, tweak the subject or opener, and hit send yourself. You can change that later if you want full automation.

What happens if Wiza can't find a verified work email?

The prospect is skipped. No draft is created and the Airtable row is left alone so you can decide what to do with it manually.

How much does each prospect cost in Wiza credits?

A full reveal that returns both email and phone uses more credits than a partial reveal that only looks for an email. You can pick which one to run when you set up the workflow.

Can I use a different prospect table or column names?

Yes. Point the workflow at any Airtable base and table you own, and tell it which column holds the LinkedIn URL and which columns to write the verified email, phone, and draft link back into.

Does the email actually feel personalized?

Yes. The agent uses the prospect's role, company, industry, and any recent firmographic signals from Wiza, plus your pitch blurb, to open with a specific reference instead of a generic intro line.