↓Skip to main content

clasp

·331 words·2 mins·
Automation GSuite
Table of Contents

In this article I will go through clasp, a way to develop App Scripts locally

Intro
#

In this article I will go through clasp, a way to develop App Scripts locally and provide some example labs on how to take advantage of this scripts to automate your daily routines.

AppScripts
#

Apps Script is a cloud-based JavaScript platform that lets you integrate with and automate tasks across Google products.

Requirements
#

You need to use a node version compatible with the spec in package.json.

"node": "^12.20.0 || ^14.13.1 || >=16.0.0"

NOTE: Recent node versions would give you a warning regarding punycode [DEP0040] DeprecationWarning: The punycode module is deprecated. Please use a userland alternative instead. If that is the case use a lower node version.

Installation
#

npm install -g @google/clasp

Then enable the Google Apps Script API: https://script.google.com/home/usersettings

Login
#

The first step would go though login.

clasp login

This command will open a login page with OAuth and save the credential token on the following file .clasprc.json

This point on you can start implementing your scripts.

Codelab
#

The following URL provide a useful Codelab where you will create a repository and manage versions:

Samples
#

The following repo provide several samples that you can use or extend:

Codelab : Gsheet Fundamentals
#

The following URL provides a Codelab to extend functionality on a GSheet, fetching data from a public API and including Menu items.

ChatGPT
#

As most of the scripts that one will like to run are not complex, you may find what you are looking for through OpenAPI. I’ve been haviong good results with it and would advise to explore that path.

Conclusion
#

App Scripts are valuable tools for automating actions with your GSuite services. They offer a time-saving option for managing repetitive tasks. By using clasp, you can control your changes, test locally, and share your scripts with other team members efficiently.

References
#