5 Functions for Web Scraping in Google Sheets

Подписаться 4,3 тыс.

Просмотров 10 тыс.

50% 1

🚀Join my free tech newsletter: got-sheet.beehiiv.com/
💥 I walk through the 5 built in functions in Google Sheets that scrape data from other sheets and from other web sites.
Link to Demo Spreadsheet: docs.google.com/spreadsheets/...
=============================
🚀 LINKEDIN ► / eamonncottrell
🚀 WEBSITE ► www.eamonncottrell.com/
=============================
🚀 Some of My Gear & Course Suggestions
(affiliate links support my channel's growth 😀)
►Need a powerful automation tool for Google Sheets? Try Coefficient to automatically import data and sync with your business systems: coefficient.io/?via=984f9f
► Advanced Data Analytics Certificate by Google: imp.i384100.net/21dWGa
► Cybersecurity by Google: imp.i384100.net/VmN6oM
► Best Home Coffee Maker, hands down. Moccamaster KBGV Select: amzn.to/3rjdjSr
► Best mechanical keyboard for data analysts: Keychron Q series. I own the Q5, but they're all good depending on your layout needs. amzn.to/3NUDiaq
► Best wrist pain remedy: DeltaHub Ergonomic Wrist rest. I was skeptical, but it has done wonders for my desk-wrist soreness. amzn.to/44Oq7il
► Best Standing Desk...I love this thing. I also sit at it a lot, which I'm ok with 😀: amzn.to/3PV4oRo
=============================
⌚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

Наука

Опубликовано:

23 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 31

@matiasmartinez6983 10 месяцев назад

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

@jmathew6988 4 месяца назад

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

@EamonnCottrell 4 месяца назад

Thanks! And you’re welcome too! Yeah, that cheat sheet is very useful.

@jonathandorozowsky4005 8 месяцев назад

This is amazing! Subbed.

@EamonnCottrell 8 месяцев назад

Awesome! Thanks!

@charlesmurray3255 10 месяцев назад

some superior content here, tyvm

@EamonnCottrell 10 месяцев назад

Thanks! Hope it’s helpful!

@mikiallen7733 6 дней назад

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

@EamonnCottrell 5 дней назад

What do you mean exactly? Importing reviews from a Google Maps listing? I am not sure you could do something like that as those pages are loaded quite dynamically.

@asa_howard 10 месяцев назад

Let's go! 🚀🚀🚀

@EamonnCottrell 10 месяцев назад

Go go go 🎉😊

@abigailmapuladikobo9941 2 месяца назад

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

@EamonnCottrell 2 месяца назад

Curious. What's the url? These functions are definitely not foolproof, and some websites may not be able to be this easily scraped. There are a lot of variables.

@abigailmapuladikobo9941 2 месяца назад

@@EamonnCottrell "scholar.google.com/scholar?start=0&q=%22research+methods%22+AND+Africa+AND+training&hl=en&as_sdt=0,5" I tried to scrape the titles.

@murataksu6496 8 месяцев назад

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

@EamonnCottrell 7 месяцев назад

Feel free to ask away on any of my videos; I'm very responsive and open to new topic ideas. The data and spreadsheet community on LinkedIn is also quite good. You can find me over there too - www.linkedin.com/in/eamonncottrell/

@murataksu6496 7 месяцев назад

@@EamonnCottrell Thank you so much. I have some plans to learn a few programs/software after 45 years old. Spread sheets is one of them. Wish me luck!

@EamonnCottrell 7 месяцев назад

@@murataksu6496 Good luck! I also have a newsletter with quick tips if you want to check it out here: got-sheet.beehiiv.com/

@senatiseguimiento Месяц назад

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

@EamonnCottrell Месяц назад

not a way to do this on a protected website using just these functions (that I'm aware of)...would need a more robust coding tool

@josephquijano9206 9 месяцев назад

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!

@EamonnCottrell 9 месяцев назад

Cool idea! Yes...you could combine IMPORTXML with some logic to find this out. For instance, I could search for the word "Professional" in every on a web site using this formula (assuming the url is in A1): =IF(COUNTIF(ARRAYFORMULA(IMPORTXML(A1,"//div")),"*Professional*")>0,TRUE,FALSE) So you still need to feed it an element to look through like all the divs or h2s, but this'll do the trick👍

@josephquijano9206 9 месяцев назад

@@EamonnCottrell thanks for the tip! BTW, your videos in this channel are dopes. The editing looks like been making by a GOLD channel. Keep it up and you're in the right track! Also, if you can make a video where google sheet can check if an email is valid or invalid using a script. EVA email verifier seems can do the trick. God bless!

@DataFrenchy 10 месяцев назад

🤘🤘🤘

@MuhammadFAH33M 3 месяца назад

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 🙂

@EamonnCottrell 3 месяца назад

You may want to explore more robust tooling like a plugin or python scripting if you need to handle refreshing/changing data often. But, yes, you can pull data from ecommerce sites using importhtml if the data in question is in a list or a table. Here's a note from Google on how data freshness is handled: support.google.com/docs/answer/12188454?hl=en#:~:text=To%20ensure%20users%20get%20fresh,and%20sheet%20don't%20change.

@MuhammadFAH33M 3 месяца назад

Dear@@EamonnCottrell Thanks for your prompt response. Yesterday i've tried to scrap e-commerce website but Google Sheet using ImportXML returns N/A Error. Even i've used Xpath Tools to validate my selections. They were working perfectly fine but for Google Sheet formula wasn't Looks like this solution is for simple sites which allow fetching info I'll look into the freshness of data via your suggested link 🖇️ Thanks 😊

@EamonnCottrell 2 месяца назад

@@MuhammadFAH33M Yes, I expect that you'll need a more robust solution for bigger, more complicated sites. I have run into issues trying to get data for example from Amazon or similar ecomm sites in the past. ScrapingBee and Octoparse are two platforms I've heard of with a larger set of tools; some googling will get you the rest of the way there. Good luck!

@MuhammadFAH33M 2 месяца назад

@@EamonnCottrell Thank you so much for advanced software suggestions. i'll explorer them. ScrapingBee seems to be new to me :)

@loistverberg900 5 месяцев назад

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.