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).
- 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.
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.
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
- Comments on a video