I've recently came across this function
=Arrayformula(image("http://www.google.com/s2/favicons?sz=64&domain="&A2:A))
That allows users to extract a favicon from a given website in column A using Google xml extraction system (I believe).
I was wondering if Google offers us similar tools to simply extract other elements from a given URL using Google Sheet? For instance metadata, page title or other xml/html elements.
CodePudding user response：
take a dive into import functions:
- IMPORTHTML
- IMPORTXML
- IMPORTDATA
- IMPORTFEED
- IMPORTJSON (with script)