Web Scrape in Google Sheets: IMPORTXML Function (Part 2)
Skills:
AI Workflow Automation70%
Key Takeaways
Uses the IMPORTXML function in Google Sheets for web scraping
Original Description
Web Scrape in Google Sheets: IMPORTXML Function (Part 2)
Part 1: https://youtu.be/Q5yVoTqD06M
In this video, we scrape Yelp, Craigslist, and TechCrunch using the importxml function in Google Sheets.
W3 Schools Tutorial: https://www.w3schools.com/xml/xpath_intro.asp
----------------
Datase
----------------
Craigslist: https://philadelphia.craigslist.org/d/cars-trucks/search/cta
TechCrunch: https://techcrunch.com/
Yelp: https://www.yelp.com/search?find_desc=burgers&find_loc=New+York%2C+NY&ns=1
----------------
Timeline
----------------
0:00 Intro
0:40 Scraping Craigslist
4:42 Scraping TechCrunch
5:28 Scraping Yelp
5:8:26 Summary
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
Playlist
Uploads from Dataslice · Dataslice · 6 of 16
1
2
3
4
5
▶
7
8
9
10
11
12
13
14
15
16
Web Scrape Text from ANY Website - Web Scraping in R (Part 1)
Dataslice
Web Scrape Nested Links/Multiple Pages - Web Scraping in R (Part 2)
Dataslice
Animate Graphs in R: Make Gorgeous Animated Plots with gganimate
dataslice
Word Clouds in R: Useful & Beautiful Word Clouds with wordcloud2
dataslice
Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)
dataslice
Web Scrape in Google Sheets: IMPORTXML Function (Part 2)
Dataslice
Make Interactive Graphs in R: Creating & Embedding Interactive Graphs with plotly
dataslice
R Maps: Beautiful Interactive Choropleth & Scatter Maps with Plotly
Dataslice
Build a Data Science Portfolio (Free & Easy) with Jekyll & GitHub Pages | Part 1: Site Configuration
dataslice
Build a Data Science Portfolio (Free & Easy) with Jekyll & GitHub Pages | Part 2: Adding Posts
dataslice
Build a Data Science Portfolio (Free & Easy) with Jekyll & GitHub Pages | Part 3: Customization
dataslice
Regex Basics | Match, Extract, and Clean Text
Dataslice
Scrape Websites with Regular Expressions
Dataslice
Dplyr Essentials (easy data manipulation in R): select, mutate, filter, group_by, summarise, & more
Dataslice
Dplyr Advanced Guide: data cleaning, reshaping, and merging with lubridate, stringr, tidyr, ggplot2
dataslice
Linear Regression Plots in R
dataslice
More on: AI Workflow Automation
View skill →
Related Reads
📰
📰
📰
📰
How to prepare for Spain civil service TIC exam using AI in 2026
Dev.to AI
AI-Powered Sample Clearance: Building Legally-Aware Reports for Independent Producers
Dev.to AI
Zuckerberg confirms Meta is eyeing an AI cloud business to rent out its compute
The Next Web AI
AI tool scours the web for job openings, preps your resume and cover letter
The Register
Chapters (4)
Intro
0:40
Scraping Craigslist
4:42
Scraping TechCrunch
5:28
Scraping Yelp
🎓
Tutor Explanation
DeepCamp AI