Google Calendar Toolbox

The complete toolbox for handling Google Calendar events in batchGoogle Calendar Toolbox allow you to modify event titles, copy/move/duplicate events, change their color or delete any number of events in your calendars.

Tutorial

To use this tool make a copy of this template.

The application needs to be authorized for both the calendar service and the calendar API used in the library (using an oAuth2 setup), we provide an install menu that will make this install process as easy as possible. To install the script use the install menu to start the authorization process.

Right after that you can run the second item that will personalize your spreadsheet by including data validation on the calendar selection cell.

From there you can start to use all the available functions.

The menu gives access to all functions :

Even if the menu items don't need a lot of explanation, let us give you some tips :

• 1. The first things to do is to define the start and end dates and the calendar name you want to work with.

  2. Select the events you want to modify in the list by adding a x or a X in column I (the smallest column on the right)

  3. Choose the action with the menu, some function will trigger a popup window that will ask for some options/choices

  4. Wait until a popup at the bottom of the main page shows the result. Each selected event in the main sheet will be colorized while processing so you can see the operation progress.

Example : to change the color of individual events, select them in the list, choose the item Change color of selected events , a popup will show up

Click on the apply button and you're done !