Import Google Calendar Data to Google Sheets

In this guide, we’ll walk through how to pull Google Calendar API data data directly into Google Sheets, using the API Connector add-on for Sheets. We’ll be connecting using API Connector’s built-in OAuth2 integration for Google Calendar. This is a paid feature; please install API Connector for a free trial or upgrade to access.

CONTENTS

• What Does This Integration Do?
• Before You Begin
• Part 1: Connect to the Google Calendar API
• Part 2: Create your Google Calendar API Request
• Part 3: Pull Google Calendar API Data into Sheets
• Part 4: More Example API Requests

WHAT DOES THIS INTEGRATION DO?

This integration connects the Google Calendar API to Google Sheets. It enables the following scopes:
https://www.googleapis.com/auth/calendar.readonly : See and download any calendar you can access using your Google Calendar
https://www.googleapis.com/auth/calendar.events.readonly : View events on all your calendars
https://www.googleapis.com/auth/calendar.settings.readonly : View your Calendar settings

BEFORE YOU BEGIN

Click here to install the API Connector add-on from the Google Marketplace.

PART 1: CONNECT TO THE GOOGLE CALENDAR API

If you haven’t connected API Connector to Google Calendar before, you’ll first need to initiate the connection as follows:

1. Open up Google Sheets and click Add-ons > API Connector > Manage Connections.
2. In the list of available connections, find “Google Calendar” and click Connect.
   
   
   
3. You will be directed to google.com and asked to allow API Connector to access your calendars. Click Allow.
   
4. You’ll then be returned to your Google Sheet, and can verify that your Google Calendar connection is active in the Connections screen.
   
   

PART 2: CREATE YOUR GOOGLE CALENDAR API REQUEST URL

We’ll first pull in a list of the calendars you have access to.

• API root: https://www.googleapis.com
• Endpoint: /calendar/v3/users/me/calendarList

Putting it together, we get the full API Request URL:

https://www.googleapis.com/calendar/v3/users/me/calendarList

PART 3: PULL GOOGLE CALENDAR API DATA INTO SHEETS

We can now enter our values into API Connector and start importing Google Calendar data into Google Sheets.

1. In API Connector, click Create, choose GET from the dropdown menu, and paste in the Request URL we created above.
   
   
2. We don’t need any headers so just leave that section blank.
   
3. Choose ‘Google Calendar’ from the authentication dropdown.
   
   
4. Create a new tab and click ‘Set current’ to use that tab as your data destination.
   
5. Name your request and click Run. A moment later you’ll see a list of your calendars populate your sheet.
   

PART 4: MORE EXAMPLE API REQUESTS

To see the full list of available endpoints, please check the official documentation. You can also try the following:

Events:

https://www.googleapis.com/calendar/v3/calendars/primary/events

Note: For this request, open Output Options and choose ‘compact’ or ‘grid’ style for your report (the default ‘single row’ style will print your events into separate columns instead of separate rows).