Search API Connector Documentation

Print

Import Vimeo Data to Google Sheets

premium

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

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.

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 grab that Vimeo data!

  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
Previous Import Udemy Data to Google Sheets
Next Import Visual Website Optimizer (VWO) Data to Google Sheets

Leave a Comment

Table of Contents