Weekly tech-stack prospecting list to Airtable

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.