Snapshot data on a trigger in Sheets using Apps Script
Question (paraphrased from Tim, sales manager at a local paper):
I collect data from my team in a Sheet once a week. Can I snapshot that data into a master Sheets database on a schedule?
Answer:
Grab the snapshot script from the template below - which you can easily adapt to fit your own data:
https://docs.google.com/spreadsheets/...
The raw script is available in the Sheets template Vault on Trello:
https://trello.com/c/QLmTqnYV/38-shee...