Website Simple Crawler Using Google Sheet

28 Likes Comment
Website scraping

How could I get a thumbnail, web title, description from an URL.
The answer is Google Sheet can do these works.
The function named IMPORTXML will help us to import data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.
See some examples below:
If in A2 cell you have a link such as:
You can get the thumbnail in B2 cell via: =image(IMPORTXML(A2,”//meta[@property=’og:image’]/@content”),2)
You can get the title in C2 via: =IMPORTXML(A2,”//meta[@property=’og:title’]/@content”)
For further information let’s check :

You might like

About the Author: Toc Xoan

This guy likes taking photos, hunting cheap tours, exploring the unique culture of every cities of Vietnam. Contact: [email protected]

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.