How to Scrap Websites with Google Sheets- ImportXML
🚀Join my free tech newsletter: https://got-sheet.beehiiv.com/ 💡 An overview of Google Sheet's IMPORTXML() function that can scrap webpages for data.
🔗 Here's the Google Sheet with all the examples for importing data: https://docs.google.com/spreadsheets/...
🔗Here's the link to the xpath_query cheat sheet: https://devhints.io/xpath
=============================
✵SUPPORT✵
☕Buy me a coffee: https://bmc.link/W4V7SRM
📽️Subscribe: https://www.youtube.com/@eamonncottre...
✵NEWSLETTER✵
💌https://got-sheet.beehiiv.com/subscribe
✵WEBSITE✵
💻https://www.eamonncottrell.com/
=============================
✵Some of My Gear & Course Suggestions✵
(affiliate links support my channel's growth 😀)
►Advanced Data Analytics by Google: imp.i384100.net/21dWGa
►Cybersecurity by Google: imp.i384100.net/VmN6oM
►Best Home Coffee Maker, hands down. Moccamaster KBGV Select: https://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. https://amzn.to/3NUDiaq
►Best wrist pain remedy: DeltaHub Ergonomic Wrist rest. I was skeptical, but it has done wonders for my desk-wrist soreness. https://amzn.to/44Oq7il
►Best Standing Desk...I love this thing. I also sit at it a lot, which I'm ok with 😀: https://amzn.to/3PV4oRo
=============================
⌚Chapter Time Markers:
00:00:00 - Intro
00:00:25 - Website Data
00:01:38 - Spreadsheet Setup
00:01:47 - Import H2 ELEMENT
00:02:25 - Import CLASS
00:02:58 - Import HREF
00:04:00 - Xpath_query Cheat Sheet
=============================
#googlesheets #spreadsheets #dataanalytics
Watch video How to Scrap Websites with Google Sheets- ImportXML online without registration, duration hours minute second in high quality. This video was added by user Eamonn Cottrell 09 August 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,913 once and liked it 34 people.