Google Apps Script

Apps Script

Screenshot

Developer(s)| Google
Initial release| August 19, 2009; 16 years ago (2009-08-19)[1]
Written in| JavaScript
Type| Web application framework, scripting framework
Website| script.google.com

Google Apps Script is a scripting platform developed by Google for light-weight application development in the Google Workspace platform. Google Apps Script was initially developed by Mike Harm as a side project while working as a developer on Google Sheets.[2]

The primary function of Google Apps Script is to facilitate the creation of custom tools for organizations, primarily focusing on automating tasks and simplifying system administration processes. It supports a community-based model for user support.

Google Apps Script was first publicly announced in May 2009 when a beta testing program was announced by Jonathan Rochelle, then Product Manager for Google Docs.[3] In August 2009, Google Apps Script was subsequently made available to all Google Apps Premier and Education Edition customers.[4]

## Contents

* 1 Technical details
* 2 Limitations
* 3 Add-ons
* 4 See also
* 5 References
* 6 External links

## Technical details

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.[5] In March 2020, Google announced the introduction of the V8 JS runtime, bringing with it full support of modern ECMAScript except for JS modules.[6]

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.[7] Additionally, Google Apps Script facilitates the development of add-ons for Google Docs, Sheets, and Slides, enhancing their functionality.[8]

## Limitations

This section may be too technical for most readers to understand. Please help improve it to make it understandable to non-experts, without removing the technical details. (March 2024) (Learn how and when to remove this template message)

|

Google Apps Script has a number of different 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.[9] Currently, Google Apps Script does not allow direct connections to internal 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.[10] Additionally, 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 precise declaration and thorough testing may result in inaccurate results.[11]

Alongside this Apps Script can be difficult to work with when multiple people are working on a single project. As App Script development is done through an online IDE it can be difficult to integrate App Script projects with traditional Version control systems like Git.[12] One alternative to this would be to use a tool like Clasp which allows developers to work on their Apps Script projects locally instead of through a web browser.[13]

## Add-ons

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[14] 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.[15]

## See also

* List of scripting languages

## References

1. ↑ Meyer, David (August 20, 2009). "Google Apps Script gets green light". CNet. http://news.cnet.com/8301-1001_3-10314002-92.html.
2. ↑ Koleda, Eric (August 21, 2019). "Celebrating 10 years of Apps Script: looking back on how it started". https://cloud.google.com/blog/products/g-suite/celebrating-10-years-of-apps-script-looking-back-on-how-it-started.
3. ↑ Rochelle, Jonathan (May 27, 2009). "Old tool, new tricks". https://cloud.googleblog.com/2009/05/old-tool-new-tricks.html.
4. ↑ Levey, Evin (August 19, 2009). "Google Apps Script Launched to Google Apps Premier and Education". http://googleappsscript.blogspot.com/2009/08/google-apps-script-launched-to-google.html.
5. ↑ Kienle, Holger (May–June 2010). "It's About Time to Take JavaScript (More) Seriously". IEEE Software 27 (3): 60–62. doi:10.1109/MS.2010.76. http://www.computer.org/portal/web/csdl/doi/10.1109/MS.2010.76. Retrieved 25 March 2011.
6. ↑ "Apps Script's new V8 runtime". https://workspace.google.com/blog/developers-practitioners/data-processing-just-got-easier-apps-scripts-new-v8-runtime.
7. ↑ Google Apps Script
8. ↑ Bring a little something extra to Docs and Sheets with add-ons
9. ↑ "Quotas for Google Services | Apps Script". https://developers.google.com/apps-script/guides/services/quotas.
10. ↑ "JDBC | Apps Script". https://developers.google.com/apps-script/guides/jdbc.
11. ↑ "Issue 1035: utilities.formatdate subtracts a day.". https://code.google.com/p/google-apps-script-issues/issues/detail?id=1035.
12. ↑ "Collaborate with other developers". https://developers.google.com/apps-script/guides/collaborating.
13. ↑ "Clasp". https://github.com/google/clasp.
14. ↑ UI Style Guide for Add-ons
15. ↑ "I've started a little experiment...". https://sites.google.com/site/scriptsexamples/home/announcements/ivestartedalittleexperiment.

## External links

* Official website
* Google Apps Script case studies

* v
* t
* e

Google

* Alphabet Inc.
* Android
* Devices
* Nexus
* Pixel
* Maps
* YouTube

Company|

* Overview
* Alphabet Inc.
* History
* List of mergers and acquisitions by Alphabet
* List of products
* Criticism
* Privacy concerns
* Censorship
* Litigation
* Don't be evil

Real estates|

* 111 Eighth Avenue
* Chelsea Market
* Googleplex
* Data centers

Advertising|

* AdMob
* Adscape
* Ads
* AdSense
* Analytics
* Contributor

Events|

* Code-in
* Code Jam
* Developer Day
* I/O
* Science Fair
* Summer of Code
* Talks at Google

People|

* Al Gore
* Alan Eustace
* Alan Mulally
* Amit Singhal
* Ann Mather
* David Drummond
* Eric Schmidt
* Jeff Dean
* John Doerr
* John L. Hennessy
* Krishna Bharat
* Matt Cutts
* Patrick Pichette
* Paul Otellini
* Omid Kordestani
* Rachel Whetstone
* Rajen Sheth
* Ram Shriram
* Ray Kurzweil
* Ruth Porat
* Salar Kamangar
* Sanjay Ghemawat
* Shirley M. Tilghman
* Sundar Pichai
* Susan Wojcicki
* Urs Hölzle
* Vint Cerf
* Hal Varian

Terms|

* Gayglers
* Google Developer Expert

Founders|

* Larry Page
* Sergey Brin

Typefaces|

* Noto
* Roboto
* Product Sans

Products|

| Software|

* Assistant
* Camera
* Lens
* Goggles
* Chrome
* for Android
* Web Store
* Chromium
* Cloud Print
* Earth
* Gadgets
* Gboard
* IME
* Japanese
* Pinyin
* Pay
* Pay Send
* Photos
* Keep
* News
* Now
* OpenRefine
* Snapseed
* Waze

Operating systems|

* Android
* version history
* software development
* Android Automotive
* Android TV
* Wear OS
* List of devices
* Chrome OS
* Apps
* Fuchsia

Programming languages|

* Dart
* Go
* Sawzall

Frameworks|

* Angular
* AngularJS
* AJAX APIs
* Dialogflow
* Flutter
* Guava
* Guice
* TensorFlow

Communication|

* Alerts
* Apps Script
* Duo
* Calendar
* Contacts
* Gmail
* history
* interface
* Groups
* Hangouts
* Chat
* Meet
* Sync
* Text-to-Speech
* Translate
* Transliteration
* Voice

Platforms|

* Account
* Authenticator
* Android Auto
* ZygoteBody
* Cast
* Cloud Platform
* App Engine
* BigQuery
* Bigtable
* Compute Engine
* Storage
* Fit
* GFS
* G Suite
* Classroom
* Marketplace
* Native Client
* OpenSocial
* Pay
* Send
* Primer
* Play
* Books
* Games
* Movies & TV
* Music
* Public DNS
* Safe Browsing
* Stadia
* Tango
* YouTube TV

Development|

* App Inventor
* Caja
* Closure Tools
* Developers
* Firebase
* GData
* KML
* Kythe
* MapReduce
* Owlchemy Labs
* Web Toolkit
* Search Console
* Website Optimizer
* Swiffy

Publishing|

* AMP
* Blogger
* Domains
* Drive
* Docs
* Sheets
* Slides
* Drawings
* Forms
* Fusion Tables
* FeedBurner
* Google Podcasts
* Sites
* YouTube
* Instant
* Premium
* Vevo
* Zagat

Search
(timeline)|

* Blog Search
* Books
* Ngram Viewer
* Custom Search
* Dataset Search
* Dictionary
* Finance
* Flights
* Googlebot
* Images
* Maps
* Street View
* Coverage
* Privacy concerns
* News
* Archive
* Patents
* Public Data
* Scholar
* Shopping
* Tenor
* Videos

Algorithms|

* PageRank
* Panda
* Penguin
* Hummingbird

Features|

* Personalized
* SafeSearch
* Voice Search

Analysis|

* Insights for Search
* Trends
* Knowledge Graph and Vault

Hardware|

* Glass
* Home
* Jamboard
* Wifi
* OnHub

Virtual reality|

* Cardboard
* Daydream

Nest|

* Nest Learning Thermostat
* Nest

Smartphones|

* Nexus
* Pixel

Chrome|

* Chromebit
* Chromecast
* Chromebook
* Chromebox

Other|

* .google
* Arts & Culture
* ATAP
* Chrome Zone
* Data Transfer Project
* Dragonfly
* Current
* Chrome Experiments
* Google Business Groups
* Made with Code
* Data Liberation
* Takeout
* Google (verb)
* Google China
* Google Express
* Googlization
* Google.org
* Logo and related
* Doodle4Google
* Google Doodles
* Lunar X Prize
* Google Fi
* Google Station
* Material Design
* Motorola Mobility
* Nest Labs
* reCAPTCHA
* Sunroof
* WiFi
* AI Challenge
* Easter eggs
* elgooG

Related|

* Google bombing
* Goojje
* Monopoly City Streets
* Unity

Documentaries|

* Google: Behind the Screen
* Google: The Thinking Factory
* Google and the World Brain

* Category
*   *   * Discontinued products and services

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/Google Apps Script. Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=Software:Google_Apps_Script&oldid=3960936"
*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template