The Scenario
The customer education team just finished Q2. Four product webinars over the quarter. Now the lead scoring team wants a combined participant list — name, email, join time, and time in session — for every attendee across all four events.
The education lead has been handed a Notion doc with four webinar IDs and a deadline of EOD.
She's done this before. She knows what's coming.
The bad version:
- Log into Zoom. Navigate to the first webinar in the past webinars list. Export participants as CSV. Open the CSV. Note that Zoom's export calls the column "Attended" not "Join Time" and uses a different date format than the CRM expects.
- Paste into a master sheet. Rename the columns. Repeat three more times.
- Discover that twelve attendees joined multiple webinars and will appear in the combined list multiple times. Manually identify and remove duplicates.
- Sort by total time attended to produce the prioritized list the lead scoring team actually wants.
Four exports, four column renames, one dedup pass, one sort. It's not complicated. It's just a lot of identical work.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the webinar IDs, pulls participant data from each through its built-in Zoom integration, and consolidates them in one pass.
For each webinar ID in column A, fetch all past Zoom webinar participants and append their name, email, join time, and time in session to this sheet. After all four are processed, deduplicate by email and sort by total time attended descending.
What You Get
- One flat participant list with all attendees from all four webinars.
- Duplicates resolved by email — multi-event attendees appear once.
- Sorted by total time attended, descending — your highest-engagement leads at the top.
- Ready for lead scoring import without any manual reformatting.
What If the Data Is Not Quite Ready
You need to track which webinar each attendee came from, even after dedup
For each webinar ID in column A, fetch participants and track which webinar IDs each person attended. After pulling all four, write one row per unique email with columns: Name, Email, WebinarCount, WebinarIDs, TotalMinutes. Sort by TotalMinutes descending.
Some attendees registered but didn't actually join — filter them out
For each webinar ID in column A, fetch past participants (people who actually joined, not just registrants). Append name, email, join time, and minutes attended. Deduplicate by email and remove anyone with 0 minutes attended.
The lead scoring team needs the data split: high-engagement (30+ min) vs. low-engagement
For each webinar ID in column A, fetch past participants and collect name, email, and minutes attended. After all four are processed, deduplicate by email. Write attendees with 30 or more minutes to the 'High Engagement' tab and everyone else to the 'Low Engagement' tab. Sort each tab by minutes attended descending.
Full lead scoring output: pull, deduplicate, score, and flag SQLs in one pass
For each webinar ID in column A, fetch past participants (name, email, join time, minutes attended). Deduplicate by email after all four are processed. Add a LeadScore column: 3 points for each webinar attended, plus 2 bonus points if total minutes attended exceeds 60. Mark anyone with 9 or more points as 'SQL' in a FlagColumn. Sort by LeadScore descending.
That's your sales handoff list, ready to share. One prompt built it.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet with your webinar IDs, then ask it to pull and consolidate all participant data from Zoom. For pulling registrant data rather than participant data, see the spoke on exporting webinar registrants across multiple webinars, or the hub overview on all the ways to connect Zoom to Google Sheets.