Cold email drafts for new Airtable target accounts

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).