Tools

(internal)

sheet2cal

sheet2cal is a Google Sheet file combined with a very simple Google App Script file. The idea is that you can add multiple events specifying the starting/ending date, title and the calendar. You can copy the Sheet using this link.

There are two main commands (in the top bar):

• Events > Create calendar events: this creates all the calendar events specified in the Google Sheet. Be careful that running the script twice will create duplicate events. In any case no events will be deleted.
• Events > get all calendars: this return a list of all your calendars. In the calendar column you have to specify ID of the target calendar.