Apps Script – Google Apps Script

<!DOCTYPE html> <html class="google mmfb" lang="en"> <head><script type="text/javascript" src="/_static/js/bundle-playback.js?v=HxkREWBo" charset="utf-8"></script> <script type="text/javascript" src="/_static/js/wombat.js?v=txqj7nKC" charset="utf-8"></script> <script>window.RufflePlayer=window.RufflePlayer||{};window.RufflePlayer.config={"autoplay":"on","unmuteOverlay":"hidden"};</script> <script type="text/javascript" src="/_static/js/ruffle/ruffle.js"></script> <script type="text/javascript"> __wm.init("http://web.archive.org/web"); __wm.wombat("https://www.google.com/script/start/","20230318022559","http://web.archive.org/","web","/_static/", "1679106359"); </script> <link rel="stylesheet" type="text/css" href="/_static/css/banner-styles.css?v=S1zqJCYt" /> <link rel="stylesheet" type="text/css" href="/_static/css/iconochive.css?v=3PDvdIFv" />  <script nonce="2n5J8JMyeAbWcpqwJPGHCw"> (function(H){H.className=H.className.replace(/\bgoogle\b/,'google-js')})(document.documentElement) </script> <meta charset="utf-8"> <meta content="initial-scale=1, minimum-scale=1, width=device-width" name="viewport"> <title> Apps Script – Google Apps Script </title> <script src="//web.archive.org/web/20230318022559js_/https://www.google.com/js/google.js" nonce="2n5J8JMyeAbWcpqwJPGHCw"> </script> <script nonce="2n5J8JMyeAbWcpqwJPGHCw"> new gweb.analytics.AutoTrack({profile:"UA-32892866-1"}); </script> <link href="//web.archive.org/web/20230318022559cs_/https://fonts.googleapis.com/css?family=Open+Sans:300,400,600,700|Product+Sans:400&lang=en" rel="stylesheet" nonce="2n5J8JMyeAbWcpqwJPGHCw"> <link href="//web.archive.org/web/20230318022559cs_/https://www.google.com/css/maia.css" rel="stylesheet" nonce="2n5J8JMyeAbWcpqwJPGHCw"> <meta content="Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with Google Workspace." name="Description"> <link href="//web.archive.org/web/20230318022559im_/https://www.google.com/images/icons/product/script-16.png" rel="icon"> <script src="//web.archive.org/web/20230318022559js_/https://www.google.com/js/gweb/ui/lightbox.js" nonce="2n5J8JMyeAbWcpqwJPGHCw"> </script> <style> @import url(//web.archive.org/web/20230318022559cs_/https://www.google.com/css/gweb/lightbox.css);#as-home{}#as-home-hero-1 h1{color:#1192FB;font-size:45px;font-weight:300;line-height:1.2;margin:7px 0 27px}#as-home-hero-1 p{margin:0 0 16px;font-weight:600;font-size:15px;color:#444}#as-home-hero-1 #as-home-hero-buttonp{margin:20px 0 0 0}#as-home-hero-1 ul{list-style:none;margin:40px 0 40px 0;padding:0}#as-home-hero-1 ul li{float:left;padding:12px 0 0 0;margin:0 30px 30px 0;border-width:2px 0 0;border-style:solid;font-size:13px;color:#737373;width:127px}#as-home-hero-1 ul li h2{color:#444;margin:0 0 13px 0;display:block;font-weight:600;font-size:15px}#as-home-hero-1 .as-home-hero-li1{border-color:#14982D}#as-home-hero-1 .as-home-hero-li2{border-color:#d3152c}#as-home-hero-1 .as-home-hero-li3{border-color:#ecb12e}#as-home-hero-2{text-align:center}#as-home-hero-2 img{margin:118px 0 0 0;width:100%}#as-home-pslots{border-top:1px solid #d7d7d7;padding:20px 0 0 0}#as-home-pslots h3{color:#444;font-size:24px;line-height:26px;font-weight:300;margin:6px 0 20px 0}#as-home-pslots-1{}#as-home-pslots-2{}#as-home-pslots-3{}#as-home-pslots p{} </style> </head> <body> <div class="maia-header" id="maia-header" role="banner"> <div class="maia-aux"> <h1> <a href="/web/20230318022559/https://www.google.com/"><img alt="Google" src="//web.archive.org/web/20230318022559im_/https://www.google.com/images/branding/googlelogo/1x/googlelogo_color_116x41dp.png" srcset="//web.archive.org/web/20230318022559im_/https://www.google.com/images/branding/googlelogo/2x/googlelogo_color_116x41dp.png 2x"> Apps Script</a> </h1><a class="maia-teleport" href="#content">Skip to content</a> </div> </div> <div class="maia-nav" id="maia-nav-x" role="navigation"> <div class="maia-aux"> <a class="maia-button" data-location="top right" href="http://web.archive.org/web/20230318022559/https://script.google.com/intro" id="nav-button">Start Scripting</a> <ul> <li class="active">Home </li> </ul> </div> </div> <div id="maia-main" role="main"> <div class="maia-teleport" id="content"></div> <div id="as"> <div class="maia-cols" id="as-home"> <div class="maia-col-6" id="as-home-hero-1"> <h1> Build web apps and automate tasks with Google Apps Script </h1> <p> Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with Google Workspace. </p> <p id="as-home-hero-buttonp"> <a class="maia-button" data-location="body" href="http://web.archive.org/web/20230318022559/https://script.google.com/intro" id="body-button">Start Scripting</a> </p> <ul> <li class="as-home-hero-li1"> <h2> Build with Google </h2>Feature-rich APIs let you extend Google services and build your own web applications. </li> <li class="as-home-hero-li2"> <h2> Code on the Web </h2>A web browser is all you need to build with Google Apps Script. </li> <li class="as-home-hero-li3"> <h2> Share your App </h2>Store and share your projects in Google Drive or publish on the Chrome Web Store. </li> </ul> </div> <div class="maia-col-6" id="as-home-hero-2"> <a class="as-lightbox" data-lightbox-height="315" data-lightbox-width="560" href="//web.archive.org/web/20230318022559/https://www.youtube.com/watch?v=JJgmU_JUsug" onclick="_gaq.push(['_trackEvent','Video','Play']);" title="Overview of Google Apps Script"><img alt="" id="video-overlay" src="/web/20230318022559im_/https://www.google.com/script/start/as-playvid.png"> <label>Watch an overview of Google Apps Script</label></a> </div> </div> <div class="maia-cols" id="as-home-pslots"> <div class="maia-col-4" id="as-home-pslots-1"> <h3> Get Started </h3> <p> Tutorials and guides to take you from writing your first script to building your application. </p> <p> <a href="http://web.archive.org/web/20230318022559/https://developers.google.com/apps-script/articles">Learn more »</a> </p> </div> <div class="maia-col-4" id="as-home-pslots-2"> <h3> Example Scripts </h3> <p> From productivity tools to enterprise automation, see what you can build with Google Apps Script. </p> <p> <a href="http://web.archive.org/web/20230318022559/https://developers.google.com/apps-script/case-studies">Learn more »</a> </p> </div> <div class="maia-col-4" id="as-home-pslots-3"> <h3> Developer Reference </h3> <p> Complete documentation with everything you need to know as you build with Google Apps Script. </p> <p> <a href="http://web.archive.org/web/20230318022559/https://developers.google.com/apps-script/">Learn more »</a> </p> </div> </div> </div> </div> <div id="maia-signature"></div> <div class="maia-footer" id="maia-footer"> <div id="maia-footer-global"> <div class="maia-aux"> <ul> <li> <a href="/web/20230318022559/https://www.google.com/">Google</a> </li> <li> <a href="/web/20230318022559/https://www.google.com/intl/en/about/">About Google</a> </li> <li> <a href="/web/20230318022559/https://www.google.com/intl/en/policies/privacy/">Privacy</a> </li> <li> <a href="/web/20230318022559/https://www.google.com/intl/en/policies/terms/">Terms</a> </li> </ul> </div> </div> </div> <script nonce="2n5J8JMyeAbWcpqwJPGHCw"> var asLightbox = new gweb.ui.LightBox('as-lightbox'); asLightbox.setAnimate(true); asLightbox.setScaleImages(true); asLightbox.setOutsideNav(true); asLightbox.init(); </script> <script src="/web/20230318022559js_/https://www.google.com/script/start/js/script.min.js" nonce="2n5J8JMyeAbWcpqwJPGHCw"> </script> <script src="//web.archive.org/web/20230318022559js_/https://www.google.com/js/maia.js" nonce="2n5J8JMyeAbWcpqwJPGHCw"> </script> </body> </html>

CINXE.COM

Apps Script – Google Apps Script