Auto-enrich new Airtable prospects with Parallel and Slack alerts

Build an agent workflow that enriches new prospects in my Airtable "Prospects" base and posts a short snapshot to my sales-ops Slack channel.

Trigger: poll Airtable on the Prospects table using the new_record event type. Run for every newly added row.

On each new record, read the company domain field. If the domain is missing or obviously invalid (no TLD, malformed, clearly a personal email host), skip the research entirely and call Airtable Update Record on the same row to set the needs_review checkbox to true. Stop there.

Otherwise, call Parallel Create Task Run with a structured output schema that returns: employee_count_band (one of 1-10, 11-50, 51-200, 201-500, 501-1000, 1001-5000, 5000+), industry, recent_funding_round_name and recent_funding_round_date, top_three_buying_signals as an array of short strings drawn from recent activity (hiring spikes, product launches, leadership changes, press, etc.), tech_stack_marketing_and_sales as an array of currently used tools, top_three_decision_makers as an array of {name, title} objects, icp_fit_verdict as one of "strong fit" / "soft fit" / "no fit", and an overall confidence score from 0 to 1. Use the blocking result endpoint so the workflow waits for completion instead of busy-polling. Pick a research-grade processor tier so the output includes citations and confidence.

If the task fails, or the confidence score is below 0.6, or the verdict is missing, call Airtable Update Record on the same row and set the needs_review checkbox to true. Do not write thin or speculative values into the enrichment columns. Stop there.

If the task succeeds with confidence at or above the threshold, call Airtable Update Record on the same row and write each field from the Parallel result into the matching column. Leave needs_review unchecked.

After the Airtable update, call Slack Send a Message to the #sales-ops channel with a single-line summary in this shape: "<company name> — <ICP fit verdict> — strongest signal: <top buying signal>". Use plain text, no attachments needed.

Integrations to use: Airtable (trigger + Update Record), Parallel (Create Task Run), Slack (Send a Message).

Additional information

What does this prompt do?

Watches your Airtable Prospects table for new rows and reads the company domain from each one.
Pulls headcount range, industry, recent funding, current buying signals, marketing and sales tools in use, and the top three likely decision-makers.
Writes the findings straight back to the same row so reps open a fully filled record instead of an empty one.
Posts a one-line snapshot to your sales-ops Slack channel with the company name, ICP fit verdict, and the strongest buying signal.

What do I need to use this?

An Airtable workspace with a Prospects table and a company domain field on every row.
A Slack workspace where you can post to your sales-ops channel.
A Parallel account for the web research step.

How can I customize it?

Swap the destination channel, or DM the specific account owner instead of pinging the whole sales-ops room.
Change which columns get filled. Add ARR estimate, headquarters country, hiring trend, or anything else your team actually scores on.
Tighten the ICP rules and confidence threshold so weak matches quietly land in a review queue instead of cluttering the channel.

Frequently asked questions

What kind of data does it fill in on each prospect?

Headcount range, industry, most recent funding round and date, three current buying signals from recent activity, the marketing and sales tools they use, and the names and titles of the three most likely decision-makers.

What if a row does not have a valid company domain?

We skip the research and tick a needs_review checkbox on the row so a human can fix the domain or remove the lead. Nothing speculative gets written.

What happens if the research comes back shaky or low-confidence?

Same handling. Instead of writing thin or invented fields, the agent flips the needs_review checkbox so reps never see fabricated data in their pipeline.

Can I send the Slack summary to a private channel or a DM?

Yes. The Slack step can point at any channel you have access to, or DM a specific account owner you want to route the lead to.

Will it run on prospects already in the table, or only new ones?

Only new ones. The trigger fires the moment a row is added to the Prospects table. Backfilling existing rows is a separate one-off run.