Search code examples
google-sheetsweb-scrapingxpathgoogle-sheets-formulaspreadsheet

Extraction of elements from a website using similar method as favicon extraction -> http://www.google.com/s2/

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.

Solution

  • take a dive into import functions:

    • IMPORTHTML
    • IMPORTXML
    • IMPORTDATA
    • IMPORTFEED
    • IMPORTJSON (with script)

    https://support.google.com/docs/answer/12188454?hl=en