The Scenario
You're the small-groups pastor for a congregation that runs quarterly cohorts. This quarter you've planned 15 weekly small-group meetings — different locations, different leaders, different times — and all of it is already documented in a Google Sheet a volunteer put together: meeting name in column A, start date-time in column B, location in column C, leader email in column E. The meetings need to exist in CHMeetings before leaders can start managing RSVPs and sending reminders through the platform.
The first time you tried doing this manually, it took 45 minutes for 8 meetings. You had the CHMeetings meeting creation form open, the sheet open, and you were reading and typing across both windows. Fifteen meetings would take most of a morning — and you're supposed to be reviewing sermon notes this morning.
The bad version:
- Open CHMeetings, navigate to Meetings, click New Meeting, fill in the name, set the date and time, enter the location, save, copy the meeting ID, paste it into the sheet, and repeat 14 more times.
- Mistype the date on meeting 6 because you're moving fast, discover the error only after the leader emails the wrong group.
- Finish the creation step, realize you still have to add each leader as an attendee separately — which is another form interaction per meeting.
This is the kind of task that exists entirely because data is in two systems that weren't designed to talk to each other. You're the translation layer.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the meeting schedule you've already built and creates the corresponding events in CHMeetings without you touching the platform's UI once.
Create a CHMeetings meeting for each row in this sheet using the name in column A, start date-time in column B, and location in column C — write the returned meeting ID into column D.
SheetXAI works through all 15 rows, creates each meeting in CHMeetings, and writes the returned meeting ID into column D. Then you can make a second ask to add the attendees:
For each meeting ID in column D, add the attendee whose email is in column E as an attendee in CHMeetings and mark the row "invited" in column F when done.
What You Get
- Column D fills with CHMeetings meeting IDs for every successfully created event.
- Column F marks "invited" for each row where the leader was successfully added as an attendee.
- Any row that fails — invalid date format, email not found in CHMeetings — gets flagged with an error description so you know exactly what to fix.
- Fifteen meetings created and leaders added in the time it used to take to do three.
What If the Data Is Not Quite Ready
The date-times in column B are inconsistent — some have AM/PM, some use 24-hour format
Normalize all date-times in column B to ISO 8601 format before creating CHMeetings meetings — then create a meeting for each row using name in column A, normalized start date-time, and location in column C, writing the returned meeting ID into column D.
A few rows in the sheet are placeholders with TBD in column B
Create CHMeetings meetings for all rows in this sheet where column B is not "TBD" — skip those rows and mark them "pending date" in column D, write meeting IDs for the rest.
You want to add multiple attendees per meeting — the leader in column E and a co-leader in column F
For each meeting ID in column D, add the emails in column E and column F as attendees in CHMeetings — skip any cell that is blank, and write "invited" into column G when both invites are sent or "partial" if only one went through.
Create all 15 meetings, fix date formats, add leaders, and tag each meeting with a group label from column G
Normalize date-times in column B to ISO 8601, create a CHMeetings meeting for each row using name in column A, normalized start date-time, and location in column C, update each created meeting to include the group tag from column G, add the leader email from column E as an attendee, and write the meeting ID into column D and "done" into column H when complete.
Schedule creation, attendee assignment, and tagging — one prompt, not four separate operations.
Try It
Open the Google Sheet where you've planned your small-group schedule and get the 7-day free trial of SheetXAI — create all your CHMeetings events and invite leaders without leaving the spreadsheet. Then see how to export attendance for reporting, or return to the CHMeetings integration overview.