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

1 год назад

5,538 Просмотров

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: https://github.com/datasets/population/blob/master/data/population.csv
NASA RSS Feed: https://www.nasa.gov/content/nasa-rss-feeds

----------------
Follow twitter: https://twitter.com/sheetaiapp
Install SheetAI App: https://www.sheetai.app

Тэги:

#web_scrape_in_google_sheets #web_scraping_with_google_sheets #how_to_automate_web_scraping_using_google_sheets #importhtml #importfeed #importdata #get_data_from_website_into_google_sheets #how_to_automate_web_scraping #web_scraping #web_scraper #web_scraper_intro #web_scraper_tutorial #data_scraper #web_scraper_video_tutorial #online_web_scraper #web_scraping_software #web_scraper_chrome_tutorial #google_sheets #extract_data_website #web_scrape_without_code

Скачать видео

Комментарии:

Student Finance - 28.09.2023 09:28

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

Ответить

Angela D. Kosa - 27.01.2023 14:32

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

Ответить

X1011 - 27.01.2023 07:29

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.

Ответить

X1011 - 27.01.2023 07:26

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

Ответить

Сейчас смотрят