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

More banks join SoftBank’s $40 billion OpenAI loan as syndication enters soft-launch phase
SoftBank's $40 billion OpenAI loan attracts more banks as sub-underwriters, testing creditor appetite for AI-linked debt
The Next Web AI
Day 15: The Ripple Effect — Why You Should Start “Building in Public” Today
Learn how building in public can help you achieve AI mastery by sharing your journey and progress with others
Medium · AI
When the Instrument Changes
Learn to adapt and compose differently when old patterns no longer fit, a crucial skill in AI and professional growth
Medium · AI
How Artificial Intelligence Is Quietly Reshaping the Way We Work — and What to Do About It
Learn how AI is transforming industries and what skills professionals need to adapt, with actionable steps to enhance your career in an AI-driven workforce
Medium · Machine Learning

Chapters (5)

Intro
0:36 ImportHTML
4:54 ImportDATA
5:46 ImportFEED
5:59 Summary
Up next
OpenAI Spud (GPT 6), Claude Conway, GPT Image 2, Cursor 3, Claude Code Ultra, & More! AI NEWS!
WorldofAI
Watch →