Search API Connector Documentation

Print

Import Google Calendar Data to Google Sheets

premium

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.

Contents

Before You Begin

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

Part 1: Connect to the Google Calendar API

The easiest way to get started with the Google Calendar API is through API Connector's built-in integration.

  1. Select Google Calendar from the drop-down list of applications
    googlecalendar-application
  2. Under Authorization, click Connect to Google Calendar
    googlecalendar-authorization
  3. You will be directed to google.com and asked to allow API Connector to access your calendars. Click Allow.
    google-calendar-img2
  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: Pull Data from Google Calendar to Sheets

Now that we’re connected, let’s pull some data into Sheets.

  1. Select the /calendars/{calendar_id}/events endpoint, , which allows us to retrieve the events on our calendars
    googlecalendar-endpoints
  2. Under the calendar_id parameter, enter the word primary. This will fetch data from your primary calendar (if you prefer to fetch data from a different calendar, enter the email address associated with that calendar, e.g. [email protected])
    googlecalendar-parameters
  3. Optionally populate other request parameters to customize your request, e.g. date ranges and keyword searches.
  4. Choose a destination sheet, name your request, and hit Run. A moment later you’ll see the response data in your sheet.
    googlecalendar-response

Part 3: Create a Custom Request

Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration, using any of the endpoints and parameters shown in the API documentation. Here's an example setup:

  • ApplicationCustom
  • MethodGET
  • Request URL: https://www.googleapis.com/calendar/v3/calendars/primary/events?timeMax=2022-07-20T07:00:00:000Z&timeMin=2022-01-01T00:00:00:000Z
  • OAuth: Google Calendar


googlecalendar-custom

Part 4: API Documentation

Official API documentation: https://developers.google.com/calendar/api

3 thoughts on “Import Google Calendar Data to Google Sheets”

  1. I'm trying to import two specific calendars into Google sheets. Under request parameters, I do not have the calendar_id field.

    When I attempt to run, I get the following error:
    1) : Completed with errors
    - We received an error from googleapis.com (403) show response

    Reply

Leave a Comment

Jump To...