Guide
Getting Started
This guide explains the common page structure, input flow, and generated result area used by KOKOCAL SCRIPT generators. If this is your first time, review the overall flow before generating a script.
Published: 2026.08.01Updated: 2026.08.01
Published generators and guides are available for free.
You can open generator pages and enter required fields without logging in.
Form inputs and generated scripts are not saved by the site. Save needed information yourself as files.
Generator page structure
Generator pages are made of an input column on the left and a generated result column on the right. Enter conditions on the left, agree to the terms, and generate. The right side then shows the code tab, setup steps, review points, and JSON.
Input column
This is where you enter the conditions needed to generate the script. You can also save and load settings here.
Generated result column
This is where you review the generated script and switch between setup and review information.
How to use the input column
Enter settings
Enter file IDs, sheet names, column names, processing conditions, and other fields required by each generator. Use the help icon beside a field name to understand what to enter.
Check notice blocks
If a generator has specific assumptions or operating conditions, they appear near the top of the input area. Confirm that they match your data before generating.
Agree to the terms
Before generating a script, you must agree to the terms of use. Review the risks around script use, execution results, data loss, and inconsistent sync, then create backups and use the script at your own responsibility.
Generate, save settings, and load settings
Use Generate to create the script. Save settings downloads the current inputs as a JSON file, and Load settings restores the input state from that JSON.
How to read the generated result column
The top of the generated result column shows generation status and a settings hash. Before generation it says not generated, and after generation it shows a hash that identifies the current settings.
Differences between Code, Setup, Review, and JSON
Code
Shows the executable script. Use the copy button in the code block to copy what you paste into Apps Script or another target environment.
Setup
Shows where to paste the generated script and which setup functions to run, in order.
Review points
Collects limitations, cautions, and post-install behavior checks. Use it as a checklist before real operation.
JSON
Shows the settings used for generation. Download it when you want to reuse or restore the same configuration later.
How to use the setup guide
After generation, use Download setup guide in the generated result column to save the information needed for setup. Since generated results disappear when you leave the page, saving the guide before installation is useful.
Markdown format (.md)
Save setup steps, post-install checks, generated scripts, and settings JSON as one text document. Even when code is long, this format keeps the setup steps easy to review first.
Word format (.docx)
Save a Word document for setup notes or internal sharing.
PDF save view
Open a print-friendly view and save it as PDF from your browser's print function.
What is saved and what is not saved
Not saved by the site
For security-conscious data handling, the site does not save generator form inputs, generated scripts, or settings JSON contents.
Can be saved locally
You can save settings JSON from Save settings or the JSON tab. The setup guide can save setup steps, review points, generated scripts, and settings JSON together.
When leaving the page
After generation, a confirmation dialog appears if leaving the page would discard the generated result.
Guide
Related Guides
If you are new to the service, also review Apps Script basics and notes for using multiple scripts together.
Apps Script Basics Guide
Review .gs files, HTML files, saving, first authorization, triggers, and other basics before setup.
Using Multiple Scripts Together
Check how to organize KOKOCAL_Menu.gs, feature files, the shared menu, triggers, and permissions when using multiple generated scripts.
Spreadsheet Append-Only Incremental Sync Guide
Review setup steps for append-only, fixed-row incremental sync from a source sheet to a destination sheet.