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.

Contents

• Before You Begin
• Part 1: Connect to the Vimeo API
• Part 2: Create a Vimeo API Request URL
• Part 3: Pull Vimeo API Data into Sheets
• Part 4: More Example API URLs
• Part 5: Handle Pagination
• Part 6: API Documentation

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 Extensions > API Connector > Manage Connections.
2. In the list of available connections, find Vimeo and click Connect.
   
3. You will be directed to Vimeo and asked to authorize the connection. Click Allow.
   
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.
   
2. Under OAuth, choose Vimeo from the dropdown menu. You should see a “Connected” badge.
   
3. We don’t need any headers for this API, so just leave that section blank.
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.
   

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

Part 5: Handle Pagination

Vimeo limits the number of records returned in each request. By default, only 25 records will be returned unless you use the ‘page’ and ‘per_page’ parameters as described in their documentation.

To get more records, set the per_page parameter to 100, e.g. https://api.vimeo.com/users?query=bluebird&per_page=100. Vimeo returns the next page of results in the API response, so if you need more than 100 records, set up pagination handling like this:

• Pagination type: next page URL
• Next page path: paging.next
• Run until: choose when to stop fetching data
  

Part 6: API Documentation

Official API documentation: https://developer.vimeo.com/api/reference/