Google Apps Script

Scripting platform developed by Google

Apps Script

Screenshot

Developer(s)| Google
Initial release| August 19, 2009; 15 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]

## Technical details

[edit]

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

[edit]

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 message)

|

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.[9] 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.[10] Similarly, lack of other connectivity, such as LDAP connectivity, limits the level to which GAS can be used in the enterprise.[citation needed] 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.[11]

## Add-ons

[edit]

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[12] 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.[13]

## See also

[edit]

* List of scripting languages

## References

[edit]

1. ^ Meyer, David (August 20, 2009). "Google Apps Script gets green light". CNet. Retrieved 26 March 2011.
2. ^ Koleda, Eric (August 21, 2019). "Celebrating 10 years of Apps Script: looking back on how it started". Google Cloud Blog. Retrieved 22 August 2019.
3. ^ Rochelle, Jonathan (May 27, 2009). "Old tool, new tricks". Google Cloud Blog. Retrieved 22 August 2019.
4. ^ Levey, Evin (August 19, 2009). "Google Apps Script Launched to Google Apps Premier and Education". Google Apps Script. Retrieved 22 August 2019.
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. S2CID 11650861. Archived from the original on 29 June 2010. Retrieved 25 March 2011.
6. ^ "Apps Script's 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".
10. ^ "JDBC | Apps Script".
11. ^ "Issue 1035: utilities.formatdate subtracts a day". Retrieved 17 December 2012.
12. ^ UI Style Guide for Add-ons
13. ^ "I've started a little experiment..." Archived from the original on 2017-02-26. Retrieved 2014-11-18.

## External links

[edit]

* Official website
* Google Apps Script case studies

* v
* t
* e

Google

* Alphabet Inc.
* History
* List of Android apps
* List of Easter eggs
* April Fools' Day
* List of mergers and acquisitions

Company

| Divisions|

* Ads
* AI
* Brain
* DeepMind
* Android
* booting process
* recovery mode
* software development
* version history
* China
* Goojje
* Chrome
* Cloud
* Glass
* Google.org
* Crisis Response
* Public Alerts
* RechargeIT
* Health
* Maps
* Pixel
* Search
* Timeline
* Sidewalk Labs
* Sustainability
* YouTube
* History
* "Me at the zoo"
* Social impact
* YouTuber

|

People|

| Current|

* Krishna Bharat
* Vint Cerf
* Jeff Dean
* John Doerr
* Sanjay Ghemawat
* Al Gore
* John L. Hennessy
* Urs Hölzle
* Salar Kamangar
* Ray Kurzweil
* Ann Mather
* Alan Mulally
* Rick Osterloh
* Sundar Pichai (CEO)
* Ruth Porat (CFO)
* Rajen Sheth
* Hal Varian
* Neal Mohan

|

Former|

* Andy Bechtolsheim
* Sergey Brin (Founder)
* David Cheriton
* Matt Cutts
* David Drummond
* Alan Eustace
* Timnit Gebru
* Omid Kordestani
* Paul Otellini
* Larry Page (Founder)
* Patrick Pichette
* Eric Schmidt
* Ram Shriram
* Amit Singhal
* Shirley M. Tilghman
* Rachel Whetstone
* Susan Wojcicki

Real estate|

* 111 Eighth Avenue
* Androidland
* Barges
* Binoculars Building
* Central Saint Giles
* Chelsea Market
* Chrome Zone
* Data centers
* Googleplex
* Mayfield Mall
* Pier 57
* Sidewalk Toronto
* St. John's Terminal
* YouTube Space
* YouTube Theater

Design|

* Fonts
* Croscore
* Noto
* Product Sans
* Roboto
* Logo
* Doodle
* Doodle Champion Island Games
* Magic Cat Academy
* Material Design

Events|

* Android
* Developer Challenge
* Developer Day
* Developer Lab
* Code-in
* Code Jam
* Developer Day
* Developers Live
* Doodle4Google
* G-Day
* I/O
* Jigsaw
* Living Stories
* Lunar XPRIZE
* Mapathon
* Science Fair
* Summer of Code
* Talks at Google

YouTube|

* Awards
* CNN/YouTube presidential debates
* Comedy Week
* Live
* Music Awards
* Space Lab
* Symphony Orchestra

Projects and
initiatives|

* 20% project
* Area 120
* Reply
* Tables
* ATAP
* Business Groups
* Computing University Initiative
* Data Liberation Front
* Data Transfer Project
* Developer Expert
* Digital Garage
* Digital News Initiative
* Digital Unlocked
* Dragonfly
* Founders' Award
* Free Zone
* Get Your Business Online
* Google for Education
* Google for Startups
* Labs
* Liquid Galaxy
* Made with Code
* Māori
* News Lab
* Nightingale
* Objectives and key results
* PowerMeter
* Privacy Sandbox
* Quantum Artificial Intelligence Lab
* RechargeIT
* Shield
* Silicon Initiative
* Solve for X
* Starline
* Student Ambassador Program
* Submarine communications cables
* Dunant
* Grace Hopper
* Sunroof
* YouTube
* Creator Awards
* Next Lab and Audience Development Group
* Original Channel Initiative
* Zero

Criticism|

* 2018 data breach
* 2018 walkouts
* Alphabet Workers Union
* Censorship
* DeGoogle
* Dragonfly
* FairSearch
* "Ideological Echo Chamber" memo
* Litigation
* Privacy concerns
* Street View
* San Francisco tech bus protests
* Services outages
* Smartphone patent wars
* Worker organization

YouTube|

* Back advertisement controversy
* Censorship
* Copyright issues
* Copyright strike
* Elsagate
* Fantastic Adventures scandal
* Headquarters shooting
* Kohistan video case
* Reactions to Innocence of Muslims
* Slovenian government incident

Development

| Operating systems|

* Android
* Automotive
* Glass OS
* Go
* gLinux
* Goobuntu
* Things
* TV
* Wear OS
* ChromeOS
* ChromiumOS
* Neverware
* Fuchsia
* TV

|

Libraries/
frameworks|

* ALTS
* AMP
* Angular
* JS
* ARCore
* APIs
* Blockly
* Chart API
* Charts
* Dialogflow
* Exposure Notification
* Fast Pair
* Federated Learning of Cohorts
* File System
* FlatBuffers
* Flutter
* Gears
* gRPC
* Gson
* Guava
* Guice
* Guetzli
* JAX
* gVisor
* MapReduce
* Matter
* Mobile Services
* Neural Machine Translation
* OpenSocial
* Pack
* Polymer
* Protocol Buffers
* Reqwireless
* Shell
* Skia Graphics Engine
* Tango
* TensorFlow
* Test
* WaveNet
* Weave
* Web Accelerator
* WebRTC

Platforms|

* App Engine
* AppJet
* Apps Script
* Cloud Platform
* Anvato
* Firebase
* Cloud Messaging
* Crashlytics
* Global IP Solutions
* Internet Low Bitrate Codec
* Internet Speech Audio Codec
* Gridcentric, Inc.
* ITA Software
* Kubernetes
* LevelDB
* Neatx
* Project IDX
* SageTV

Apigee|

* Bigtable
* Bitium
* Chronicle
* VirusTotal
* Compute Engine
* Connect
* Dataflow
* Datastore
* Kaggle
* Looker
* Mandiant
* Messaging
* Orbitera
* Shell
* Stackdriver
* Storage

Tools|

* American Fuzzy Lop
* Android Cloud to Device Messaging
* Android Debug Bridge
* Android Studio
* App Maker
* App Runtime for Chrome
* AppSheet
* Bazel
* Chrome Frame
* Closure Tools
* Cpplint
* Data Protocol
* Gadgets
* Gerrit
* GYP
* Kythe
* Lighthouse
* MIT App Inventor
* Mashup Editor
* Native Client
* Optimize
* OpenRefine
* OR-Tools
* PageSpeed
* Plugin for Eclipse
* Programmable Search Engine
* Public DNS
* reCAPTCHA
* Schema.org
* Search Console
* Sitemaps
* Swiffy
* Tesseract (software)
* Trendalyzer
* VisBug
* Wave Federation Protocol
* Web Toolkit

Search algorithms|

* Hummingbird
* PageRank
* applications in biochemistry
* Matrix
* Panda
* Penguin
* Pigeon
* RankBrain

Others|

* BERT
* BigQuery
* Chrome Experiments
* Flutter
* Gemini
* Googlebot
* Keyhole Markup Language
* LaMDA
* Open Location Code
* PaLM
* Programming languages
* Caja
* Carbon
* Dart
* Go
* Sawzall
* Transformer
* Viewdle
* Webdriver Torso
* Web Server

File formats|

* AAB
* APK
* AV1
* On2 Technologies
* VP3
* VP6
* VP8
* libvpx
* VP9
* WebM
* WebP
* WOFF2

Products

| Entertainment|

* Currents (news app)
* Green Throttle Games
* Owlchemy Labs
* Oyster
* PaperofRecord.com
* Podcasts
* Quick, Draw!
* Santa Tracker
* Songza
* Stadia
* games
* Typhoon Studios
* TV
* Vevo
* Video

Play|

* Books
* Games
* most downloaded apps
* Music
* Newsstand
* Pass
* Services

YouTube|

* BandPage
* BrandConnect
* Content ID
* Instant
* Kids
* Music
* Official channel
* Premium
* original programming
* YouTube Rewind
* RightsFlow
* Select
* Shorts
* Studio
* TV

Communication|

* Allo
* Bump
* Buzz
* Chat
* Contacts
* Currents (social app)
* Dodgeball
* Duo
* Fi Wireless
* Friend Connect
* Gizmo5
* Google+
* Gmail
* History
* Inbox
* Interface
* Groups
* Hangouts
* Helpouts
* IME
* Japanese
* Pinyin
* Jaiku
* Marratech
* Meebo
* Meet
* Messages
* Moderator
* Neotonic Software
* Orkut
* Postini
* Quest Visual
* Word Lens
* Schemer
* Spaces
* Sparrow
* Talk
* Translate
* Translator Toolkit
* Voice
* Voice Local Search
* Wave

Search|

* Aardvark
* Alerts
* Answers
* Base
* BeatThatQuote.com
* Blog Search
* Books
* Ngram Viewer
* Code Search
* Data Commons
* Dataset Search
* Dictionary
* Directory
* Fast Flip
* Flu Trends
* Finance
* Goggles
* Google.by
* Images
* Image Labeler
* Image Swirl
* Kaltix
* Knowledge Graph
* Freebase
* Metaweb
* Like.com
* News
* Archive
* Weather
* Patents
* People Cards
* Personalized Search
* Public Data Explorer
* Questions and Answers
* SafeSearch
* Scholar
* Searchwiki
* Shopping
* Catalogs
* Express
* Squared
* Tenor
* Travel
* Flights
* Trends
* Insights for Search
* Voice Search
* WDYL

Navigation|

* Earth
* Endoxon
* ImageAmerica
* Maps
* Latitude
* Map Maker
* Navigation
* Pin
* Street View
* Coverage
* Trusted
* Waze
* Where Is My Train

Business
and finance|

* Ad Manager
* AdMob
* Ads
* Adscape
* AdSense
* Attribution
* BebaPay
* Checkout
* Contributor
* DoubleClick
* Affiliate Network
* Invite Media
* Marketing Platform
* Analytics
* Looker Studio
* Urchin
* Pay (mobile app)
* Wallet
* Pay (payment method)
* Send
* Tez
* PostRank
* Primer
* Softcard
* Wildfire Interactive
* Widevine

Organization
and productivity|

* Bookmarks
* Browser Sync
* Calendar
* Cloud Search
* Desktop
* Drive
* Etherpad
* fflick
* Files
* iGoogle
* Jamboard
* Notebook
* One
* Photos
* Quickoffice
* Quick Search Box
* Surveys
* Sync
* Tasks
* Toolbar

Docs Editors|

* Docs
* Drawings
* Forms
* Fusion Tables
* Keep
* Sheets
* Slides
* Sites
* Vids

Publishing|

* Apture
* Blogger
* Pyra Labs
* Domains
* FeedBurner
* One Pass
* Page Creator
* Sites
* Web Designer

Education|

* Classroom
* Grasshopper
* Socratic
* Photomath
* Read Along
* Toontastic 3D
* Workspace
* Marketplace

Others|

* Account
* Dashboard
* Takeout
* Android Auto
* Android Beam
* Arts & Culture
* Assistant
* Authenticator
* Body
* BufferBox
* Building Maker
* BumpTop
* Cast
* Cloud Print
* Crowdsource
* Digital Wellbeing
* Expeditions
* Family Link
* Find My Device
* Fit
* Google Fonts
* Gboard
* Gemini
* Gesture Search
* Impermium
* Knol
* Lively
* Live Transcribe
* MyTracks
* Nearby Share
* Now
* Offers
* Opinion Rewards
* Person Finder
* Poly
* Question Hub
* Quick Share
* Reader
* Safe Browsing
* Sidewiki
* SlickLogin
* Sound Amplifier
* Speech Recognition & Synthesis
* Station
* Store
* TalkBack
* Tilt Brush
* URL Shortener
* Voice Access
* Wavii
* Web Light
* WiFi

Chrome|

* Apps
* Chromium
* Dinosaur Game
* GreenBorder
* Remote Desktop
* Web Store
* V8

Images and
photography|

* Camera
* Lens
* Snapseed
* Nik Software
* Panoramio
* Photos
* Picasa
* Web Albums
* Picnik

Hardware

| Smartphones|

* Android Dev Phone
* Android One
* Nexus
* Nexus One
* S
* Galaxy Nexus
* 4
* 5
* 6
* 5X
* 6P
* Comparison
* Pixel
* Pixel
* 2
* 3
* 3a
* 4
* 4a
* 5
* 5a
* 6
* 6a
* 7
* 7a
* Fold
* 8
* 8a
* Pixel 9
* Pixel 9 Pro Fold
* Comparison
* Play Edition
* Project Ara

|

Laptops and tablets|

* Chromebook
* Nexus
* 7 (2012)
* 7 (2013)
* 10
* 9
* Comparison
* Pixel
* Chromebook Pixel
* Pixelbook
* Pixelbook Go
* C
* Slate
* Tablet

Wearables|

* Fitbit
* List of products
* Pixel Buds
* Pixel Watch
* Pixel Watch 2
* Pixel Watch 3
* Project Iris (unreleased)
* Virtual reality
* Cardboard
* Contact Lens
* Daydream
* Glass

Others|

* Chromebit
* Chromebox
* Clips
* Digital media players
* Chromecast
* Nexus Player
* Nexus Q
* Dropcam
* Liquid Galaxy
* Nest
* Smart Speakers
* Thermostat
* Wifi
* OnHub
* Pixel Visual Core
* Search Appliance
* Sycamore processor
* Tensor
* Tensor Processing Unit
* Titan Security Key

* v
* t
* e

Litigation

Advertising|

* Feldman v. Google, Inc. (2007)
* Rescuecom Corp. v. Google Inc. (2009)
* Goddard v. Google, Inc. (2009)
* Rosetta Stone Ltd. v. Google, Inc. (2012)
* Google, Inc. v. American Blind & Wallpaper Factory, Inc. (2017)
* Jedi Blue

Antitrust|

* European Union (2010–present)
* United States v. Adobe Systems, Inc., Apple Inc., Google Inc., Intel Corporation, Intuit, Inc., and Pixar (2011)
* Umar Javeed, Sukarma Thapar, Aaqib Javeed vs. Google LLC and Ors. (2019)
* United States v. Google LLC (2020)
* United States v. Google LLC (2023)

Intellectual property|

* Perfect 10, Inc. v. Amazon.com, Inc. and A9.com Inc. and Google Inc. (2007)
* Viacom International Inc. v. YouTube, Inc. (2010)
* Lenz v. Universal Music Corp.(2015)
* Authors Guild, Inc. v. Google, Inc. (2015)
* Field v. Google, Inc. (2016)
* Google LLC v. Oracle America, Inc. (2021)
* Smartphone patent wars

Privacy|

* Rocky Mountain Bank v. Google, Inc. (2009)
* Hibnick v. Google, Inc. (2010)
* United States v. Google Inc. (2012)
* Judgement of the German Federal Court of Justice on Google's autocomplete function (2013)
* Joffe v. Google, Inc. (2013)
* Mosley v SARL Google (2013)
* Google Spain v AEPD and Mario Costeja González (2014)
* Frank v. Gaos (2019)

Other|

* Garcia v. Google, Inc. (2015)
* Google LLC v Defteros (2020)
* Epic Games v. Google (2021)
* Gonzalez v. Google LLC (2022)

* Category

Related

| Terms and phrases|

* "Don't be evil"
* Gayglers
* Google (verb)
* Google bombing
* 2004 U.S. presidential election
* Google effect
* Googlefight
* Google hacking
* Googleshare
* Google tax
* Googlewhack
* Googlization
* "Illegal flower tribute"
* Rooting
* Search engine manipulation effect
* Sitelink
* Site reliability engineering
* YouTube poop

|

Documentaries|

* AlphaGo
* Google: Behind the Screen
* Google Maps Road Trip
* Google and the World Brain
* The Creepy Line

Books|

* Google Hacks
* The Google Story
* Google Volume One
* Googled: The End of the World as We Know It
* How Google Works
* I'm Feeling Lucky
* In the Plex
* The Google Book
* The MANIAC

Popular culture|

* Google Feud
* Google Me (film)
* "Google Me" (Kim Zolciak song)
* "Google Me" (Teyana Taylor song)
* Is Google Making Us Stupid?
* Proceratium google
* Matt Nathanson: Live at Google
* The Billion Dollar Code
* The Internship
* Where on Google Earth is Carmen Sandiego?

Others|

* "Attention Is All You Need"
* elgooG
* Predictions of the end
* Registry
* .app (top-level domain)
* .dev
* g.co
* .google
* Pimp My Search
* Relationship with Wikipedia
* Sensorvault
* Stanford Digital Library Project

* Italics indicate discontinued products or services.
* Category
* Commons
* Outline
* WikiProject

*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template