Import Vimeo Data to Google Sheets

Vimeo is a popular site for hosting and watching videos. 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. From the Create Request screen in API Connector, click Manage connections.
    quickbooks-img1
  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

We can now enter our values into API Connector and start importing Vimeo data into Google Sheets.

  1. Open up Google Sheets and click Add-ons > API Connector > Create New API Request.
  2. Choose Vimeo from the Connections dropdown.
    vimeo-img5
  3. In the Create Request interface, enter the Request URL we just created.
    vimeo-img6
  4. We don’t need any headers for this API, so just leave that section blank.
  5. Create a new tab. You can call it whatever you like. Click ‘Set’ to use that tab as your data destination.
  6. 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