Google Sheets power tips: Create an automatically updating spreadsheet
Tired of finding, copying, and pasting data into spreadsheets? With just a few lines of code, you can set up a self-updating spreadsheet in Google Sheets that fetches and stores data for you.
Source: computerworld.com