⚡ AutoScript AI — Spreadsheet Automation for Google Sheets

Part of the WITI Google Workspace Suite by Sanadidari SARL

AI-powered Google Sheets add-on that automates repetitive tasks, generates scripts on demand, and executes complex spreadsheet operations through natural language instructions.

Features

• Natural language → Apps Script code generation via Gemini 2.5
• Multi-model fallback (gemini-2.5-flash → gemini-2.5-pro → gemini-2.0-flash → ...)
• Credit-based usage system per user
• Sidebar UI with task history

Stack

Google Apps Script · Google Gemini API · HTML Service · PropertiesService

Setup

1. Open the Google Sheets add-on editor and paste Code.gs
2. Run setupApiKey() from the Apps Script editor
3. Enter your Gemini API key when prompted
4. Reload the sheet — the ⚡ AutoScript AI menu will appear

Security

API keys are stored via PropertiesService.getScriptProperties() — never hardcoded.

---

Built by Samir Chatwiti · Sanadidari SARL