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.
- 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
- Open up Google Sheets and click Add-ons > API Connector > Manage Connections.
- In the list of available connections, find “Google Calendar” and click Connect.
- You will be directed to google.com and asked to allow API Connector to access your calendars. Click Allow.
- 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:
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.
- In API Connector, click Create, choose GET from the dropdown menu, and paste in the Request URL we created above.
- We don’t need any headers so just leave that section blank.
- Choose ‘Google Calendar’ from the authentication dropdown.
- Create a new tab and click ‘Set current’ to use that tab as your data destination.
- 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:
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).