localization-script

Google Apps Script project for Google Sheets (localization utilities), managed locally with TypeScript and deployed via clasp.

Prerequisites

• Node.js 18+ and npm
• A Google account with access to Google Drive/Sheets
• Enable Google Apps Script API in your Google account if prompted during first login

Setup

1. Install dependencies

npm install

2. Authenticate clasp (opens a browser)

npm run login

3. Create a new standalone Apps Script project (one-time)

npm run create

This will generate a new script on your account and link it to this repo. It uses the src folder as the project root.

4. Push the local files to Apps Script

npm run push

5. Open the project in the browser editor

npm run open

Development

• Edit TypeScript sources in src/. The appsscript.json manifest also lives in src/.
• npm run push compiles to build/ and copies the manifest, then pushes from build/.
• In the Sheet, reload to see the custom menu “Localization”. Try the menu item to write a greeting into cell A1.

If you prefer a container-bound script (attached directly to a Sheet), create one in the Sheet’s Extensions > Apps Script, then use its Script ID in .clasp.json and continue with npm run push.

Notes

• The .clasp.json currently has an empty scriptId. The npm run create step will populate it automatically, or you can paste an existing Script ID if you already have one.
• Do not commit .clasprc.json (user auth). It's ignored via .gitignore.