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.
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 🙂
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.
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 😊
@@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!
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.
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!
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👍
@@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!
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/
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.
⭐⭐Grab the FREE demo sheet here - www.gotsheet.xyz/c/web-scraping-google-sheets-functions
Very useful tutorial. Nicely explained. Very thoughtful of you to include the XPATH cheat sheet. Thanks for the tutorial!
Thanks! And you’re welcome too! Yeah, that cheat sheet is very useful.
muy bueno eamonn, justo lo que estaba buscando. Ahí va su like buen hombre
can you provide example pls on the case of Google local guide reviews ? best
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.
some superior content here, tyvm
Thanks! Hope it’s helpful!
This is amazing! Subbed.
Awesome! Thanks!
Let's go! 🚀🚀🚀
Go go go 🎉😊
in the case that the web hv a login and password?
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
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 🙂
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.
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 😊
@@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!
@@EamonnCottrell Thank you so much for advanced software suggestions. i'll explorer them. ScrapingBee seems to be new to me :)
Importxml could not fetch data from a google scholar url. Why is this?
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.
@@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.
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!
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👍
@@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!
Hi everyone. I’m beginner on Google sheet. Is there any platform for to find answers for questions???
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/
@@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!
@@murataksu6496 Good luck! I also have a newsletter with quick tips if you want to check it out here: got-sheet.beehiiv.com/
🤘🤘🤘
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.
dude why you want to look like a goofball on youtube ? u and a million others think looking like a goofball helps. it doesnt!