GAS – Send Event to Calendar from Spreadsheet

Managing a Google Calendar from a spreadsheet is fairly straight-forward.
You do need the calendar ID and all your ducks lined up on the sheet.

in it’s simplest form:

Courtesy of Mogsdad on Stack Overflow for the basis of the code

Using the columns:


Date || StartTime || StopTime || Title || Location || Description || Event ID

This script works by the user selecting a row which contains the data they wish to update, then pulling the script from a custom menu.
The script will also check if an Event ID is present (e.g. if event is already on the calendar) and if so will delete the event on the calendar and replace it with the spreadsheet version.

Leave a Reply

Your email address will not be published. Required fields are marked *