Skip to content
Setup a local development environment for Google Apps Script and write your code in modern JavaScript.
Branch: master
Clone or download
Latest commit 44442d8 May 21, 2019
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.vscode Fix relative paths 🙂 Apr 23, 2019
src Auto fix linting errors 🎨 Apr 24, 2019
.babelrc Support ES7 Array.includes Oct 29, 2018
.claspignore Support ES7 Array.includes Oct 29, 2018
.eslintignore 🐢 Aug 19, 2018
.eslintrc Fix relative paths 🙂 Apr 23, 2019
.gitignore 🐢 Aug 19, 2018
.prettierrc Google Apps Script Jun 13, 2018
LICENSE Google Apps Script Jun 13, 2018
README.md Typo May 22, 2019
appsscript.json Scopes Updated Apr 13, 2019
package-lock.json Updated dependencies 👮‍♂ May 22, 2019
package.json Updated dependencies 👮‍♂ May 22, 2019
scopes.md Google APIs May 1, 2019
webpack.config.js Auto fix linting errors 🎨 Apr 24, 2019

README.md

Google Apps Script Development with ES6

Google Apps Script Development 💯

Please follow the 👉 step-by-step video tutorial 👈 for quickly getting started with Apps Script development inside Visual Studio Code. You can build GSuite add-ons, web applications and workflow automation routines with next-generation JavaScript.

Build with Google Apps Script 🚀

The Apps Script Starter kit makes it easy for you to setup a modern development environment and build workflow. Here's everything that's included in the starter kit to get you started:

Babel

Write code using ES6 features like arrow functions, destructuring, classes, template literals, and the Babel transpiler will transform your ECMAScript 2015/2017 code to ES5 that Apps Script can understand.

Webpack

Webpack is a powerful tool for bundling JavaScript modules. Developers can structure code in directory and Webpack creates a minimized and optimized bundle for pushing to production.

ESLint

A popular linting engine that analyzes your JavaScript code for correctness and highlights the errors in real time before you even compile the code, thus reducing the development time.

Google CLASP

A command line utility for working with Google Apps Script projects. You can develop code locally and push it to production, manage your manifest file, deploy web apps and publish new versions of apps.

Visual Studio Code

This incredibly powerful source code editor from Microsoft provides an integrated development environment and has built-in support for Emmet, Intellisense for code autocompletion, Command Line Terminal, Git integration, Node.js , TypeScript and more.

Prettier

A code formatter that will beautify your JavaScript, JSON, HTML and CSS stylesheets according to a set of rules and styles widely accepted by programmers.

Airbnb

Developers have their own unique style of writing code. Airbnb's JavaScript style guide outlines how JavaScript code should be written and adheres to the rules.

Getting Started 🏃🏼

Google Apps Script - Setup Development Environment

Setting up a modern development environment for building Google Apps Script projects is easy and quick (video tutorial). You also need to install Node.js which includes the npm package manager.

1. Clone the repository and install npm dependencies

git clone https://github.com/labnol/apps-script-starter my-project
cd my-project
npm install

2. Log in to Google clasp and authorize with your Google account.

npx clasp login

3. Create a new Google Script bound to a Google Sheet (or set the type as standalone to create a standalone script in your Google Drive)

npx clasp create --type sheets --title "My Apps Script Project" --rootDir ./dist

4. Include the necessary OAuth Scopes in the appsscript.json file

5. Deploy the project

npm run deploy

The dist directory contains the bundled code that is pushed to Google Apps Script.

Using Git with Google Apps Script

Google Apps Script - Github

Create a new repository in Github and make a note of the URL of the new repository. Next, open the terminal and run the above commands to push your Apps Script project to Github.

About the Developer 👨🏼‍💻

Amit Agarwal is a web geek and author of labnol.org, a popular tech how-to website. He frequently uses Google Apps Script to automate workflows and enhance productivity.

The starter kit is used by Digital Inspiration for building popular Google add-ons including Gmail Mail Merge, Google Forms Notifications and Document Studio.

Reach the author on Twitter or email amit@labnol.org

Contributions 🙏🏼

Contributions and feature requests are welcome. If you are using the Google Apps Script starter package and fixed a bug for yourself, please consider submitting a PR!

License 📄

MIT License (c) Amit Agarwal

You can’t perform that action at this time.