Have you checked out Google App Scripts?

posted Mar 10, 2014, 10:29 AM by Jennifer Mruk   [ updated Mar 10, 2014, 11:17 AM ]
Apps Script helps you to increase the power of your favorite Google apps - like Calendar, Docs, Drive, Mail, and Sheets. Google Apps Script is a JavaScript cloud scripting language that provides easy ways to automate tasks across Google products and build web applications.

Check out the GEC App Script Center to view 100 popular Apps Scripts. The spreadsheet has a detailed description of each App Script. Copy the Link to view code from line 2 of the spreadsheet and paste for the URL to access each script in the Sheet. To learn more about finding and adding a script, see Installing a Script from the Gallery. For more information about Google Apps Script visit Google's App Script site and Google's Apps Script resources for developers