Web Scraping in Google Sheets" IMPORTHTML, IMPORTDATA, IMPORTFEED, & IMPORTXML - SheetAI App

Learn how to use the IMPORTHTML, IMPORTDATA, IMPORTFEED, and IMPORTXML functions in Google Sheets to web scrape data from websites.
----------------
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
----------------
Github CSV: github.com/datasets/populatio...
NASA RSS Feed: www.nasa.gov/content/nasa-rss...
----------------
Follow twitter: / sheetaiapp
Install SheetAI App: www.sheetai.app

[@sheetai]

To Run 100s of variations of gpt3 prompt inside google sheets with the scraped data, Install SheetAI.app

[@rs-tarxvfz]

Thank my fellow Indian Bro

[@X1011]

To be fair, I wouldn’t call that last example scraping; it seems you’d have to use that JavaScript snippet in some headless browser to achieve any sort of automation or batch processing.

[@sheetai]

i agree i even thought to remove it but then felt i have told about it before and i do not want to re record the whole

[@X1011]

so the IMPORTHTML & IMPORTXML are both being used on HTML pages, but just the query formats are different? (looks like CSS selector vs. XPath)

[@sheetai]

yes

[@tahirbiowel]

3:23 Excited ❤,,dear plz tell me that I have , Excel live documents to scrape data in Google drive,also can't download, no permission granted by client,how I solve it

[@StudentFinance-jv5xg]

google sheet show error "Imported content is empty." what i do ?

[@peoplemoving]

The last example was a bit confusing... And who could how benefit from scraping LinkedIn Info? Recruiters? Who else?

[@sheetai]

yeah that is just a coding way i found interesting at the time, for linkedin yes i have seen many people trying to scrape linkedin to contact people. It can be people trying to sell their products sending cold message on linkedin not just recruiters.

[@rquinn0111]

Sorry, I'm very confused, but it looks like you are providing the answer I'm looking for. I'm trying to scrape used prices off of Amazon using IMPORTXTML. Is your last example the way to avoid error messages?