How to Scrape Website Data into Google Sheets (2020 Tutorial)

Here's how to use a free web scraper to scrape data from any website on to a Google Sheets spreadsheet.

URL USED IN THE VIDEO FOR THE IMPORTDATA FORMULA (Make sure to remove spaces):
https:// www. parsehub. com/api/v2/projects/PROJECT_TOKEN/last_ready_run/data?api_key=API_KEY&format=csv

0:00 Intro
0:50 Starting your web scraping project
1:40 Scheduling (PAID) Feature
2:25 Setting up Google sheets
---
Follow Us

#webscraping #googlesheets #scrapinggooglesheets

[luozhan]

Could you show us an example to scrape data and then keep adding new rows in Google sheet on a scheduled interval? Let say scrape Yahoo Finance's stock price on closing (5PM EST) and add new rows in Google sheet every day?

[KingGhst_o]

can you scrape several website and make the data searchable on a google sheet...i would love to add something like this to my stock portfolio i have on google sheets as a tap so i could look at news about the stocks i have

[TheBondy]

Say you had a static list of result, unlike amazon whose search results change frequently.

For example, a cooking website uploads recipes to their site every day and the list of these recipes are compiled on a page but separated into different page numbers (pagination).

How would I go about keeping an orderly scraped list of every recipe that gets added to the site across ALL the page numbers? This would including removing duplicates if a recipe slowly went from page 1 to page 2 overtime.

I’d love to understand if your application is able to do this!

[matarloum]

The googlesheet on google, after the first time, doesn't update once i run my project

[danielcerdeira]

I loved til he says the schedule is a paid version ..