You host a webinar. You attend an industry conference. You co-organize a B2B event. You walk away with a list of attendees — names, maybe a company, sometimes an email. That’s it.
The problem? A raw attendee list doesn’t get you very far. No job title, no phone number, no LinkedIn profile, no company size. You can’t personalize your outreach, and you definitely can’t prioritize who to follow up with first.
Data enrichment changes that entirely. In a few automated steps, you turn incomplete records into fully actionable prospect profiles — verified email, phone number, LinkedIn URL, job title, company headcount, and more. Here’s exactly how to do it.
Enrich your event lists directly in Google Sheets
Find emails, phone numbers, and company data for your attendees in a few clicks — without leaving your spreadsheet.
Why Event Attendees Are the Highest-Quality Leads You’re Not Fully Exploiting
People who register for a webinar or show up at an industry event have one thing in common: they chose to be there. That’s a rare, high-value intent signal.
A lead from a paid ad might have clicked out of curiosity. Someone who attended your webinar on “automating B2B prospecting” has an active problem to solve. Their engagement level is structurally higher — and so is their conversion potential.
According to HubSpot, event and webinar leads convert to pipeline at 2 to 3 times the rate of paid ad leads. Yet most of these lists never get properly worked, simply because the data isn’t complete enough to personalize outreach at scale.
That’s exactly where data enrichment comes in.
What a Raw Event Export Contains — and What’s Missing
Depending on the platform (Eventbrite, Livestorm, Zoom Webinars, Hopin, Brevo Events), event exports vary — but they typically include:
| Data usually present | Data usually missing |
|---|---|
| First name / Last name | Verified professional email |
| Email (often personal) | Phone number |
| Company name | Exact job title / department |
| Registration date | Company size |
| Attendance status | LinkedIn profile URL |
| — | Tech stack |
| — | Estimated revenue |
In other words, you have the foundation — but everything needed to segment, prioritize, and personalize is missing. Enriching this data fills precisely that gap, automatically pulling the missing attributes from the data you already have.
Now that the stakes are clear, let’s walk through the enrichment process step by step.
How to Enrich an Event List: Step-by-Step
Step 1: Clean and Normalize the Raw List
Before enriching anything, your list needs to be clean. A badly formatted name or a duplicate record corrupts everything downstream.
In Google Sheets, start by:
- Removing duplicates using Derrick’s Remove Duplicates feature or via Data > Remove duplicates
- Normalizing first and last names (proper capitalization, no stray spaces) with the Data Normalization function
- Checking that email addresses are professional (not Gmail or Hotmail) where possible
Expected outcome: A clean, deduplicated list with consistent formatting. On a list of 200 attendees, expect to remove 10 to 20 redundant or unusable entries.
Step 2: Find LinkedIn Profiles for Each Attendee
If your export doesn’t include LinkedIn URLs — which is almost always the case — this is the first data point to retrieve. The LinkedIn profile is the backbone of B2B enrichment: it’s the source from which you’ll pull most of the missing attributes.
Derrick’s LinkedIn Profile Finder takes a first name, last name, and optionally a company name as input — and returns the matching LinkedIn URL.
In your Google Sheet:
- Set up columns for first name, last name, and company (if available)
- Launch LinkedIn Profile Finder from the Derrick menu
- Map the input columns
- Retrieve LinkedIn URLs in a dedicated output column
Expected outcome: 70 to 85% match rate depending on how complete your input data is. For unmatched profiles, a quick manual LinkedIn search using available data is still an option.
Step 3: Enrich Each Profile With 50+ Attributes
Once you have LinkedIn URLs, you unlock a wealth of information. Derrick’s LinkedIn Profile Scraper takes each URL as input and automatically returns:
- Exact job title and department
- Tenure in current role
- Previous work experience
- LinkedIn connection count
- Location (city, country)
- Profile bio / summary
- Associated company data (industry, headcount, HQ location)
For Mike, a Sales Ops manager at a B2B SaaS company, this step alone is enough to identify which attendees are decision-makers (C-level, VP, Director) versus end users — and prioritize his follow-up sequence accordingly.
Expected outcome: Each row in your spreadsheet fills with 20 to 50 additional attributes automatically. You can then filter by job title, industry, or company size to build targeted segments.
Step 4: Find and Verify Professional Email Addresses
Your event export may already include an email address — but is it professional? Is it still valid? Both questions directly affect your deliverability.
Finding the professional email: If you only have a name and company, Derrick’s Email Finder reconstructs the professional address with real-time validation. It tests the most common email patterns (firstname.lastname@domain.com, f.lastname@, etc.) and only returns confirmed addresses.
Verifying existing emails: If your list already contains emails, run them through the Email Verifier before any outreach campaign. The tool checks MX record validity, simulates an SMTP connection, and flags catch-all addresses, spam traps, and likely hard bounces.
According to Validity, contact databases lose an average of 22.5% of their validity every year. An event list from several months ago can already contain 15 to 30% invalid addresses.
A bounce rate above 5% on a cold email campaign is enough to get your sending domain blacklisted. Email verification isn’t optional.
For more on this topic, read our guide on email verification and list cleaning.
Expected outcome: A fully verified email list, classified by status (valid, catch-all, invalid). For outreach campaigns, use only “valid” addresses — and treat “catch-all” ones with caution.
Step 5: Add Phone Numbers for Priority Prospects
For high-value profiles — decision-makers, companies that match your ICP — adding a phone number opens a second outreach channel (call, SMS follow-up).
Derrick’s Phone Finder extracts phone numbers directly from LinkedIn profiles. It takes a LinkedIn URL (retrieved in Step 2) as input and returns the associated mobile or direct number when available.
Expected outcome: Coverage rates vary (30 to 60% on average) depending on profile completeness. Works best on profiles with a large network and active LinkedIn presence. See our full guide on phone enrichment tools for more detail.
Step 6: Score and Prioritize Leads With AI
You now have a clean, enriched list with verified emails and phone numbers. Final step: prioritization. Not every attendee deserves the same level of attention.
Derrick’s AI Lead Scoring analyzes your enriched data against your custom criteria — ICP fit, company size, industry, job title, seniority — and assigns a score to each lead. You define your scoring rules in plain language, and Derrick applies them across your entire list in bulk.
Emma, Head of Sales at a B2B SaaS startup, uses this step to split her 300 webinar attendees into three buckets: “Contact this week”, “Long-term nurturing sequence”, and “Do not contact”. The result: her SDR team focuses 80% of their energy on the 20% of leads most likely to convert.
Expected outcome: Each lead scored from 0 to 100 with a justification. Custom segmentation columns can be created directly in Google Sheets.
Event and Webinar Platforms: What They Export (and What’s Missing)
Before you can enrich, you need to know what you’re working with. Here’s a quick overview of the most common platforms:
| Platform | Data exported | Format |
|---|---|---|
| Eventbrite | Name, email, registration date, ticket type | CSV |
| Livestorm | Name, email, attendance duration, questions asked | CSV |
| Zoom Webinars | Name, email, join time, duration | CSV |
| Hopin | Name, email, company, title, sessions attended | CSV |
| Brevo Events | Name, email, custom tags | CSV |
In every case: no LinkedIn URL, no phone number, no advanced firmographic data. That’s exactly what Derrick fills in, directly in Google Sheets from your CSV export.
Common Mistakes When Enriching Event Lists
Problem 1: Enriching before cleaning
Impact: Duplicates make it into your CRM, you contact the same person twice, and you waste enrichment credits. Solution: Always deduplicate and normalize before enriching. The correct sequence is: clean → enrich → verify → score.
Problem 2: Sending emails without verifying them first
Impact: High bounce rate, damaged sender reputation, risk of domain blacklisting. Solution: Run all emails through the Email Verifier before any campaign. For a list of 200 contacts, this takes minutes — and prevents weeks of reputation rebuilding.
Problem 3: Enriching the entire list without any prioritization
Impact: Enrichment budget spent on out-of-ICP profiles, credits wasted. Solution: Do a quick manual filter (by company name or job title) before running bulk enrichment. Focus your credits on high-potential profiles first.
Problem 4: Ignoring no-shows
Impact: You miss out on prospects who expressed genuine interest by registering. Solution: People who registered but didn’t attend still raised their hand. Enrich them too — but segment them into a softer, longer nurturing sequence rather than a direct outreach flow.
Problem 5: Waiting too long after the event
Impact: The contact becomes stale, memory of the event fades, response rates drop sharply. Solution: Launch enrichment within 48 hours of the event. The window of relevance is short — especially after a webinar.
GDPR and Event List Enrichment: What You Need to Know
Enriching personal data in a B2B context is regulated under GDPR — but it’s not prohibited. Here are the key points to respect:
Applicable legal basis: In B2B, enrichment can rely on legitimate interest, provided the processing is proportionate and individuals have been given the opportunity to exercise their rights. Attendees at a professional event have generally accepted terms and conditions that include a mention of data use.
What you can do:
- Enrich professional data (work email, job title, company) of attendees who accepted event T&Cs
- Contact these individuals in a professional context directly related to the event subject
- Retain data within your declared retention period (typically 3 years from last contact)
What you must do:
- Inform attendees that their data may be used for prospecting purposes (mention in event T&Cs)
- Make it easy to exercise the right to opt out
- Document the legal basis used in your data processing register
What you cannot do:
- Enrich or contact attendees about topics unrelated to the event they attended
- Retain data indefinitely without a defined retention period
For more on cold email compliance in B2B, see our article on cold emailing and GDPR.
How to enrich your B2B database
Discover every method to enrich a prospect database, from scratch to 50+ attributes.
Key Takeaways
- Event and webinar attendees are among the highest-intent leads in B2B — their presence is a strong signal of active interest
- A raw event export is always incomplete — verified email, phone, LinkedIn URL, and firmographic data are almost never included
- The optimal enrichment sequence is: clean → find LinkedIn profiles → enrich with 50+ attributes → verify emails → add phone numbers → AI score
- Sending emails without verifying them first puts your sending domain at risk of blacklisting
- GDPR allows B2B enrichment under legitimate interest — as long as it’s documented and proportionate
- Run enrichment within 48 hours of the event to maximize response rates
Conclusion: Turn Your Event Lists Into an Active Sales Pipeline
An attendee list is worth what you make of it. Raw, it gives you names. Enriched, it gives you opportunities. The difference? A few hours of automated work in Google Sheets.
The steps covered in this guide — cleaning, LinkedIn enrichment, email verification, phone lookup, AI scoring — can be run end-to-end on 200 to 500 contacts in less than a day. The time saved on manual research and the data quality gained more than justify the effort.
Teams that systematically enrich their event lists report email open rates 40 to 60% above average — simply because they’re reaching the right people, with the right message, at the right time.
Enrich your next event list in a few clicks
Derrick turns your Google Sheets into a B2B enrichment hub: emails, phone numbers, LinkedIn data, and AI scoring — with no complex setup required.
FAQ
Can I enrich an event list if I only have first name, last name, and email? Yes. With a first name, last name, and company domain (often extractable from the email address), Derrick can locate the corresponding LinkedIn profile and run a full enrichment. The Name from Email feature can also reconstruct the likely profile from an email address alone.
How long does it take to enrich a list of 200 attendees? With Derrick in Google Sheets, a full enrichment run on 200 contacts — LinkedIn profiles, email verification, phone numbers, and AI scoring — typically takes between 30 minutes and 2 hours depending on match rates and data availability.
Is it legal to enrich data from webinar attendees? In a B2B context, yes, provided the processing is based on legitimate interest or consent, attendees were informed of potential data use, and enrichment stays within a professional scope. In most EU countries, B2B cold email outreach without prior consent is permitted as long as an opt-out mechanism is clearly provided.
Which platform produces the best export data for enrichment? Hopin and Brevo Events generally produce the most complete exports (name, email, company, job title). Livestorm adds behavioral data (attendance duration, questions asked) that’s very useful for engagement scoring. Eventbrite is more basic but sufficient to start enrichment.
Should I also enrich no-shows? Yes. Someone who registered but didn’t attend still expressed interest in the topic. Include them in a dedicated nurturing sequence — softer and more content-driven — rather than the direct follow-up sequence reserved for attendees.