Enrich Airtable prospects with a ChatGPT visibility score, then load Smartlead
When a new prospect lands in Airtable, find a verified work email, score the account's AI search visibility, and push it into Smartlead with the score as a mail-merge variable.
Airtable
Nexuscale
SmartleadSalesMarketingLead EnrichmentData SyncEmail AutomationBuild a code-based workflow that enriches new prospects in Airtable, scores their company's generative-AI visibility, and loads verified leads into a Smartlead campaign with the score attached as a mail-merge variable.
Trigger: Airtable poll trigger, event type new_record, on a base and table called something like "Outbound Queue". The base id, table id, and Smartlead campaign id should be exposed as configuration so each install can point at their own resources. Expect the row to have at least these columns: first name, last name, company domain.
Per new record:
1. Read the row and pull first name, last name, and company domain.
2. In parallel, call Nexuscale Find Contact with the name and company to get a verified work email plus profile data (job title, verification status), and Nexuscale Check AI Visibility (GEO) with the company domain to get the account's generative-AI visibility score.
3. Call Airtable Update Record on the same row to write back the email, verification status, job title, and the AI visibility score (call the score column something like geo_score). If either Nexuscale call fails, still write whatever data we did get so the row is not silently empty.
4. Branch on verification status. If Nexuscale returned a verified email, call Smartlead Add Leads to Campaign against the configured campaign id, passing first name, last name, email, company, and the AI visibility score as a custom lead field so it becomes a mail-merge variable inside the Smartlead sequence (used by copy such as "your ChatGPT visibility is currently X out of 10"). If the email is not verified, do not call Smartlead. Instead, update the Airtable row to set a status column to "needs manual review" so a human can handle it.
Keep the flow deterministic and idempotent. If the trigger re-delivers a record we already processed, do not double-add to Smartlead (a simple guard on the row already having an email and status set is fine). Log the outcome of every row: enriched-and-added, enriched-needs-review, or enrichment-failed. Do not invent extra columns or steps beyond what is described.
Additional information
What does this prompt do?
- Watches a chosen Airtable base and table for new prospect rows and picks them up automatically.
- Finds a verified work email for each prospect using Nexuscale, plus a job title and profile data.
- Scores the prospect's company on generative-AI search visibility (ChatGPT, Perplexity, Gemini) so every lead carries its own AI-visibility score.
- Writes the email, verification status, job title, and score back to the Airtable row so your team has one clean record.
- Pushes verified leads into your Smartlead campaign with the score attached as a custom field so your sequence can reference lines like "your ChatGPT visibility is 4 out of 10".
- Skips prospects that come back unverified and flags the row as needs manual review instead of sending anything.
What do I need to use this?
- An Airtable base with an Outbound Queue table that has first name, last name, and company domain columns.
- A Nexuscale account with API access enabled on your plan.
- A Smartlead account and one campaign already set up with a custom lead field for the AI visibility score.
- A shared understanding of which Smartlead campaign new prospects should land in.
How can I customize it?
- Point the trigger at any Airtable base and table, and change which columns feed the lookup.
- Switch which Smartlead campaign the verified leads flow into, or split by segment.
- Rename the custom score field, or add extra Nexuscale profile fields like company size, seniority, or LinkedIn URL to the row.
- Change the review status label used when a prospect can't be verified so it matches your existing Airtable single-select options.
Frequently asked questions
How is this different from a plain email-finder workflow?
What happens if Nexuscale can't find a verified email?
Do I need to write any code?
Can I use the AI visibility score inside my email templates?
Will it re-process rows I have already loaded?
Related templates
Stop guessing which cold prospects are worth writing about.
Connect Airtable, Nexuscale, and Smartlead once, and every new prospect gets a verified email, an AI visibility score, and a spot in the right campaign.