Personalized cold emails from Airtable prospects with Wiza

By General Input

Turn every new LinkedIn prospect dropped into Airtable into a verified email, a short personalized Gmail draft, and an enriched row.

Integrations

  • Wiza
  • Airtable
  • Gmail

Type

Agentic Task

Categories

  • Sales
  • Marketing

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.

Related prompts

Explore more prompts
Win back LiveChat visitors whose chats went unansweredChase the paperwork every new client and vendor still owesFile Gmail attachments into storage with names you can findCandidate rediscovery desk for your archived Lever applicantsLaytime and demurrage claim workspace for chartering opsKajabi customer support console for member access fixesRun your application review round on Jotform submissionsCreator roster board for rebook, test, or pause callsRun your nutrition clients' weekly meal plans from one consoleReplace the dispatch whiteboard with a live production board