KOKOCAL SCRIPT

Guide

Apps Script Basics Guide

Review the basics before pasting a generated script into Google Apps Script.

1

What Apps Script is

Apps Script is Google's scripting environment for adding menus, sidebars, automation, and custom processing to Google Sheets, Google Slides, and related files.

2

Bound scripts

Many KOKOCAL SCRIPT generators are installed from the target Google file. This makes menus and sidebars easier to use, but the script must be added to each file where you want to use it.

3

Code.gs and HTML files

Paste the main script into Code.gs. Sidebar-based generators may also require an HTML file. Use the file names shown in the generated result.

4

First authorization

When you run a script for the first time, Google may ask you to authorize access. Review the requested permissions before allowing them.

5

Menus and triggers

Some scripts create custom menus with onOpen or install triggers for edits, form submissions, or scheduled processing.

6

Safe testing

Before using a script on business data, make a backup or test copy and follow the post-install review points.