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
- 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/mePart 3: Pull Vimeo API Data into Sheets
Now let’s grab that Vimeo data!
- 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