Google Sheets, just like AdWords, can be automated with App Scripts from Google. This means we can write some code to make the spreadsheet connect with a data source of our choosing.

It has been widely assumed that at some point Google would add Docs & Spreadsheets, a word processing and a spreadsheet program, to Google Apps, a suite of communication services for organizations ...