Google Calendar

Google Sheets + Google Calendar Integration

Query from Google Calendar into Google Sheets  or Post data from Google Sheets into Google Calendar or Synchronize data between Google Sheets & Google Calendar

What is Sheet Director?

Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho etc. 


It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on. 

What is Google Calendar?

Google Calendar is a time-management and scheduling calendar service developed by Google 

Google Calendar suggests meeting times and integrates seamlessly with Gmail. 

Shareable calendars designed for teams.

Google Calendar to Google Sheets: Use Case(s)

> Get Events: Query and pull Calendar Events from Google Calendar into Google Sheets

> Post Events: Post Google Sheet data into Google Calendar to create Calendar Events

> Synchronize Events: Synchronize data between Google Sheet and Google Calendar.

Google Calendar

Sheet Director

Google Sheets

Demo Video: How to Integrate Google Sheets & Google Calendar?

Google Calendar to Google Sheet - Query

Choose App and Service:


Google Calendar Configuration:

                         (Or)

The values of macros are as follows

Select any of the required value so that the selected data will be displayed in the destination spreadsheet.

Filters & Sorting

Destination Settings:

Scheduler Settings:

Notification Settings:

Sample Output

Google Sheet to Google Calendar - Post

Select Calendar

Source Sheet

(the default value is A1, if you change the value you need to refresh the header by clicking on refresh icon on side)




Mapping

Sample Output

It will show the count of number of records posted successfully and failed to post.

Synchronize Events


Synchronize settings:

Synchronization Keys:

The keys will be used for matching rows in Google Sheet with data in Google Calendar.

Conflict Resolution: 

Google Calendar Wins: Latest data from Google Calendar will be updated into Google Sheet.

Sheet Wins: Latest data from Google Sheet will be updated into Google Calendar.

Note: The major requirement in synchronization is the synchronize keys. If any of the keys is not having a value in the Google Sheet then Sheet Director will create it first and then the service will be executed.

Google Calendar Wins

Sample Output

Sheet Wins

Sample Output