The Scenario
The annual board review is in two weeks, and someone from leadership just sent a message asking for a report on average Sunday service attendance over the last 8 weeks. You have the CHMeetings meeting IDs for those 8 services written down somewhere — you're fairly sure they're in an old tracking sheet — but the attendee data is inside CHMeetings, and getting it out means either clicking through 8 separate meeting records and writing down the counts, or figuring out whether CHMeetings has an export button that surfaces what you actually need.
This isn't analysis work. This is retrieval work. And it's the third time this quarter you've had to do it.
The bad version:
- Open CHMeetings, navigate to each meeting, open the attendees panel, count the names on screen (or scroll and count because there's no "total" displayed), write the number in a notepad.
- Go back to the sheet, find the row for that meeting, enter the count, move to the next meeting ID.
- Get to meeting 6 and realize you wrote the count for meeting 5 in meeting 6's row because you got turned around navigating back.
The report is going to a board that includes people who will ask follow-up questions. You'd rather have the data correct in the sheet than spend the meeting clarifying what you meant by "approximately."
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the meeting IDs already in the sheet and pulls the attendee data from CHMeetings directly, without you navigating the platform once.
For each meeting ID in column A, fetch the attendee count from CHMeetings and write it into column B, then compute the average attendance across all rows at the bottom of column B.
SheetXAI calls CHMeetings for each of the 8 meeting IDs, writes the attendee count per row, and adds the average at the bottom of the column. The board report now has a number, not a guess.
What You Get
- Column B fills with the attendee count for each service, matched to the meeting ID in column A.
- A computed average at the bottom of column B — you decide the label to put in column A for that row.
- If a meeting ID returns an error — because it was archived or the ID is wrong — that row gets flagged rather than silently returning zero.
- All 8 rows filled in less time than it takes to navigate to the first meeting in CHMeetings.
What If the Data Is Not Quite Ready
You also need the attendee names, not just counts, for one of the services
For the meeting ID in cell A3, fetch the full attendee list from CHMeetings and write each attendee's first name, last name, and email into Sheet2 — one row per attendee.
The meeting IDs in column A are mixed with some service names and some are blank
For each row in column A where the value starts with a number (indicating a CHMeetings meeting ID), fetch the attendee count from CHMeetings and write it into column B — leave blank rows blank and write "invalid" for any ID that returns an error.
You want to pull names and counts for all 8 meetings into one consolidated sheet
For each meeting ID in column A, fetch the attendee list from CHMeetings and append each attendee's name and email into Sheet2 with the meeting name from column B as a prefix column — so I can tell which service each row belongs to.
Pull attendee counts, compute the average, flag services that were below the 3-month average, and write the summary line the board asked for
For each meeting ID in column A, fetch the attendee count from CHMeetings and write it into column B, compute the average across all 8 rows and write it into B10 with the label "8-week average" in A10, then add "below average" in column C for any row where column B is less than the value in B10.
One prompt pulls the data, computes the summary, and adds the flag — the board report is ready.
Try It
Open the Google Sheet where you track service meeting IDs and get the 7-day free trial of SheetXAI — pull attendee counts from CHMeetings, compute the average, and flag outliers in one ask. Then see how to create CHMeetings meetings directly from a sheet schedule, or return to the CHMeetings integration overview.