Typeform to Airtable VC deal flow with Harmonic enrichment

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.

Additional information

What does this prompt do?

Listens for new founder submissions on your inbound pitch Typeform and kicks off the moment one arrives.
Looks up the company on Harmonic by website or LinkedIn to pull funding history, headcount, stage, location, founder info, and the current senior team.
Writes a fully populated row into your Airtable deal flow tracker with the form answers and the Harmonic enrichment side by side.
Falls back to a row flagged as needs manual enrichment when Harmonic has no match, so nothing falls through the cracks.

What do I need to use this?

A Typeform account with the pitch form you already use for inbound founder submissions.
A Harmonic account with API access for company and people enrichment.
An Airtable base set up as your deal flow tracker, with columns for the form answers and the Harmonic fields.
Knowing which Typeform questions hold the company website or LinkedIn URL, the pitch summary, the ask, and the contact email.

How can I customize it?

Swap in a different Airtable base or table if you keep separate trackers for pre-seed, seed, and Series A.
Change which Harmonic fields land in Airtable, for example adding total funding raised, last round size, or investor list.
Adjust the senior-role filter on the founding team lookup, for example expanding from founders only to all VP and C-level current employees.
Tweak the manual enrichment flag, for example routing those rows into a separate review view or tagging them with the date of submission.

Frequently asked questions

What happens if Harmonic has never heard of the company?

The row still gets created in Airtable with the founder's original Typeform answers. It is flagged as needs manual enrichment so you can either revisit Harmonic later or research the company yourself, instead of silently dropping the lead.

Do I need a specific Typeform plan for this to work?

No. Outgoing webhooks on new form submissions are available on all paid Typeform plans, including Basic. Free plans do not support webhooks, so the trigger will not fire there.

Can I use this with a Google Sheet or Notion database instead of Airtable?

Yes. The shape of the workflow is the same. Tell the builder to write the enriched row into your tool of choice and it will swap the Airtable step for the right one.

Will it overwrite an existing row if the same founder submits twice?

By default each submission creates a new row in your tracker. If you want dedupe behavior, ask the builder to match on the founder's email or company domain before creating, and update the existing row instead.

Does this pull the founding team or just the company?

Both. Alongside the company enrichment, it fetches the company's current senior employees from Harmonic, so the founders and key leaders show up on the Airtable row without a second research pass.