Google Apps Script
This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these template messages)
|Initial release||August 19, 2009|
|Type||Web application framework, scripting framework|
Google Apps Script has some processing limitations. As a cloud-based service, Apps Script limits the time that a user's script may run, as well as limiting access to Google services. Currently, Google Apps Store does not allow direct connection to internal (behind-the-firewall) corporate databases, which is key to building business apps. However, this can be overcome via the use of the JDBC service if connections are allowed from Google servers to the internal database server. Similarly, lack of other connectivity, such as LDAP connectivity, limits the level to which GAS can be used in the enterprise. Due to the cloud nature of Apps Script, functions related to date and time will produce results that seem to be incorrect due to the data crossing time zones. Using Date/Time objects and functions without very precise declaration and thorough testing may result in inaccurate results.
In March 2014, Google introduced add-ons for Docs and Sheets (soon followed by Forms). The add-on stores let users add extra features to Google editors, such as mail-merging, workflows, and diagrams builders. All add-ons are either 100% built with Apps Script or simply use Apps Script to display a UI in the Google editors while relying on an external back-end to perform some tasks. For example, MailChimp, a mail-merging tool, has an add-on for Google Docs that communicates with MailChimp platform to send emails.
Before add-ons, it was possible to publish scripts for Google Sheets in the Script Gallery. When users installed scripts through this gallery, a copy of the Apps Script code was installed on the user's Sheet. With add-ons, the source code is not visible to the end user and everyone is using the latest version published by the developer. This new approach makes it easier to support existing code and helped convince several companies, such as MailChimp or LucidChart to invest in Apps Script.
As part of the add-ons release, Google also introduced a UI Style Guide and CSS package to help developers built add-ons that integrate smoothly into the editors. Each add-on is also reviewed by Google before its publication and developers can benefit from advice from Googlers to provide a better user experience. It is not possible to embed ads in add-ons but it is possible to monetize them.
- ^ Meyer, David (August 20, 2009). "Google Apps Script gets green light". CNet. Retrieved 26 March 2011.
- ^ Koleda, Eric (August 21, 2019). "Celebrating 10 years of Apps Script: looking back on how it started". Google Cloud Blog. Retrieved 22 August 2019.
- ^ Rochelle, Jonathan (May 27, 2009). "Old tool, new tricks". Google Cloud Blog. Retrieved 22 August 2019.
- ^ Levey, Evin (August 19, 2009). "Google Apps Script Launched to Google Apps Premier and Education". Google Apps Script. Retrieved 22 August 2019.
- ^ Google Apps Script
- ^ Bring a little something extra to Docs and Sheets with add-ons
- ^ Google Inc. (August 28, 2018). "Built-in Google Services". Google Apps Script. Retrieved 16 May 2019.
|author1=has generic name (help)
- ^ "Quotas for Google Services | Apps Script".
- ^ "JDBC | Apps Script".
- ^ "Issue 1035: utilities.formatdate subtracts a day". Retrieved 17 December 2012.
- ^ UI Style Guide for Add-ons
- ^ "I've started a little experiment..." Archived from the original on 2017-02-26. Retrieved 2014-11-18.