📋 FlashBoard AI — Instant Dashboard Generator for Google Sheets

Part of the WITI Google Workspace Suite by Sanadidari SARL

AI-powered Google Sheets add-on that analyzes your raw data and generates a complete visual dashboard (charts, KPIs, summaries) in seconds using Google Gemini.

Features

• Analyzes spreadsheet structure and headers automatically
• Generates charts, pivot views, and KPI cards via Gemini 2.5
• User-defined goal input ("I want to track sales by region")
• Credit-based usage system per user

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 ⚡ FlashBoard AI menu will appear

Security

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

---

Built by Samir Chatwiti · Sanadidari SARL