The Scenario
The company restructured its meeting schedule for Q2. Thirty recurring check-in meetings were booked for the wrong team — wrong attendees, wrong cadence. The event IDs are in a Google Sheet. The events need to be cancelled and the attendees notified. The event coordinator who originally set them up left the company last Friday.
You have the sheet. You have access to the calendar. You don't have three hours.
The bad version:
- Open Outlook calendar, search for the first event ID (which means searching by title because Outlook's calendar search doesn't accept raw event IDs)
- Find it, click Cancel Meeting, add a cancellation note, send the cancellation to all attendees
- Repeat 29 more times
- Discover that two of the events were recurring series and cancelling one instance didn't cancel the whole series
These meetings are already documented. The IDs are in the sheet. The only thing standing between the current state and a clean calendar is 30 repetitions of the same manual sequence.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the event IDs from your sheet and cancels each one through Outlook — notifications included.
Cancel the Outlook calendar events for all event IDs in column A of this sheet and send cancellation notifications to all attendees — process all 30 at once
What You Get
- Each event cancelled in Outlook with a cancellation notification dispatched to all attendees
- Column B written with "Cancelled" for each successful cancellation and "Failed — [reason]" for any that don't process
- A sidebar summary with a total count of cancelled and failed events
What If the Data Is Not Quite Ready
You want to update the location field instead of cancelling
Update the location to 'Microsoft Teams' for all Outlook event IDs in column A using the Teams link in column B as the online meeting URL — write the update status in column C
Some events are recurring series and you want to cancel all future instances, not just one
Cancel all future instances of the recurring Outlook calendar events for event IDs in column A — send cancellation notifications to all attendees for each series — write the status in column B
You only want to cancel events that haven't already occurred
For each event ID in column A, cancel the Outlook event only if the start datetime is in the future — skip past events and write "Past — skipped" in column B for those rows, "Cancelled" for events successfully cancelled
Filter out past events, cancel all future ones, and send a rescheduling note in the cancellation
Cancel all Outlook events in column A that have a future start date — include a cancellation note that says "This meeting has been cancelled. A replacement will be scheduled separately." — skip past events, log status in column B
One prompt filters and cancels with a custom message.
Try It
Get the 7-day free trial of SheetXAI and open your event ID sheet, then ask SheetXAI to cancel or update the calendar events in Outlook. See also: Bulk create Outlook calendar events from a sheet and the Outlook hub overview.