Skip to content

** New: Detect Hardcoded Magic Numbers

The automated auditor for Google Sheets. Detect risky VLOOKUPs, fix reference drift, and quantify spreadsheet risk in seconds.

** Privacy-first: by default, spreadsheet content stays in Google Sheets.

Demo

See SheetSage in action

A 2-minute walkthrough of Scan -> Fix -> Rollback (snapshots), and how the health score improves.

Available now on Google Workspace Marketplace.

Why Analysts Trust SheetSage

5+ Rules

Covering exact matches, anchoring, and hardcoded values.

1-Click Fix

Safely patch 1,000+ formula errors instantly.

100% Local

Code runs in your sheet. No spreadsheet data exfiltration.

It’s not just a spell-checker. It’s an auditor.

Most errors in financial models come from lookup failures and formula drift. SheetSage targets the root causes.

VLOOKUP Hygiene

Detects missing FALSE arguments that cause approximate matching disasters. Also flags invalid column indices.

Drift Protection

Finds lookup ranges like A1:B10 that lack $ anchors, preventing them from shifting when you copy formulas down.

Magic Number Detection

Spot hardcoded thresholds (e.g., * 1.05) buried in formulas. Extract them to assumption cells for better maintainability.

Smart Clustering

Don’t fix 5,000 rows one by one. SheetSage groups repeated formulas into a single "Cluster," letting you fix the pattern instantly.

Snapshot & Restore

Every fix creates a hidden snapshot. If a fix breaks your logic, hit "Restore" to revert instantly. Zero risk refactoring.

Privacy First

Built on Apps Script. Analysis happens within your Google session. No spreadsheet data, formulas, or cell values are sent to external servers (licensing uses an anonymous client ID only).

Audit your workbook in 3 steps

1

Launch & Scan

Open Extensions > SheetSage. Click "Scan Workbook" to analyze every formula in seconds.

2

Review Priorities

See your Health Score. Issues are ranked by risk and clustered by formula pattern.

3

Fix with Confidence

Apply auto-fixes for VLOOKUPs or anchoring. Use guidance to refactor hardcoded values.

Privacy Policy

Enterprise-friendly by design: audit locally, keep control, and share only what you choose.

Effective date: 30 December 2025

Privacy at a glance

• ✓Runs inside Google Sheets (Apps Script) under your Google session.
• ✓No spreadsheet content is sent to our servers by default.
• ✓Subscription checks (if you upgrade) send only an anonymous client ID (no formulas, values, or sheet names).
• ✓Snapshots stay in your workbook (hidden snapshot sheet) so restores are instant.
• ✓Local-only metrics (optional): stored in Google Apps Script properties; no formulas, sheet names, or cell addresses.
• ✓You control sharing: nothing leaves unless you copy/export a summary or send info to support.

Read the full policy

The complete Privacy Policy and Terms are available as standalone pages.

1) Who we are

SheetSage (“we”, “us”) is a Google Sheets add-on that scans a workbook for risky formula patterns and provides safer fixes with rollback. For privacy questions, contact privacy@sheetsage.co.

2) Scope

This Privacy Policy applies to the SheetSage add-on, and our website/documentation. It does not govern Google’s handling of your data inside Google Workspace. Your use of Google Sheets, Drive, and Apps Script is subject to Google’s own terms and privacy policies.

3) Roles (enterprise context)

In most enterprise deployments, you (or your organization) are the Data Controller for workbook content, and SheetSage acts as a Data Processor / Service Provider to provide the add-on’s functionality. If your procurement process requires it, we can provide a Data Processing Addendum (DPA) upon request.

4) What SheetSage processes

A) Workbook content (processed locally)

To scan and fix issues, SheetSage may read workbook formulas and ranges and may write fixes you initiate. Processing happens inside your Google environment.

• SheetSage scans formulas to evaluate rules (e.g., lookup hygiene, anchoring, and hardcoded constants).
• Some checks intentionally scan A1 formulas (not R1C1) to reduce false positives; R1C1 is used primarily to cluster “copied-down” patterns.
• SheetSage does not require reading the entire workbook’s values to operate; it focuses on formulas and the minimum context needed to apply the selected fix.

B) Snapshots & restore (stored in your workbook)

When you apply a fix, SheetSage creates a restorable snapshot in a hidden sheet (e.g., SheetSage_SNAPSHOT) so you can revert changes if needed. Snapshots live in the workbook, under your Google access controls.

C) Local-only metrics (privacy-first)

SheetSage may maintain best-effort product metrics designed to stay local:

• Per-user metrics in Apps Script User Properties
• Workbook-level adoption metrics in Apps Script Document Properties
• No formulas, sheet names, or cell addresses are stored as metrics.
• Nothing is sent anywhere by default; data only leaves if you copy/export a summary or share it with support.

D) Support data (only if you choose to share)

If you contact support, we’ll process what you send us (e.g., your email, message content, screenshots, logs, or sample formulas). We use it only to resolve your request and improve reliability.

5) What we do not do

• We do not sell your personal information.
• We do not transmit your spreadsheet’s cell values or formulas to our servers by default.
• We do not run advertising-based profiling on your workbook content.

6) Subprocessors & third parties

SheetSage runs on Google Workspace and Apps Script infrastructure. Google is a core platform provider for the add-on. If we introduce additional subprocessors (e.g., for billing, support, or error monitoring), we will publish an up-to-date list and update this Policy as required.

7) Data retention

• Workbook content: processed locally; not stored on our servers by default.
• Snapshots: stored in your workbook and retained according to your workbook’s lifecycle and your Google policies.
• Support data: retained only as long as necessary to resolve issues and meet legal/operational requirements (typically as needed).

8) Security

We apply reasonable technical and organizational measures designed to protect the information we process (e.g., access controls for support systems). Workbooks and snapshots remain protected by your Google account and Workspace controls. No method of transmission or storage is 100% secure, but we work to maintain appropriate safeguards.

9) Your choices & controls

• You can uninstall SheetSage at any time.
• You can review and revoke permissions in your Google account settings.
• You control whether to share any summaries/logs with support.

10) International transfers

If support data is processed outside your country, we will take steps to apply appropriate safeguards where required (e.g., contractual protections).

11) Your privacy rights

Depending on your jurisdiction, you may have rights to access, correct, delete, or restrict processing of your personal information. To submit a request, contact privacy@sheetsage.co. We may need to verify your identity.

12) Changes to this policy

We may update this Policy from time to time. We will post the updated version and revise the effective date above. If changes are material, we will provide additional notice where required.

Contact

Email: privacy@sheetsage.co Company: SheetSage Address: New Zealand

Install SheetSage

Now live on Google Workspace Marketplace. Install in a couple of clicks.

Requires Google Sheets - No credit card required