Skip to content

Lead List Enrichment

Example prompt: "I've got a Google Sheet with 50 company names and domains in column A and B. For each row, look up the company size, industry, headquarters location, and a one-line description, then fill in columns C through F."

How to automate lead list enrichment with GloriaMundo

The Problem

Sales and marketing teams regularly work from lead lists — exported from events, scraped from directories, or handed over by partners. These lists typically contain a company name and maybe a domain, but nothing else. Before anyone can prioritise outreach, someone needs to research each company: visit their website, check LinkedIn, note the industry and headcount, and paste it all into the spreadsheet. For a list of 50 leads, this easily takes a full afternoon. For 200, it stretches across days. The work is repetitive, the results are inconsistent depending on who does it, and by the time it is finished, the leads have gone cold.

How GloriaMundo Solves It

We build a workflow that reads your lead list, researches each company, and writes the findings back to the same sheet. An integration step pulls all rows from your Google Sheet. For each row, a web search step looks up the company using its name and domain. An LLM step reads the search results and extracts the specific fields you need — industry, employee count, headquarters, and a brief description. A code step validates the data and handles edge cases like companies that have been acquired or domains that no longer resolve. A final integration step writes the enriched data back to the corresponding columns. Glass Box preview shows you the enrichment results for every row before anything is written, so you can spot any misidentified companies and correct them.

Example Workflow Steps

  1. Trigger (manual): Run when a new lead list is ready for enrichment.
  2. Step 1 (integration): Read all rows from the 'Leads' Google Sheet, extracting company name and domain from each row.
  3. Step 2 (web_search): For each company, search the web using the company name and domain to find firmographic information.
  4. Step 3 (llm): Extract industry, employee count, headquarters location, and a one-line company description from the search results.
  5. Step 4 (code): Validate and normalise the extracted data — standardise industry names, format locations consistently, flag any rows where the company could not be identified.
  6. Step 5 (integration): Write the enriched data back to columns C through F in the Google Sheet.

Integrations Used

  • Google Sheets — source of the raw lead list and destination for enriched data

Who This Is For

SDRs, sales ops teams, and marketing managers who regularly receive raw lead lists and need to enrich them before outreach or segmentation. Especially useful after conferences, webinars, or partner referral batches where you get names but little else.

Time & Cost Saved

Manually researching and entering firmographic data for 50 companies takes roughly 3-4 hours. This workflow completes the same enrichment in minutes and produces more consistent results. For teams that process lead lists weekly, that is 12-16 hours saved per month — enough to justify the workflow on the first run.