apigoogle-sheetsimdb

How can i get genres and descriptions of movies in IMBd API?

so Im using the Top 250 Movies database in IMDb's API and i need the genres and descriptions of all the movies but i looked in IMDb's API list and they don't have anything about genres or descriptions.

I just want the genres and the short description on the IMDb website when you are on a movie.

And if anyones want to know i exporting the data into a spreadsheet. google sheets to be specific.

enter image description here

Solution

  • Use the following IMPORTXML:

    For Plot use :

    =IMPORTXML("imdb movie url","//*[@data-testid='plot-xl']")

    For Genres use :

    =IMPORTXML("imdb movie url","//*[@data-testid='genres']")

    Example:

    enter image description here

    Reference: