SSI Toolkit

A Google Sheets add-on for AI-assisted investigations.

• Recipes — curated, AI workflows; run an existing recipe or write your own!
• Run AI Inference — Fully configurable Gemini API inference over spreadsheet rows, with text, multimodal file support and tool calling.
• Import Drive Links — Bulk copy files from a Drive folder
• Extract Text — pull text from Drive links directly into a spreadsheet; Available for Docs, PDFs, and images (OCR via temporary Doc conversion)
• Sample Rows — reproducible dataset sampling; good for rapid prompt refinement.

Built with TypeScript, bundled by Rollup, and deployed via clasp.

Note: Avoid making changes in the online Apps Script editor — they will be overwritten on the next deploy.

Prerequisites

• A Google account
• Node.js 22+
• Apps Script API enabled at script.google.com/home/usersettings
• A Gemini API key (required for Run AI) — get one here

@google/clasp is included as a devDependency — no global install needed.

Getting Started

1. Create an Apps Script project

The toolkit can run as either a Container-bound Script (attached to a specific Sheet) or an Editor add-on (deployable org-wide). If you're just exploring, use a Container-bound Script.

Follow Google's instructions to create your project, then find it at script.google.com.

2. Enable the Drive Advanced Service

In the script editor: Editor → Services → find Drive API → select V3 → Add. Required for the Extract Text tool.

3. Set your Gemini API key

In the script editor: Project Settings → Script Properties → add GEMINI_API_KEY with your API key. Required for Run AI.

4. Get the script ID

In the script editor: Project Settings → copy the Script ID.

5. Create .clasp.json

At the project root:

cat > .clasp.json << 'EOF'
{
  "scriptId": "<your-script-id>",
  "rootDir": "./dist"
}
EOF

6. Install and deploy

npm install
npm run clasp:login    # authenticate with Google
npm run deploy         # build + push to Apps Script

After deploying, the toolkit appears in your Sheet as ⚡ SSI Toolkit (Container-bound) or under Extensions → SSI Toolkit (Editor add-on).

Development

# Build
npm run build               # clean build to dist/
npm run build:watch         # rebuild on file changes

# Deploy
npm run deploy              # build + push to HEAD (development)
npm run deploy:watch        # continuous build + push

# Test
npm test                    # run all tests
npm run test:watch          # watch mode
npm run test:coverage       # with per-file coverage thresholds

# Quality
npm run lint                # ESLint
npm run typecheck           # type-check without building
npm run format:check        # check Prettier formatting

# Utilities
npm run clasp:open          # open Apps Script editor in browser
npm run clasp:logs          # tail execution logs

Further Reading

• Architecture — server/client split, build pipeline, tool system
• Contributing — testing patterns, code style, how to add features
• Releasing — deployment lifecycle and release process