Kaip automatiškai perkelti duomenis tarp skirtingų google skaičiuoklės lentelių?

Šaltiniai:
https://davefoord.wordpress.com/2011/11/04/how-to-automatically-pull-data-between-different-google-spreadsheets/

Google Spreadsheets - Populating one spreadsheet with data from another spreadsheet
https://www.youtube.com/watch?v=hB5UGZTSl1E

How to find your Google Spreadsheet Key
http://www.coolheadtech.com/blog/use-data-from-other-google-spreadsheets

Docs editors Help - IMPORTRANGE

https://support.google.com/docs/answer/3093340?hl=en

Interactive reports using QUERY and IMPORTRANGE

http://techcogitation.blogspot.lt/2014/05/interactive-reports-using-query-and.html