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
Смотрите видео How to Scrap Websites with Google Sheets- ImportXML онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Eamonn Cottrell 09 Август 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,913 раз и оно понравилось 34 людям.