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 (this is a paid feature, please install API Connector for a free 7-day trial or upgrade to access).
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
BEFORE YOU BEGIN
Click here to install the API Connector add-on from the Google Marketplace.
PART 1: CONNECT TO THE VIMEO API
- In Google Sheets, click Add-ons > API Connector > Manage Connections.
- In the list of available connections, find Vimeo and click Connect.
- You will be directed to Vimeo and asked to authorize the connection. Click Allow.
- 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 enter our URL into API Connector and import Vimeo data into Google Sheets.
- In API Connector, click on the Create tab and enter the Request URL we just created.
- We don’t need any headers for this API, so just leave that section blank.
- Choose Vimeo from the Connections dropdown.
- Create a new tab and click ‘Set current’ to use that tab as your data destination.
- 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