I really like Google Apps Scripts functionality in extending out the basic tools available in Google Sheets. I write functions pretty often to either have automatic emails sent or to gather specific data from other resources. I used it yesterday building a tool to see timestamps of sent emails that I send out. Pretty useful!