Import Vimeo Data to Google Sheets
Vimeo is a popular site for hosting and watching videos. 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.
- 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
- From the Create Request screen in API Connector, click 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.
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.
We can now enter our values into API Connector and start importing Vimeo data into Google Sheets.
- Open up Google Sheets and click Add-ons > API Connector > Create New API Request.
- Choose Vimeo from the Connections dropdown.
- In the Create Request interface, enter the Request URL we just created.
- We don’t need any headers for this API, so just leave that section blank.
- Create a new tab. You can call it whatever you like. Click ‘Set’ 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