I have a film list on google sheets and I want to add their genres drawing them via an API, from imdb or something.

My files are on the B column and I want genres to be listed on D column

This is the google sheets link

https://docs.google.com/spreadsheets/d/1mw5bmi094fQCeM_Q64tQVUzkz8hhc89wNLqMkg4-hVI/edit?usp=sharing

Can anyone help me?

Thanks

I tried looking at forums that used APIs to draw genre from IMDB but I couldn’t apply it to my document.

I want the formula to check the name of the films in the column B, and add their genres to column D