API Connector Documentation

Print

Import Calendly Data to Google Sheets

Last Updated On
byAna
< Knowledge Base

In this guide, we’ll walk through how to pull data from the Calendly API directly into Google Sheets, using the API Connector add-on.

We'll first get an API token from Calendly, and then set up a request to pull in metrics to your spreadsheet.

Contents

Before You Begin

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

Part 1: Get Your Calendly API Token

  1. Log in to Calendly and navigate to Integrations > API and Connectors
  2. Click on API & Webhooks
  3. In the Personal access tokens tile, click Get a token now
    calendly-gettoken
  4. You'll be prompted to give your token a name. Do so, and click Create token
  5. You should now be presented with a token. Copy this and keep it safe as we'll need it shortly.
    calendly-copytoken

Part 2: Pull Calendly API Data into Sheets

You can create a request using any of the endpoints and parameters described in Calendly's documentation.

Example #1

For this first example, we'll fetch information about the current user (that's you).

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • Application: Custom
    • Method: GET
    • Request URL: https://api.calendly.com/users/me
    • OAuth: None
    • Headers:
      • Authorization: Bearer your_token
  3. Create a new tab and click Set current to use that tab as your data destination.
  4. Name your request and click Run. A moment later you’ll see some data populate your sheet.
    calendly-resourceUri
  5. Note the value in the resource.uri field as that's how Calendly identifies users. We'll need that for subsequent requests.

Example #2

For this next example, we'll fetch availability time. Substitute in your own token where it says your_token, and your own resource.uri where it says your_resource.uri

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • Application: Custom
    • Method: GET
    • Request URL: https://api.calendly.com/user_availability_schedules?user=your_resource.uri
    • OAuth: None
    • Headers:
      • Authorization: Bearer your_token
  3. Create a new tab and click Set current to use that tab as your data destination.
  4. Under Output options, switch to Grid style (not necessary but it's easier to read)
  5. Name your request and click Run. A moment later you’ll see your Calendly availability populate your sheet.
    calendly-availability

Part 3: API Documentation

Official API documentation: https://developer.calendly.com/api-docs/d7755e2f9e5fe-calendly-api

Leave a Comment

Jump To