Skip to main content

B2B data and enrichment

How to enrich a CSV of leads, step by step

Most lead lists start life as a spreadsheet: an event export, a list from a partner, a sheet a rep kept. This guide walks through enriching one in GTM Scoop, from preparing the file to sending the finished rows where your team works.

By GTM Scoop · Published · 2 min read

Part of What is data enrichment? A guide for GTM teams

1. Prepare the file

  • One row per person or company, with a header row.
  • Give every row a phone number or an email, plus a street address and ZIP: for company data a match needs both.
  • Matching tries phone number, then email, then address and ZIP, so the more of these each row has, the more rows match.
  • Keep your own ID column (a CRM ID or a row number) so you can join the results back.
  • Save it as a CSV file.

2. Upload it and map the columns

In Connect Data, upload the file. GTM Scoop suggests which of your columns holds the phone number, email, address and ZIP; check each suggestion and fix any that are wrong. The mapping is what makes the match: an email column mapped as a name will not match anything.

3. Check the coverage before you spend

You see how many rows can be matched before you commit, and each matched row keeps the signal it matched on: phone, email or address. When coverage is low, the usual cause is a missing or mis-mapped phone, email or address column, so fix the mapping before enriching.

4. Enrich

Start the enrichment. Each matched row is filled in with firmographics, contacts and decision makers, and one enrichment credit enriches one account. Enrichment needs a Starter plan (200 credits a month) or Growth (500). Large files run as a job, and the results appear when it completes.

5. Review the results

  • Check which signal each row matched on, and spot-check a sample before outreach.
  • Rows that did not match usually lack a phone number, an email or a full address with ZIP. Add what is missing and run them again.
  • Download the results as a CSV, or keep them in GTM Scoop as a saved list.

6. Send the enriched records on

Send the rows to Salesforce, HubSpot or Zoho CRM as leads or contacts (up to 500 per send), to Apollo, Instantly or Clay for outreach (up to 200 per send), or into a Snowflake or ClickHouse table. Records get a Domain column when they have a website or a work email to take it from. See every integration.

Next: find more accounts like these

If the file is a list of your customers, GTM Scoop Analysis can learn what they have in common and find lookalike accounts. See how to find lookalike companies.

Doing it from code

The same flow runs over the REST API: create an upload, start a run, enrich it and read the results. The Uploads, Enrichment and Results references have every request.

Try it in GTM Scoop

Upload a CSV

Cookies on GTM Scoop

Essential cookies keep you signed in and the site secure, and are always on. Optional cookies (Google Analytics) help us understand how the site is used. They are on by default, except in the EU/EEA, the UK and Switzerland, where they stay off until you choose Accept All Cookies; choose Essential Cookies Only to turn them off. We do not use advertising cookies and we do not sell or share your personal information. The site works the same whichever you choose. We keep a record of your choice with the date, your IP address and the page you were on. Cookie Policy · Privacy Policy