Search API Connector Documentation


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.


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 Extensions > API Connector > Manage Connections.
  2. In the list of available connections, find “Google Calendar” and click Connect.

  3. You will be directed to 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:
  • 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

Now let’s grab that data.

  1. In API Connector, click Create, choose GET from the dropdown menu, and paste in the Request URL we created above.
  2. Choose ‘Google Calendar’ from the authentication dropdown.
  3. We don’t need any headers so just leave that section blank.
  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 URLs

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).

Events by date

Part 5: Technical Notes

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

Part 6: API Documentation

Official API documentation:

Previous Import Google Analytics Management Data to Google Sheets
Next Import Google Classroom Data to Google Sheets

Leave a Comment

Table of Contents