I need to extract information about the books from this https://www.youtube.com/channel/UC02x9yG9ZFF_VZp1VnMoptg/videos youtube channel and put them in this excel spreadsheet https://docs.google.com/spreadsheets/d/1ggB1zaHkI7Ihph5W019i2NzbF3h1z3JoUbEICOnN04M/edit?usp=sharing
Information that needs to be extracted:
Youtube Link: Link of the youtube video. Example: https://www.youtube.com/watch?v=Hd9pHZC7Sak
Youtube Video id: id of video can be found in youtube link of the video. Example: from above link video id is: Hd9pHZC7Sak
Amazon Link: Link to the book on amazon.com, Example: https://www.amazon.com/gp/product/0804139296
Book Title: Main title of the book on the amazon. Example: Zero to One
Book Subtitle: Subtitle of the book on amazon. Example: Notes on Startups, or How to Build the Future
Author: Book authors from the amazon Example: Peter Thiel, Blake Masters
Description: Book Description from the Amazon, Copy first paragraph of book description from Amazon Example: “The great secret of our time is that there are still uncharted frontiers to explore and new inventions to create. In Zero to One, legendary entrepreneur and investor Peter Thiel shows how we can find singular ways to create those new things.”
Book Image: Link to book image on Amazon, to get it to right-click on the cover image of the book and the “open image in new tab” and you will get a link to the image Example: https://images-na.ssl-images-amazon.com/images/I/4137OkbPQ4L._SX331_BO1,204,203,200_.jpg
Category: To get category fo the book go to https://www.goodreads.com/ search for the book and on book page, in the right column, you will have listed Genres of the book so pick the first from the list. Example: https://www.goodreads.com/book/show/18050143-zero-to-one for this book category will be “Business”
