How to do web scraping with Google Sheets | Lesson 6 Using Google Sheets like a Boss! HD

Welcome to Lesson 6 of Using Google Sheets like a Boss! In this lesson; I will show you how to pull data from websites using Google Sheets. We are using importxml to pull information from Nike and Puma shops. If you are always monitoring prices of sneakers, this is for you. Once you know the basic, you can extend it to other sites. If you have any topics on Google Sheets you like me to cover. Do leave a comment below. Also if you find value in the video, please click the link below & subscribed. This means a lot to me :) https://www.youtube.com/channel/UCYZEakRmAdZ_NRpnW0RzPVQ?sub_confirmation=1 ✅✅✅Links below 16-year-old can rake in S$30,000 a month reselling sneakers https://www.youtube.com/watch?v=08bf1ZascNs Link to sample data sets that we are using for the lesson https://docs.google.com/spreadsheets/d/13jI64rJ7wdNgS48bGQS1w869qMfUoY4XhAXPxrAU5Do/view More on Using Google Sheets like a Boss! https://www.youtube.com/playlist?list=PLCGu9Sxa6X65AKOmppEf87InjSq9-2hMM Check this for lesson plan:Using Google Sheets like a Boss! https://youtu.be/JWcy9USY7Qg Me Elsewhere What I’m doing now?: https://bosslee.co/ Instagram: https://www.instagram.com/bossleetech/ 00:00 Introduction 01:56 Start of Lesson 6 02:12 Intro to IMPORTXML 04:55 Pulling data from Nike Store 08:20 Pulling data from Puma Store 10:48 Using VLOOKUP as a search bar