Weekly BuiltWith Prospecting List to Airtable for SDR Teams

Every Monday at 7am, build a fresh outbound prospecting list of companies running a target web technology and push the brand-new accounts into Airtable for the SDR team. This is a deterministic CRUD pipeline with no LLM judgement, so build it as a code workflow.

Trigger: cron, Mondays at 7:00 in the workspace timezone.

Inputs (expose as configurable workflow inputs with sensible defaults):

- technology: the BuiltWith technology name to search for (for example "Shopify", "Klaviyo", "Salesforce").

- country: ISO country filter (default "US").

- minEmployees: minimum company employee count (default 50).

- minSpend: minimum estimated monthly tech spend in USD (default 1000).

- maxDomains: hard cap on how many domains to pull this run (default 200).

- airtableBaseId, airtableTableId: the Prospects table to write into.

Step 1: Call BuiltWith's Lists API "Find Sites Using a Technology" with META=yes and the filters above. Page through results using the NextOffset cursor, accumulating domains until either NextOffset === "END" or the running total hits maxDomains. For each returned site, capture: company name, root domain, country, vertical, employee count, spend estimate, and any social links from the Meta block (LinkedIn, Twitter, Facebook). Treat a 200 response with a non-empty Errors[] array as a failure and surface it.

Step 2: Call Airtable "List Records" against the Prospects table, paginating through the Airtable offset cursor, and collect every existing root domain into a Set. Use this as the dedupe key.

Step 3: Filter the BuiltWith results down to only the domains not already in the Set.

Step 4: Call Airtable "Create Records" to insert the new prospects in batches of 10 (Airtable's documented batch limit). Each row should include the captured BuiltWith fields plus: source_technology = the input technology, run_date = today's date, and status = "New". Use typecast=true so Airtable coerces strings into the right field types.

Step 5: Log a summary of the run: technology searched, total returned from BuiltWith, count already in Airtable, count newly inserted.

Notes: respect Airtable's 5 requests per second per base limit between batches. If BuiltWith returns no results or an Errors[] entry (code -4 means the technology name is not recognised, -5 means the result set is too large), short-circuit and report it cleanly. Do not invent fields the Prospects table does not have, assume the table already has the columns listed above.

Additional information

What does this prompt do?

Finds companies that currently run a technology you care about, like Shopify, Klaviyo, or Salesforce.
Filters the list by country, employee count, and estimated tech spend so your SDR team only sees accounts that fit your ICP.
Checks your Airtable prospects table and skips any company you already track, so nothing duplicates.
Adds the brand-new companies to Airtable with the source technology, run date, and a default New status, ready for outreach.

What do I need to use this?

A BuiltWith account with access to the Lists API. A free account works for testing, paid plans return more results.
An Airtable workspace with a Prospects table that has a column for company name, root domain, country, vertical, employee count, spend estimate, social links, source technology, run date, and status.

How can I customize it?

Change the target technology, country, minimum employee count, and minimum spend to match a different ICP segment.
Adjust the cap on how many companies you pull per run, for example 200 domains a week.
Move the schedule to a different day or time, or run it twice a week for two different technologies.

Frequently asked questions

What does my Airtable table need to look like?

A single Prospects table with columns for company name, root domain, country, vertical, employee count, spend estimate, social links, source technology, run date, and a status field that defaults to New. The workflow uses root domain as the unique key when checking for duplicates.

Will this create duplicate rows for companies I already track?

No. Before adding anything, the workflow reads every existing root domain from your Prospects table and only inserts companies you do not already have. If a company shows up again later for a different technology, it stays a single row.

Can I target more than one technology?

Each run targets one technology so the source column stays clean. If you want to prospect against several technologies, duplicate the workflow and point each copy at a different tech, country, or employee band.

How big can the weekly list get?

You set the cap. A typical SDR team starts at 100 to 200 new domains a week so the list stays reviewable. BuiltWith can return far more if you raise the limit, but most teams find a tighter ICP works better than volume.

Do I need a paid BuiltWith plan?

The Lists API is a paid tier on BuiltWith. Free accounts can run a smaller version of this workflow with the Free API, but the filters for country, employees, and spend require a paid plan.