Enrich Airtable prospects with a ChatGPT visibility score, then load Smartlead

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