< All Topics
Print

Importing Google Calendar Data

PostedFebruary 1, 2025
UpdatedFebruary 1, 2025
ByAnas Kakuwala

Importing Google Calendar Data into Google Sheets

This guide will walk through how to pull data from the Google Calendar API and put it directly into Google Sheets.
No API Key necessary. Use OAuth to seamlessly connect to Google Calendar via Phlorin’s built-in integration in Google Sheets

Getting Started

Install the API solution add-on from Google Marketplace.

Begin by connecting to Google Calendar Data

To request data from Google Analytics you must first connect your account with Phlorin. This can be done directly with Phlorin’s built in integration. Begin by opening up the Phlorin extension in Google Sheets.

1. In your desired Sheets document, open Phlorin and create a new request: Extensions > Phlorin > Open > Create a request

2. In the Application dropdown select or search for Google Calendar.

3. From here we will begin with Authorization. Click Connect to Google Calendar.

4. A new window will open and you will be asked to authorize the connection. Click Allow.

  1. After the connection is established you can return to Google Sheets to begin pulling data.

Pull Google Calendar Data into Google Sheets

While connected you can now use Phlorin to pull data seamlessly into Google Sheets. To do so we need to select an endpoint, path parameters, and body parameters.

1. For Endpoint, select “Get events” or “List available calendars”

2. Under Path parameters, type the email address associated with the calendar.

3. Optionally, you can select, body parameters. These are not required but are present if you want to redefine what/how the data is fetched.

4. Lastly, make sure your desired sheet is selected, name the report, and click Run.

Need help creating your request?

Reach out to us: Contact support or join our community forum.

Documentation

Google Calendar documentation: https://developers.google.com/calendar/api/guides/overview

Phlorin