Turn rows of a Google Sheets™ spreadsheet into Google Calendar™ events — hundreds at a time.

Write your schedule the way you already do, in a spreadsheet. Then create every event in one run, update them when the sheet changes, and import existing events back into the sheet when you need to edit them in bulk.

WHAT IT DOES

• Bulk create Google Calendar™ events from Google Sheets™ rows
• Update events when you change the sheet, matched exactly — not guessed by title or date
• Delete events from the sheet
• Import Google Calendar™ events into Google Sheets™ for a date range, then edit and sync back

BUILT FOR LARGE SHEETS

A thousand rows is a normal job, not an edge case. Work is processed in resumable batches with a visible progress bar, so a long run does not time out and does not leave you wondering whether it finished. If it is interrupted, it picks up where it stopped.

Rate limits from Google are retried automatically with backoff, so a large run completes instead of silently dropping events partway through.

NO DUPLICATES, EVER

Every event this add-on creates is recorded against its row in a hidden column. Run it again and the rows that already have an event are skipped, not recreated. If some rows failed, running it again retries only those rows.

SEE WHAT WILL HAPPEN, BEFORE IT HAPPENS

Preview counts exactly how many events will be created, updated or skipped, and shows which rows it could not read, by row number — without touching your calendar. The preview is free and unlimited, whatever the size of your sheet.

IT WILL NOT GUESS YOUR DATES

03/04 could be March 4th or April 3rd. Rather than pick one and silently create a wrong event, the add-on reports that row and leaves it alone. Both 24-hour and AM/PM times are accepted, and all-day events use the end date you actually wrote, not the day after.

If your spreadsheet's time zone differs from your calendar's, you are told before you run — not after every event lands an hour off.

PERMISSIONS, KEPT NARROW

• It can only read the one spreadsheet you open it in. It cannot see any other file in your Google Drive™.
• It does not request permission to share or delete entire calendars.
• We run no server of our own. Your spreadsheet rows and calendar events never leave your Google account. The only outbound request the add-on ever makes is to verify a Pro licence key with Gumroad, and it sends nothing but that key and the product ID.

PRICING

Free: unlimited preview, and up to 100 events written per day. The daily allowance resets every day, and if a job stops at the limit, running it again the next day continues where it stopped — rows already created are never created twice.
Pro: $19 USD, one payment, no subscription. Unlimited writes.

NOT IN THIS VERSION

Recurring events and automatic Google Meet™ links are not supported yet.

Google Sheets™, Google Calendar™, Google Drive™ and Google Meet™ are trademarks of Google LLC. CalBatch is not affiliated with or endorsed by Google LLC.