The Scenario
An executive assistant manages fifteen recurring client calls a month for three senior partners. Each call has a topic, a start time, and a duration in minutes — all maintained in a Google Sheet that's been the system of record for scheduling since the assistant joined two years ago.
New quarter, new partner. The incoming partner wants all their calls in Zoom immediately. The assistant has the sheet. She does not want to create fifteen Zoom meetings by hand.
The last time she did this — at the start of Q3, for a different partner — it took an hour and a half. She had to create each meeting individually, copy the join URL, paste it into a Notion page, then send the URLs to the partner's chief of staff. She made two timezone errors.
The bad version:
- Open Zoom. Click "Schedule a Meeting." Fill in the topic from row 1, the date and time from row 1, the duration from row 1. Click save. Copy the join URL. Paste it into the sheet.
- Repeat fourteen more times.
- Realize that four of the meetings are in the wrong timezone because Zoom defaulted to your local timezone, not the partner's.
Fifteen meetings, fifteen copy-paste operations, four timezone corrections. That's not a scheduling system. That's a data entry job.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the topic, start time, and duration columns, and through its built-in Zoom integration it creates each meeting and writes the join URL back to the sheet.
Create a Zoom meeting for each row using the topic in column A, start time in column B, and duration in minutes from column C, then write the meeting ID to column D and the join URL to column E
What You Get
- All fifteen meetings created in Zoom in one pass.
- Meeting IDs written to column D, join URLs to column E — no manual copy-pasting.
- Start times are taken exactly as they appear in the sheet, including timezone if formatted with one.
- Rows that fail (malformed time, missing topic) get an error in column D so you can spot and fix them.
What If the Data Is Not Quite Ready
Start times are stored as dates in one column and times in another
For each row in this sheet, create a Zoom meeting with the topic from column A and a start time constructed by combining the date in column B with the time in column C. Use the duration from column D in minutes. Write the meeting ID to column E and the join URL to column F.
Some meetings already have a join URL in column E — skip those rows
For each row in this sheet where column E is blank, create a Zoom meeting using the topic from column A, start time from column B, and duration from column C. Write the meeting ID to column D and join URL to column E. Skip rows that already have a value in column E.
Topics need a standard prefix added before Zoom sees them
For each row in this sheet, create a Zoom meeting with the topic formatted as 'Partner Call — ' followed by the value in column A. Use the start time from column B and duration from column C. Write the meeting ID to column D and join URL to column E.
Create all meetings, then build a summary email draft in one pass
For each row in this sheet, create a Zoom meeting using the topic in column A, start time in column B, and duration in column C. Write the meeting ID to column D and join URL to column E. After all meetings are created, generate a plain-text summary of all 15 meetings (topic, date/time, join URL) formatted as an email I can send to the partner's chief of staff, and write it to cell G1.
Meeting creation and communication prep, one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your scheduling Google Sheet, then ask it to create all the Zoom meetings at once. For cancelling a batch of meetings instead, see the spoke on bulk-cancelling Zoom meetings, or the hub overview on all the ways to connect Zoom to Google Sheets.