Website Simple Crawler Using Google Sheet

38 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: https://www.timeanddate.com/holidays/us/diwali
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 : https://support.google.com/docs/answer/3093342?hl=en

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] I've created a dogecoin wallet to receive blog funding: DE6F5FisSCy7yz5rpHY1ChMSGYnDMpFZ1Q

Leave a Reply

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