Web Scrape in Google Sheets: IMPORTXML Function (Part 2)
Skills:
AI Workflow Automation70%
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 AI Lessons
⚡
⚡
⚡
⚡
From 0 to Hero: How to Create and Sell AI-Generated Digital Products in 30 Days
Dev.to AI
code-shot: the code-screenshot API that I wish existed
Dev.to · basenull
AI Tools: Transforming the Way We Work, Learn, and Create
Medium · AI
I Built a Bot That Does My Expense Reports While I Sleep
Medium · JavaScript
Chapters (4)
Intro
0:40
Scraping Craigslist
4:42
Scraping TechCrunch
5:28
Scraping Yelp
🎓
Tutor Explanation
DeepCamp AI