Google Sheets - track data

saor

Honorary Master
Joined
Feb 3, 2012
Messages
17,406
#1
Was wondering...if I have a Sheets docs that's pulling (API) data via a script to populate the spreadsheet with new data each day, how would I go about automatically tracking those changes over time - so that at the end of some period I could plot and chart it? Some function in Sheets, script, addon? I'd still need to open the sheet daily to refresh the data, that's fine, but how to track that data.

Thanks
 
Top