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.

CONTENTS

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

  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