Scrape data from websites into Google Sheets and Data Studio
This video highlights the behind the scenes of a project to use Google Sheets to scrape wildfire data from https://inciweb.nwcg.gov/ and track the data overtime in Google Data Studio.
Links to the Sheet and Dashboard for you to make your own copies:
Sheet - https://docs.google.com/spreadsheets/...
Dashboard - https://datastudio.google.com/reporti...
0:23 - What's the Project
1:33 - Using Sheets to scrape and manage the data
8:13 - Automating with App Script