Google Calendar auto-share

This Google Script automatically makes all calendar participants (event guests) editors of the calendar.

Setup

Follow these instructions to get this up and running with your own calendar.

Prerequisite

Set up a Google calendar to be used:

• For a new or existing calendar, open up "Settings and Sharing".
• Under "Integrate calendar", copy out the Calendar ID, you will need this later. Example:

[email protected]

Installing the script

You may install as a stand-alone script or attach it to a spreadsheet. If you plan to load calendar IDs from a spreadsheet you should probably attach the script using Tools -> Script Editor.

Stand-alone:

• Go to the Apps Script Console.
• Click the New Script button (top left).
• Paste in the contents of editoronly.gs
• Add your Calendar IDs to the calendarId array on line 22. Example:

var calendarId = '[email protected]';

SpreadSheet:

• Create a new SpreadSheet and copy the Sheet ID.
• Add your calendar IDs as shown here: https://goo.gl/W7TNXN
• Click Tools -> Script Editor
• Paste in the contents of editoronly.gs
• Add your Sheet ID on line 29. Example:

var sheetID = '1_GjhdyhD_dHTHTsT_kfyuA5og-329gkGSA76erresj';

Enable APIs

• In the script editor, click Resources -> Advanced Google Services.
• Click the sider to turn Calendar API on.
• Click on "Google API Console" at the bottom of the menu.
• In the new Window that opens click "Enable APIS and Services".
• Search for and click on "Google Calendar API".
• Click Enable.

Grant permissions & test

It is necessary to manually run the script once in order to grant permissions.

• From the script editor, click Run -> Run Function -> processCalendars.
• A popup should open asking you to grant permissions. Make sure to select the Google account that owns the calendar and the script if offered multiple.
• Done! You can View -> Logs to make sure your calendar guests were processed.

Automate!

You can automate the granting of permissions by setting up the script to run at a timed interval.

• Click File -> Current Project's Triggers.
• Add a new trigger.
• Enter processCalendars (or processCalendarsFromSheet), Time-driven, select your own interval.

Authors

• Caelan Borowiec - Initial work - CaelanBorowiec

Acknowledgments

• Uses David Bingham's shareCalendar function (with minor changes) from gCalUtils.js