Have you ever wanted to send an automated email when a Google Form is submitted? Have you been interested in finding the emails with the biggest attachments in your Gmail inbox? Fear not, Google Apps Script is a valuable tool for you.
What is Google Apps Script?
What can Google Apps Script do?
One of the best features of Google Apps Script is the ability to have them run on a trigger. If the script is inside of a spreadsheet, the code you write can be executed on a time-based or event-based trigger. For example, if you are conducting surveys through a google form, an automated email with the answers to that form can be sent to you as soon as the form is submitted. If you’re not interested in getting an email every time a form is submitted, a digest of answers could be sent out at the end of each day.
At Cloudbakers, we use Google Apps Script to maintain an internal calendar with project milestones. The workflow is complex, but the results are simple. Google Apps Script queries our project management system using an API. It then writes to a specified company wide calendar using the built in Calendar Service in Google Apps Script.
In addition to executing simple workflows, Google Apps Script can be extended to handle very complex ones. Examples include an automated time tracking system, Mail Merge in Gmail, and even a full help desk automation. Tutorials for all of these and more are featured on the Google Apps Script tutorial page. Google Apps Script is a solution to many common problems.
A great feature of Google Apps Script is that the service handles all authentication for you. Google uses OAuth for their API authentication, which can be tricky to navigate for many developers. Google Apps Script handles all API authentication and allows you to develop your applications fast and efficiently. Google Apps Script can authenticate against and has built in libraries for Gmail, Forms, Documents, Domain, and AdSense- just to name a few.
Overall, Apps Script provides a simple and effective tool for developing rapid solutions for Google Apps. Just like other Google Development services, Google Apps Script has a health dashboard and a quota page.
If you or your business is interested in learning more about Google Apps Script development or are interested in how the Google Apps Suite can impact your business, please contact us at firstname.lastname@example.org.
Bio: Alex Voorhees is a Cloud Programming specialist at Cloudbakers. He specializes in building integrations between cloud systems as well as developing custom applications and solutions on Google App Engine and Google Apps Script. Follow him on G+.Originally published on October 16, 2013