Google Sheet Importxml
This video explains you the application of importxml function in google sheets.ImportXML allows you to import data from web pages directly into your Google Docs Spreadsheet. It's like magic! We can now look at a page, decide what information we want by looking in the source code, finding the HTML element and by using Xpath we can dig it out. ImportXML is how we're going to pull it in.
https://docs.google.com/spreadsheets/...