Draft cold emails from new Airtable target accounts

PromptCreate

I want an agent that watches my Airtable "Target Accounts" table for new rows and turns each company I add into a researched Gmail draft I can review and send.

Trigger: poll Airtable for a new record in the Target Accounts table (Airtable new_record event). Each new row will have at least a company name; treat that as the only required input.

For every new record, do this:

1. Read the company name from the new row.

2. Resolve the company's official website by calling Website Contacts Scraper's Get Website URL by Keyword with the company name. Take the top result as the canonical domain.

3. Call Website Contacts Scraper's Scrape Contacts on that domain to pull emails, phone numbers, and social profile links (especially LinkedIn).

4. Pick the primary outreach email. Prefer a role-specific address (for example founder@, ceo@, sales@, partnerships@, named individual mailboxes) over generic catch-alls (info@, hello@, contact@, support@). If only generic mailboxes are returned, fall back to the best of those and note the trade-off in your reasoning. If no email is found at all, skip the draft step and write a short explanation into the Airtable row instead.

5. Write a short, specific cold intro email (around 80 to 120 words) addressed to the chosen email. The email must reference something concrete about the company that you actually know from the scraped data or the domain itself, not generic flattery. Keep the tone direct, no emojis, no em dashes. Include a clear subject line and a single soft call to action (a 15-minute call).

6. Create that email as a draft in Gmail using Create a Draft, with the chosen address in the To field and the subject and body you wrote. Capture the returned draft ID and message ID.

7. Call Airtable Update Record on the originating row to fill in the following fields: resolved website domain, primary contact email, LinkedIn URL (if found), and a Gmail draft link of the form https://mail.google.com/mail/u/0/#drafts?compose=<draftId> so I can click straight into the draft to review and send.

Notes for the build:

- Agent mode is correct because both picking the right email and writing the draft require judgment, not a fixed script.

- Do not send the email. Only ever create a draft so I get the final review before anything goes out.

- If Airtable returns a row with no company name, do nothing and move on.

- Integrations involved: Airtable (poll trigger plus Update Record), Website Contacts Scraper (Get Website URL by Keyword, Scrape Contacts), Gmail (Create a Draft).

What does this prompt do?

Watches your Airtable target accounts list and reacts the moment you add a new company.
Looks up the company's official website and pulls public emails, phone numbers, and LinkedIn from it.
Picks the best person to email, preferring a real role over a generic info@ inbox.
Writes a short, specific cold intro email referencing something concrete about the company.
Saves it as a Gmail draft and writes the contact details and draft link back into the Airtable row.

What do I need to use this?

An Airtable base with a Target Accounts table where you log company names you want to reach.
Fields on that table for the resolved website, primary contact email, LinkedIn URL, and a draft link (text columns are fine).
A connected Gmail account that the agent can create drafts in.
A Website Contacts Scraper account on RapidAPI for the lookup and contact scraping.

How can I customize it?

Change how the agent picks the primary email, for example by always preferring a named founder over any team alias.
Tune the email style, length, or call to action so drafts match your team's voice.
Swap the table or rename the Airtable fields to fit an existing CRM-style base you already use.

FAQs

Does this actually send the email?

No. Every outreach lands as a Gmail draft so you can review the recipient and the wording before anything goes out. You always get the final click.

What if no email shows up for a company?

The agent skips the draft step and writes a short note into the Airtable row explaining what it could not find, so you can decide whether to research the company manually.

How does it pick which email to use?

It prefers role-specific or named addresses, like a founder, CEO, sales, or partnerships inbox, over generic catch-alls like info@ or hello@. If only generic addresses exist, it uses the best of those and flags the trade-off.

Can I use this with a different lead list, like Notion or a Google Sheet?

This prompt is built around Airtable as the source of truth because it has first-class new record monitoring. You can adapt the same flow to other lead lists, but you would tell the workflow author to swap the trigger when you start the build.

Will it write generic, obviously templated emails?

The instructions tell the agent to reference something concrete about the company from what it actually scraped or saw on the website, and to keep the tone direct. You can tighten the style further during customization.

Related templates

Trace phishing emails to the sending IP and report abuse

Every 15 minutes, forwarded phishing reports get traced back to the server that really sent them, with a verdict in Slack and the worst senders reported.