Automate sync from Google Sheet to Google Agenda

Syncing a google sheet to your agenda can be useful and time-saving if you have a lot of events to add to the agenda at once. All can be done with google’s tools.

Here are the 4 simples steps that will have to do :

1. Create your spreadsheet in Google Sheets and add your events
2. Create a new Agenda
3. Create a script in Google Apps Script
4. Execute the script to synchronise

Format Google Sheets

Here is the format I will use :

Of course, you can have both the date and the time in the same cells, for example, “Wednesday, 1 December 2021 at 10:00:00”. Or maybe you don’t need to have a start time and end time, because your event is a full days event. We will just need to tweak a little the script depending on your needs.

Small tip, here is where you can choose the dates and times formats.