With node 12+, run : npm ci
Then, on a daily basis, execute ./create-new.sh script everyday to prepare your workspace with new content (source, tests, inputs)
-
Authenticate with
clasp(google app script CLI) withnpx clasp login(follow instructions)
Note:claspis a CLI to manage your Google App Scripts, and it's powered by Google (more infos here) -
Enable app script API here : https://script.google.com/home/usersettings
-
Reference a google app script :
- If you want a standalone appscript (without any backed google spreadsheet linked to it),
run
npx clasp create --type api: a new google app script should be created under your google account (url to edit it will be provided)
⚠️ In that case, a.clasp.jsonis going to be created and should not be added into git, otherwise people may have access to your script ! - If you already have a google spreadsheet, open its linked Google App Script (through
Extensionsmenubar) and create a.clasp.jsonfile at the root of this repository, with following content :{"scriptId":"<Put here the google app script id you can find in the url when opening it>"}⚠️ Like above, don't add this file into git, as it may represent a security issue.
- If you want a standalone appscript (without any backed google spreadsheet linked to it),
run
-
Run
npx clasp push(ornpx clasp push --watchif you want to edit/auto-deploy some changes made to the script)Manifest file has been updated. Do you want to push and overwrite?=> Answer "Yes" here Files are going to be compiled and pushed into your Google App Script.
-
Open your app script at any moment by running
npx clasp open