PublicMITGemini-only

Sheets Cell Audit Bot × SlimeTree-RLM (Gemini-only)

▸ Detect spreadsheet anomalies via RLM

Specify spreadsheet ID + range → RLM verdict per cell → D=normal / µ=anomaly (PII / formula error / empty) / R=Gemini contextual analysis.

1. Google API authentication (OAuth 2.0)

At console.cloud.google.com create an OAuth client → obtain a User Access Token. Scope: https://www.googleapis.com/auth/spreadsheets.readonly

2. Gemini (Google AI) API key

At aistudio.google.com/apikey you can issue a personal free key (15 RPM free; overflow is token-billed).

Platform-native LLM: Google Workspace processing is Gemini-only (managed under the same Google account).

2.5 Operation mode ★ NEW: B (in-Gemini tiering) ― shared module

Single LLM Cost-tier (B) ― per R cell, cheap analysis → judge → only shortfall to premium

3. Sheets cell audit (column-wise)

Specify spreadsheet ID + range (e.g., Sheet1!A:A) → RLM verdict per cell → D=normal / µ=anomaly (PII / formula error / empty) / R=Gemini contextual analysis.

cells: 0

D: 0

µ: 0

R: 0

4. API call log

(not yet run)

5. Benefits

PII mix-in detection: phone-number patterns matched by regex + µ
Mechanical formula-error detection: #REF! / #DIV/0! etc. at 0 tokens
Contextual analysis of anomalies: numerical outliers go to Gemini to read surrounding context
WAL chain: cell-level audit trail