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

Related AI Lessons

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
Il Paradosso Delle IA e il Fermo dell’Autore:
Explore the paradox of AI and its impact on authorship, understanding how AI-generated content challenges traditional notions of creativity and ownership
Medium · AI

Chapters (5)

Intro
0:36 ImportHTML
4:54 ImportDATA
5:46 ImportFEED
5:59 Summary
Up next
No summer 2026 internship? Watch this.
Sajjaad Khader
Watch →