Back to BuiltWith in Google Sheets
SheetXAI logo
BuiltWith logo
BuiltWith · Google Sheets Guide

Enrich a Google Sheet With BuiltWith Financial and Company Size Data

2026-05-14
5 min read

The Scenario

It's the third week of the quarter. You're a venture analyst at a small fund and your partner just forwarded a Google Sheet with 80 UK SaaS company domains and a single question: "Which of these are worth a deeper look?" No context. No scoring criteria. The expectation is that you'll figure it out.

The conversation that matters is in two days. The scoring doesn't exist yet.

The bad version:

  • Look up each company on BuiltWith individually, copy the financial data fields — estimated revenue, employee count, registered company name — into columns B, C, D by hand
  • Realize BuiltWith's revenue figures use different units across records (some are in GBP, some in USD, some are ranges, some are point estimates), and you have to decide how to normalize them before any scoring formula works
  • Build the ICP scoring formula yourself, realize it's scoring "Medium" everything because your revenue threshold was calibrated to US companies, and recalibrate three times while also preparing the meeting materials

The scoring needs to be credible when you walk into that room. Spending the morning in cell reference hell is not how you get there.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Google Sheet. It reads the domain list and talks to BuiltWith to pull financial and firmographic data, then applies your scoring logic — all without leaving the sheet.

Open the sheet with your 80 UK domains in column A and ask:

For each domain in column A, fetch BuiltWith financial data and write Estimated Revenue, Employee Count, and Registered Company Name to columns B, C, D. Then add a Score column in column E: "High" if estimated revenue is over £5M, "Medium" if between £1M and £5M, and "Low" below £1M.

SheetXAI runs the enrichment, normalizes the revenue figures, and applies the scoring threshold in one pass.

What You Get

  • Column B: Estimated Revenue (normalized, with currency noted where BuiltWith varies)
  • Column C: Employee Count (as a range or point estimate, depending on what BuiltWith returns)
  • Column D: Registered Company Name (the legal entity name associated with the domain)
  • Column E: Score — High, Medium, or Low — based on your revenue bands
  • Rows where BuiltWith returns no financial data get a blank Score with a note so they're easy to spot

What If the Data Is Not Quite Ready

Some domains have no BuiltWith financial data — I want to flag those for manual lookup

For each domain in column A, fetch BuiltWith financial data: Estimated Revenue, Employee Count, Registered Company Name. Write to columns B, C, D. Where BuiltWith returns no financial data, write "Needs Manual Check" in column E. For rows that do have data, apply this score: High if revenue > £5M, Medium if £1M–£5M, Low below £1M.

I want to add a second scoring dimension — tech stack sophistication

Enrich column A domains with BuiltWith financial data (Estimated Revenue, Employee Count, Registered Company Name) in columns B, C, D. Then add two more columns: Tech Score (High if the domain uses Salesforce or HubSpot, Low otherwise) and Final Score (combine Revenue Score and Tech Score — "Top Tier" if both are High, "Qualified" if one is High, "Pass" if both are Low).

The revenue data uses mixed currencies — normalize to GBP before scoring

For each domain in column A, get BuiltWith financial data. Write raw Estimated Revenue to column B and Registered Company Name to column C. Then write a Normalized Revenue column in column D: convert any USD figures to GBP using 0.79 as the exchange rate, keep GBP figures as-is, and mark "Unknown" where currency is unclear. Score in column E using: High > £5M, Medium £1M–£5M, Low below £1M.

Full ICP scoring pipeline in one shot

Enrich the 80 domains in column A with BuiltWith: write Estimated Revenue, Employee Count, Registered Company Name to B, C, D. Normalize revenue to GBP. Score each domain in column E (High/Medium/Low by revenue band). In column F, flag "Salesforce" or "HubSpot" or "Neither" based on tech stack. Sort the sheet by column E descending (High first), then by column F with Salesforce before HubSpot before Neither.

The entire ICP scoring pass happens in one instruction — scored, normalized, and sorted before the meeting.

Try It

Get the 7-day free trial of SheetXAI and open your Google Sheet of prospect domains, then ask it to pull BuiltWith financial data and score each row against your ICP criteria. See also: enrich domains with tech stacks and the BuiltWith overview.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more