Google Apps Script

Until 2020, Google Apps Script was based on Mozilla's Rhino JavaScript (JS) interpreter, which limited its JS language support to version 1.6, with a subset of the ECMAScript 5 API.{{cite journal|last=Kienle|first=Holger|title=It's About Time to Take JavaScript (More) Seriously|journal=IEEE Software|date=May–June 2010|volume=27|issue=3|pages=60–62|url=http://www.computer.org/portal/web/csdl/doi/10.1109/MS.2010.76|access-date=25 March 2011|doi=10.1109/MS.2010.76|s2cid=11650861|archive-url=https://web.archive.org/web/20100629042409/http://www.computer.org/portal/web/csdl/doi/10.1109/MS.2010.76|archive-date=29 June 2010|url-status=dead}} In March 2020, Google announced the introduction of the V8 JS runtime, bringing with it full support of modern ECMAScript except for JS modules.{{cite web | url=https://workspace.google.com/blog/developers-practitioners/data-processing-just-got-easier-apps-scripts-new-v8-runtime | title=Apps Script's new V8 runtime }}

The development environment for Google Apps Script is hosted in the cloud, with an IDE with a debugger for developing scripts directly within a web browser. The infrastructure provided by Google serves as the execution environment for Apps Script projects. This platform enables the automation of tasks across Google services and integration with third-party applications.[https://developers.google.com/apps-script/guides/services/#basic_javascript_features Google Apps Script] Additionally, Google Apps Script facilitates the development of add-ons for Google Docs, Sheets, and Slides, enhancing their functionality.[http://googledrive.blogspot.com/2014/03/add-ons.html Bring a little something extra to Docs and Sheets with add-ons]

{{Jargon|date=March 2024|section}}

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.{{Cite web |title=Quotas for Google Services | Apps Script |url=https://developers.google.com/apps-script/guides/services/quotas}} Currently, the Google Apps Store does not allow direct connections 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.{{Cite web |title=JDBC | Apps Script |url=https://developers.google.com/apps-script/guides/jdbc}} Similarly, lack of other connectivity, such as LDAP connectivity, limits the level to which GAS can be used in the enterprise.{{Citation needed|date=November 2012}} 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.{{cite web |title=Issue 1035: utilities.formatdate subtracts a day. |url=https://code.google.com/p/google-apps-script-issues/issues/detail?id=1035 |access-date=17 December 2012}}

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 diagram 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[https://developers.google.com/apps-script/add-ons/style UI Style Guide for Add-ons] and CSS package to help developers build add-ons that integrate 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.{{Cite web |url=https://sites.google.com/site/scriptsexamples/home/announcements/ivestartedalittleexperiment |title=I've started a little experiment... |access-date=2014-11-18 |archive-date=2017-02-26 |archive-url=https://web.archive.org/web/20170226055451/https://sites.google.com/site/scriptsexamples/home/announcements/ivestartedalittleexperiment |url-status=dead }}

• List of scripting languages

{{Reflist}}

• {{Official website|https://developers.google.com/apps-script/}}
• [https://developers.google.com/apps-script/case-studies Google Apps Script case studies]

{{Google LLC}}

Apps Script

Category:Cross-platform software

Category:JavaScript

Category:Prototype-based programming languages

Category:Object-based programming languages

Category:Scripting languages

Category:Web frameworks

Category:Internet properties established in 2009