5 Functions for Web Scraping in Google Sheets

I walk through the 5 built in functions in Google Sheets that scrape data from other sheets and from other web sites.

We receive commission on purchases made through some links on this page
_______________________________________________

🎓Software Recommendations:

_______________________________________________
🎓Data Course Suggestions: (coursera)

_______________________________________________
🎓AI Course Suggestions: (coursera)

_______________________________________________

🖥️ Office items I can't live without:

📲 Find me
_______________________________________________
⌚Chapter Time Markers:
00:00:00 - Intro
00:00:18 - IMPORTRANGE
00:01:37 - IMPORTHTML
00:03:00 - IMPORTDATA
00:04:00 - IMPORTFEED
00:05:14 - IMPORTXML
=============================
#googlesheets #spreadsheets #dataanalytics

[jmathew]

Very useful tutorial. Nicely explained. Very thoughtful of you to include the XPATH cheat sheet. Thanks for the tutorial!

[matiasmartinez]

muy bueno eamonn, justo lo que estaba buscando. Ahí va su like buen hombre

[mikiallen]

can you provide example pls on the case of Google local guide reviews ? best

[senatiseguimiento]

in the case that the web hv a login and password?

[abigailmapuladikobo]

Importxml could not fetch data from a google scholar url. Why is this?

[murataksu]

Hi everyone. I’m beginner on Google sheet. Is there any platform for to find answers for questions???

[MuhammadFAHM]

Clear Explanation 👍
Questions

Will the important HTML Is up-to-date data from the source website? If no then please tell us a way to keep a live data

2- I want to scrap ecommerce website product data, how to auto scrap Next page ?

3- How about import data via json file url most e-commerce website uses it eg Shopify

I'll be thankful if you please create an ecommerce website data scraping vidoe or share your tips so ill give it a try 🙂

[josephquijano]

You get me a subs. BTW bruh, can Google Sheet know if a specific word I want is inside a website? For example the word "Greatest" and i want the google sheet determine if it is in a website. thank you!

[loistverberg]

Very helpful. But please nix the funny pictures. When I'm trying to follow something useful they are distracting.

Don't forget that what seems simple to you is not to the people trying to learn from you. Cut out the stupid gifs and people will thank you.

[BL-zqvd]

dude why you want to look like a goofball on youtube ? u and a million others think looking like a goofball helps. it doesnt!