Enrich a list of company domains in Google Sheets
You have a column of company websites and want to know who each company is: what they do, how big they are, what they run on, whether they're hiring. Put one formula next to the first website, fill it down, and every row enriches itself from the company's own site and public records.
How it works
- Create an account and copy your personal key (or a limited share key from the link builder).
- Next to your first website, paste the IMPORTDATA formula below and fill it down.
- Each row fills in on its own. Change the columns parameter to pick what you get back.
Formula for cell B2, with the website in A2
=IMPORTDATA("https://programmable.info/x/live?key=YOUR_KEY&header=0&domains="&ENCODEURL(A2))Example: what goes in, what comes out
Cell A2
northwind-coffee.com One row back, with these columns
| company_nameCompany | Northwind Coffee |
| industryIndustry | Food and beverage |
| headquartersHeadquarters | Portland, Oregon |
| employeesEmployees | 140 |
| ecommerceE-commerce | Shopify |
| analyticsAnalytics | Google Analytics 4, Meta Pixel |
| linkedin_urlLinkedIn | linkedin.com/company/northwind-coffee |
| open_rolesOpen roles | 4 |
| dmarc_policyDMARC policy | quarantine |
| security_gradeSecurity grade | B |
A made-up company; the column names are the real ones you'll see in the sheet.
What you get
- Company name, industry, HQ, founded, employees
- Tech stack: CMS, ecommerce platform, analytics, hosting
- Social profiles and key links (pricing, careers, docs)
- Hiring: open roles, departments, remote roles
- Email setup (SPF, DKIM, DMARC) and security grade
Questions
- Do I need to install anything?
- No. The formula works in any Google Sheet. There's also an add-on and a CSV upload if you prefer.
- Is my list stored?
- No. Rows are built when you ask and never stored; only public company facts are cached to make repeat lookups fast.
- How much does it cost?
- A row costs one credit, plus one for each extra-cost column group you pick (the email finder, leadership, performance and marketplaces). New accounts come with credits included to start.
500 credits included to start
No card needed. Rows are built when you ask and never stored.
Enrich your first list