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
📰
📰
📰
📰
Title: something like "AI-Powered Batch Processing for Consistent Portrait Sessions"
Dev.to AI
Markdown as the Source of Truth: Building AI-Generated Websites on Azure
Medium · LLM
I Used AI Every Day for 30 Days—Here's What Actually Changed
Medium · AI
7 AI Tools That Feel Illegal Because They Save So Much Time
Medium · ChatGPT
Chapters (4)
Intro
0:40
Scraping Craigslist
4:42
Scraping TechCrunch
5:28
Scraping Yelp
🎓
Tutor Explanation
DeepCamp AI