🔍 Sheet Radar AI — Data Quality Monitor for Google Sheets

Part of the WITI Google Workspace Suite by Sanadidari SARL

AI-powered Google Sheets add-on that scans your data for anomalies, outliers, formatting errors, and trends. Acts as an automated data quality auditor powered by Google Gemini.

Features

• Anomaly detection (outliers, inconsistencies, format errors)
• Trend analysis across data columns
• Natural language summary of findings
• 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 🔍 Sheet Radar AI menu will appear

Security

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

---

Built by Samir Chatwiti · Sanadidari SARL