Search API Connector Documentation

Print

Import Vimeo Data to Google Sheets

In this guide, we’ll walk through how to pull video data directly into Google Sheets, using the API Connector add-on for Sheets. Vimeo’s API only supports authentication via OAuth2, so we’ll be connecting using API Connector’s built-in OAuth2 integration for Vimeo (this is a paid feature, please install API Connector for a free 7-day trial or upgrade to access).

CONTENTS

BEFORE YOU BEGIN

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

PART 1: CONNECT TO THE VIMEO API

  1. In Google Sheets, click Add-ons > API Connector > Manage Connections.
  2. In the list of available connections, find Vimeo and click Connect.
    vimeo-img1
  3. You will be directed to Vimeo and asked to authorize the connection. Click Allow.
    vimeo-img3
  4. You’ll now be returned to your Google Sheet, and can verify that your Vimeo connection is active in the Connections screen.
    vimeo-img4

PART 2: CREATE A VIMEO API REQUEST URL

We’ll first get some basic information about your Vimeo account.

  • API root: https://api.vimeo.com
  • Endpoint: /me

Putting it together, we get the full API Request URL.

https://api.vimeo.com/me

PART 3: PULL VIMEO API DATA INTO SHEETS

Now let’s enter our URL into API Connector and import Vimeo data into Google Sheets.

  1. In API Connector, click on the Create tab and enter the Request URL we just created.
    vimeo-img6
  2. We don’t need any headers for this API, so just leave that section blank.
  3. Choose Vimeo from the Connections dropdown.
    vimeo-img5
  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 some information about your account populate your sheet.
    vimeo-img7

PART 4: MORE EXAMPLE API URLS

You can access the full API documentation here, but if you just want to get started, you can try the following URLs (one at a time).

  • Videos in your feed
    https://api.vimeo.com/me/feed
  • Get your followers
    https://api.vimeo.com/me/followers
  • Query for a string
    https://api.vimeo.com/users?query=bluebird
  • Get your watch history
    https://api.vimeo.com/me/watched/videos
  • Video categories
    https://api.vimeo.com/categories
  • Videos in a category
    https://api.vimeo.com/categories/{category}/videos
  • Comments on a video
    https://api.vimeo.com/videos/{video_id}/comments

Leave a Comment