The Scenario
You're a sales enablement manager. The product demo ran last Tuesday. Two hundred people registered. A hundred and twenty showed up. The SDR team has eighty slots this week for outbound calls and they want the no-shows first — those are the contacts who were interested enough to register but didn't attend, which your team treats as the warmest re-engagement targets.
You inherited this process from someone who left the company three months ago. The sheet exists. The methodology exists. What doesn't exist is a clean way to build the report.
The bad version:
- You export the registrant list from Demio as one CSV and the participant list as a second CSV.
- You open both in separate tabs, write a VLOOKUP to match registrants to attendees by email, mark matched rows as "Attended" and unmatched as "No-Show," and realize partway through that the email formatting is inconsistent between the two exports — some are lowercase, some aren't.
- You spend twenty minutes normalizing the email column, re-run the VLOOKUP, find three rows where the formula broke, fix them manually, then format the sheet so the SDR team can actually read it.
The report is correct. It took two hours and involved four error-prone manual steps. The SDRs needed it yesterday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your existing data, connects to Demio, and builds the comparison report you describe — in one prompt, with the conditional logic included.
List all participants for my most recent Demio event session and write name, email, and attended (true/false) into the 'AttendanceReport' sheet, flagging rows where attended is false as 'No-Show' in column D
What You Get
- One row per registrant in the AttendanceReport sheet.
- Name in column A, email in column B, attended (true/false) in column C.
- Column D shows "No-Show" for every contact where attended is false.
- The report is ready to sort, filter, or hand to the SDR team as-is.
What If the Data Is Not Quite Ready
You also want watch duration so SDRs can tier their outreach
Pull all participants for my most recent Demio event session into the 'AttendanceReport' sheet: name in column A, email in B, join time in C, watch duration in minutes in D, and no-show in column E (true if watch duration is 0)
The SDR team can sort by column D to tier their calls — reached the halfway point versus never logged in at all.
You want to cross-reference against your existing lead-stage column
I have a 'Registrants' tab with name in column A, email in B, and lead stage in column C. Pull the participant list from my most recent Demio session and add an 'Attended' column (D) and a 'No-Show' column (E) to the Registrants tab, matching by email
SheetXAI joins the session data to your existing registrant sheet so you keep the lead-stage context without rebuilding the sheet from scratch.
Emails are in inconsistent formats between your sheet and Demio's export
Compare my 'Registrants' tab (email in column B) to the participant list from my most recent Demio session. Match case-insensitively. Write 'Attended' or 'No-Show' into column D for each registrant.
The case normalization happens in the matching logic, not as a separate step you have to do first.
Full re-engagement report in a single pass
Pull all registrants and participants for my most recent Demio event session. Write name, email, watch duration in minutes, and no-show status into the 'AttendanceReport' sheet. Sort by no-show descending so the no-shows appear first, then by watch duration ascending within the attendees. Add a 'Priority' column: 'High' for no-shows, 'Med' for attendees under 10 minutes, 'Low' for attendees over 10 minutes.
The report is built, sorted, and prioritized in one prompt. The SDR team opens the sheet and starts calling.
Combining the pull, the comparison, the flagging, and the sort in one prompt means you're not doing cleanup between steps.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet you use for post-webinar reporting, then ask it to build an attendance-vs-registrant report from your most recent Demio session and flag no-shows automatically. You can also bulk-register the re-engagement list for your next session without leaving the sheet.