Apps Script Tutorial

This repository contains a tutorial on how to use Google Apps Script to automate tasks.

Usage

The automation is implemented as a Google Apps Script that adds a custom menu to Google Sheets. Users can:

1. Select a row with event data in the spreadsheet
2. Use the new menu to trigger various automation functions
3. Send emails, generate calendar content, create folders, or generate HTML

Sync configuration with clasp

First, you need to install clasp:

npm install -g @google/clasp

Then, you need to login to clasp:

clasp login

Take the script ID from the Google Apps Script, on the left side of the screen, "Project Settings" > "Script ID":

clasp clone <script-id>

To sync the configuration with clasp, run the following command:

clasp push

To pull the configuration from the Google Apps Script, run the following command:

clasp pull