Enrich Typeform pitch submissions with Harmonic into Airtable

Build me a deterministic code workflow that turns every founder submission on my inbound Typeform pitch form into a fully enriched row in my Airtable deal flow tracker.

Trigger: the Typeform outgoing webhook for a new form response on my pitch form. Use the Typeform integration and configure the webhook subscription on the form. Each invocation should process exactly one submission.

Step 1, extract from the Typeform payload: the company website or LinkedIn URL (whichever answer is present), the pitch summary, the ask, and the contact email. Also keep the raw answers map so I can map any additional questions into Airtable later.

Step 2, call Harmonic's Lookup Company operation using the website domain (or the LinkedIn URL if the website is missing). From the response capture: company name, description, website, headcount, location, founding date, company type, customer type, funding history, stage, and primary contact info.

Step 3, call Harmonic's Get Company Employees operation for the same company, filtered to current senior roles (founders, C-level, VP and above). Capture name, title, and LinkedIn URL for each, so the founding team shows up on the Airtable row.

Step 4, call Airtable's Create Records operation on my deal flow tracker base. Write a single row that includes both the original Typeform answers (pitch summary, ask, contact email, and any other answers I want mapped) and the Harmonic enrichment fields (funding history, headcount, stage, location, founding date, founder and senior team list). Use typecast true so single-select and date fields convert cleanly.

Error handling: if the Harmonic Lookup Company call returns 404 (company not yet in Harmonic), skip the employees call and still create the Airtable row with just the raw Typeform answers, plus a flag field set to "needs manual enrichment" so the row is easy to find and complete by hand later. If any other Harmonic call fails transiently (429 or 5xx), retry with exponential backoff a couple of times before falling back to the same manual enrichment path.

Inputs the workflow should expose so I can configure without editing code: the Typeform form ID, the Airtable base ID and table name, and the field names in Airtable that map to website, company name, funding stage, headcount, location, founding date, founder/team list, pitch summary, ask, contact email, and the manual enrichment flag.

Keep every step a discrete, named node so I can see exactly which call failed if something goes wrong. No agent reasoning, no improvisation — this is pure form intake, enrichment, write.