Tuesday, 2 March 2021

Bulk create Google Calendar events with optional Meet or Zoom - overview

The following Google Apps Script tool is designed to bulk create Google Calendar events with optional video conferencing (Google Meet or Zoom). It is an enhanced version of this blog post for creating events with optional Google Meet. As it now includes Zoom there are a number of extra steps such as additionally setting up a Zoom Marketplace App.

The tool is run entirely from a Google Sheet and the details of each event is added per row, from which the tool plugs in to Google Calendar and bulk creates the events for you. The outcome is the standard Calendar event item that can then be edited just like any other.

Google Sheet columns allow for event details to be added.
Google Sheet columns allow for event details to be added.

Features of the tool

  • Performs an initial check that you have access to the provided Calendar to create events on.
  • Allows for events to be created on another Calendar that you have suitable access to (not just your own).
  • Uses toast popups to inform you of the progress as each creates each event per row.
  • Fast and efficient for creating a large number of events in one go.
  • Will not duplicate events if re-run, so you can continue to append further if you wish.
  • Provides a direct link to the created event from within the Google Sheet for easy access.
  • Performs a check of any missing 'required' information and informs the user via a popup so they can resolve this.
  • Includes 'Log' sheet to help output any error messages.
  • Has a 'Reset' option in the menu bar to remove all entered data and start from scratch.
  • Replicates 90%+ of the settings you can adjust when directly creating an event in Google Calendar.


Caveats of the tool

  • You can create up to 100 Zoom meetings within a given 24-hour period. This limit is imposed by Zoom and resets at 00:00 UTC.
  • The tool currently uses the default ‘Event notifications’ set up for the calendar you want to create the events on.
  • Currently this is a tool for bulk creating events and cannot yet bulk delete them. You can delete the events in the normal way that you would through Google Calendar and there will be a direct link to it within the Google Sheet upon its creation.
  • Currently you cannot create ‘All day’ events - you must specify a start/end date/time.


Instructions

Use these instructions to create the Zoom OAuth App. A couple of points about the one I created:

  • It is a user-managed app, meaning it is installed and authorised by users individually.
  • Turned off 'Event Subscriptions'.
Back in the Google Sheet itself just follow the steps on the 'Welcome' sheet. I have also included a video below to help get you started:

 

File Download

Download the Bulk create Google Calendar events with optional Meet or Zoom here. Please use 'File' > 'Make a copy' for your own version.


The Code

Click here for the blog post containing the code.

3 comments:

  1. Hi, thanks a bunch, thanks for sharing. I was wondering if you try to upload like 5000 events will hit an API limit ?

    ReplyDelete
    Replies
    1. Hi Antony

      Thank you. Yes there are API limits to be aware of: https://developers.google.com/apps-script/guides/services/quotas

      Kind regards
      Phil

      Delete