When it comes to getting information about movies and TV series, there are a few better places to go to than Internet Movie Database, more popularly known by its abbreviation, IMDb.
Here in this article, we’re going to learn how to import IMDb data to Google Sheets using Amigo Data, a Google Sheets extension that lets us import all kinds of data into Google Sheets.
Steps to import IMDb data to Google Sheets.
- Install the Amigo Data add-on
- Get the IMDb API key
- Choose data endpoint
- Import the data to Google Sheets
How to import IMDb data to Google Sheets
1. Install the Amigo Data add-on
Get the Amigo Data add-on from Google Workspace Marketplace. Click here to install.
2. Get the IMDb API key
Go to imdb-api.com and click Register.
Fill in the details and click the REGISTER button.
Click the confirmation link sent to your email to complete the registration.
Click on the username. And then Profile.
You’ll find the API key under Profile.
Note the key and do not share it with anyone.
3. Choose the data endpoint
From the home page, navigate to the API documentation page by clicking API.
Choose any of the categories. We’ll scroll to Others and choose MostPopularTVs.
Expand that section to uncover the endpoint URL. The endpoint URL is given under Test. Copy that.
4. Import the data to Google Sheets
Open a new spreadsheet and launch Amigo Data.
Select Custom API from the list of sources.
Paste the endpoint in the API URL field.
Click the PREVIEW button.
Then flatten and expand the dataset so that they are organised suitably. Once that is done, click the IMPORT button.
A few moments later, you’ll have a spreadsheet populated with the data from IMDb with the title, casts, rating, release year, rating count, and images of the show amongst others.
Shown below is a snippet of the imported data.
You can likewise import dozens of other types of data from IMDb. Following are some other examples.
User reviews for Rick and Morty
The last parameter starting with tt is the IMDb movie/show ID. We can replace it with any other valid ID to get the review for that particular show or movie.
Note: Replace your_api_key in the URL with your key.
Full cast list of House of Dragon
Top 250 movies
For more endpoints, visit the IMDb API documentation page.
After importing the data from IMDb documentation, you can set a refresh schedule so that the data are updated automatically at regular intervals. To learn how to set a refresh schedule, follow this link.
There are several other types of data that you can import into Google Sheets using Amigo Data such as stock data, US FDA data, US patent data, and cryptocurrency prices and market cap to name a few.
Some related articles you may be interested in: