Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)

dataslice · Beginner ·📰 AI News & Updates ·5y ago
Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1) Part 2: https://youtu.be/4A12xqQPJXU ---------------- Code ---------------- Tables: var i = 1; [].forEach.call(document.querySelectorAll('table'), function(x) { console.log(i++, x); }); Lists: var i = 1; [].forEach.call(document.querySelectorAll('ul,ol'), function(x) { console.log(i++, x); }); ---------------- Datasets ---------------- Apple Species: https://en.wikipedia.org/wiki/List_of_apple_cultivars Earthquakes: https://en.wikipedia.org/wiki/Lists_of_earthquakes Zha Jiang Mian Recipe: https://www.thespruceeats.com/zhajiangmian-chinese-noodle-recipe-4006698 Github CSV: https://github.com/datasets/population/blob/master/data/population.csv NASA RSS Feed: https://www.nasa.gov/content/nasa-rss-feeds/ ---------------- Timeline ---------------- 0:00 Intro 0:36 ImportHTML 4:54 ImportDATA 5:46 ImportFEED 5:59 Summary
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Playlist

Uploads from Dataslice · Dataslice · 5 of 16

← Previous Next →

Related AI Lessons

⚡
When Students Boo the Future: AI, Graduate Precarity, and the Limits of Technological Optimism
Students booed a commencement speaker who compared artificial intelligence to human intelligence, highlighting concerns about AI's impact on graduate precarity and the limits of technological optimism
Medium · AI
 ⚡
Big Tech firms are accelerating AI investments and integration, while regulators and companies focus on safety and responsible adoption.
Big Tech firms are investing heavily in AI, driving growth and transformation, while prioritizing safety and responsible adoption
Dev.to AI
 ⚡
I Built a 5-Signal Vendor Watchlist for Google I/O 2026 - Here's What Each One Will Break in My Stack
Learn how to prepare for potential Google I/O 2026 announcements by building a 5-signal vendor watchlist to anticipate and mitigate potential breaks in your tech stack
Dev.to · Mykola Kondratiuk
 ⚡
Big Tech firms are accelerating AI investments and integration, while regulators and companies focus on safety and responsible adoption.
Big Tech firms are investing heavily in AI, driving growth and transformation, while prioritizing safety and responsible adoption
Dev.to AI

Chapters (5)

Intro
0:36 ImportHTML
4:54 ImportDATA
5:46 ImportFEED
5:59 Summary
Up next
Why Petrol & Diesel Prices Have Increased Across India Explained | diesel price hike |fuel prices
Switch
Watch →