The Scenario
The demand gen team ran five webinars last quarter. There's now a Salesforce import due — the CRM team needs a master registrant list: webinar topic, registrant name, email, and registration status, all in one Google Sheet, deduplicated by email.
The demand gen manager has the five webinar IDs in a sheet. She ran the first export herself, from Zoom's webinar reporting UI, downloaded the CSV, opened it, copy-pasted it in. Then she realized she needed to add a "webinar topic" column to identify which event each registrant came from, because the Zoom export doesn't include that.
She's on webinar three when a colleague mentions that three people registered for multiple webinars and will show up as duplicates in Salesforce. Now she needs to deduplicate before the import.
It's a two-hour job she didn't budget for this week.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the webinar IDs, pulls the registrant list from each through its built-in Zoom integration, and consolidates them — no manual exports, no manual dedup.
For each webinar ID in column A, fetch all approved registrants from Zoom and append their first name, last name, email, and status to this sheet, then deduplicate by email keeping the first occurrence
What You Get
- A single flat registrant list with all registrants from all five webinars.
- Duplicates resolved by email — each person appears once.
- Registration status ("approved," "pending") included per registrant.
- The sheet is ready for CRM import without manual cleanup.
What If the Data Is Not Quite Ready
You need the webinar topic column included so Salesforce knows which event each lead came from
For each webinar ID in column A, fetch the webinar topic and all approved registrants from Zoom. Append each registrant as a row with columns: WebinarTopic, FirstName, LastName, Email, Status. After all five webinars are processed, deduplicate by Email, keeping the first occurrence.
Some webinar IDs in column A belong to the previous quarter and should be excluded
Column A has webinar IDs and column B has the quarter label (Q1 or Q2). Only fetch registrants for rows where column B says Q2, append results with WebinarTopic, FirstName, LastName, Email, Status, then deduplicate by Email
You want pending registrants separated from approved ones
For each webinar ID in column A, fetch all registrants from Zoom. Write approved registrants to the 'Approved' tab and pending registrants to the 'Pending Review' tab, with columns for WebinarTopic, FirstName, LastName, Email on both tabs. Deduplicate each tab by Email.
Pull, deduplicate, and add a registration count column for leads who registered to multiple webinars
For each webinar ID in column A, fetch all approved registrants from Zoom and collect the full list. After pulling all five, write the deduplicated master list to the 'Master' tab with FirstName, LastName, Email, and a RegistrationCount column showing how many different webinars that email appeared in. Sort by RegistrationCount descending.
That last one is your high-intent lead list — the people who registered for more than one webinar. One prompt gets you there.
Try It
Get the 7-day free trial of SheetXAI and open your webinar ID Google Sheet, then ask it to pull and consolidate all registrants from Zoom. For pulling participant attendance data instead of registrant data, see the spoke on exporting webinar participants for post-event analysis, or the hub overview on all the ways to connect Zoom to Google Sheets.