Search API Connector Documentation


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.


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:
  • Endpoint: /me

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

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
  • Get your followers
  • Query for a string
  • Get your watch history
  • Video categories
  • Videos in a category{category}/videos
  • Comments on a video{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. 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:
  • Run until: choose when to stop fetching data

Part 6: API Documentation

Official API documentation:

Previous Import Udemy Data to Google Sheets
Next Import Visual Website Optimizer (VWO) Data to Google Sheets

Leave a Comment

Table of Contents