Enrich new HubSpot companies with tech stack and hiring data

Build a code workflow that automatically enriches every new company in my HubSpot CRM with TheirStack data.

Trigger: a HubSpot webhook that fires whenever a new company record is created. The payload will include the company ID and (depending on subscription) the domain.

For each new company:

1. Resolve the company's primary domain. If the webhook payload does not include it, fetch the company from HubSpot by ID and read the domain property. If there is no domain, exit early.

2. Call TheirStack Get Company Technographics with that domain to retrieve the full tech stack with confidence and mention counts. Keep the top 5 to 10 technologies ranked by confidence.

3. Call TheirStack Search Jobs scoped to the same company domain (company_domain_or) with posted_at_max_age_days = 30. Aggregate the total open roles count and pick the top hiring function (engineering, sales, marketing, operations, etc.) based on the job titles returned.

4. Use HubSpot Update Company to write structured fields back to the same company record: top technologies as a tag-style list, total open roles as a number, and top hiring function as a single value. Skip the write if TheirStack returned no data for a given field so existing values are not blanked out.

5. Use HubSpot Create Note associated with the company to attach a one-paragraph hiring snapshot summarizing the recent postings (a handful of representative titles, locations, and posted dates). Only create the note if there were jobs in the last 30 days.

Every step is deterministic with known inputs and outputs (webhook, then two TheirStack lookups, then two HubSpot writes), so this should be a pure code workflow with no agent reasoning. Handle the case where TheirStack returns no technographics or no jobs by skipping that step cleanly.

Additional information

What does this prompt do?

Triggers the moment a new company is created in HubSpot, so enrichment never falls behind.
Looks up the company's tech stack and recent hiring activity over the last 30 days.
Writes the top technologies, total open roles, and top hiring function back to the company record.
Attaches a one-paragraph hiring snapshot note to the company so reps see the story without leaving HubSpot.

What do I need to use this?

A HubSpot account where you can authorize a connection and write to company records and notes.
A TheirStack account and API key (the technographics and job search features are required).
Company records in HubSpot that have a domain populated, since the workflow looks up by domain.

How can I customize it?

Change the hiring lookback window (30 days by default) to match how quickly your team wants signals.
Pick which company properties get written, like adding a tag when a specific technology is detected.
Filter which companies get enriched, for example only those with a domain or based in certain regions.

Frequently asked questions

Does this run on companies that are already in HubSpot, or only new ones?

It runs on newly created companies. If you want to backfill existing records, you can trigger a one-time enrichment by re-importing or updating those companies, or ask us for a backfill variant.

What happens if TheirStack has no data for a company?

If there is no tech stack or recent job posting data for the domain, the workflow skips the writes for that company. It will not overwrite existing fields with blanks or create empty notes.

Will this work on HubSpot Free?

Yes. The workflow only needs permission to read and write company records and create notes, which HubSpot Free supports.

How do I change the 30 day hiring lookback?

The lookback window is a setting in the workflow. You can change it to 7, 60, or 90 days without editing any code.

Will it overwrite values I already entered?

By default it only fills empty fields, so your manual edits are safe. You can switch it to always overwrite if you want TheirStack to be the source of truth.