We've got a large shared spreadsheet which is a chart showing user permissions. It's writable by several people. Although Google Drive allows you to roll back the changes simply its interface isn't really that great for at a checking changes.
Is there a way you can automatically create a sheet called 'changes' or 'change log', etc., and have all changes listed in there? There is something like this using Excel macros.
Is it possible in Google Spreadsheets either natively / with an app or with a custom script?
I know I could also export as a CSV and compare versions with Git but that's a long-winded approach.