SheetGuard keeps your spreadsheet data clean and consistent by letting you define rules that automatically enforce what users must fill in — based on what they've already entered.

How it works:
Set a condition (e.g. "Status equals Approved") and SheetGuard will require that specific columns are filled before the row is accepted. If a user tries to leave required fields blank, the change is reverted and they're notified instantly.

Key Features:

Conditional Rules — Trigger requirements based on cell values (equals, not equals, greater/less than, is not empty)

Required Field Enforcement — Define which columns must be filled when a condition is met

Instant Violation Alerts — A toast notification appears the moment a rule is broken, with the row reverted automatically

Enable / Disable Rules — Pause rules without deleting them

Reorder Rules — Control evaluation priority with up/down controls

Edit Rules in Place — Update any rule without deleting and recreating it
Export / Import Rules — Back up or share rule sets as JSON

Duplicate Detection — Find redundant rules with one click

Per-sheet Rules — Rules apply to the active sheet and switch automatically when you change tabs

Owner-only Editing — Collaborators can see rules but only the owner can modify them

Free Plan:

1 rule per sheet
1 condition per rule
Pro Plan — $5.99/month:

Up to 25 rules per sheet
Unlimited conditions per rule
AND / OR logic between conditions
Cross-column comparisons
Custom required values (must equal a specific value, not just be non-empty)
Rules across all sheets
------------------------------------------------------------------------------------------------------------
Google Sheets™ and Google Workspace™ are trademarks of Google LLC. SheetGuard is an independent add-on and is not affiliated with, endorsed by, or sponsored by Google LLC.