How to Set Up Alerts in Google Sheets

Get notified when a value exceeds a threshold, a status changes, or a deadline passes. Visual alerts for people looking at the sheet, email alerts for everyone else.

Types of alerts

Visual alerts change a cell’s appearance when a value is too high, too low, or matches a keyword. This is conditional formatting. It helps people spot problems when they’re looking at the sheet.

Email alerts send a notification when a value changes. This helps people catch problems when they’re not looking at the sheet.

The most effective setup uses both: conditional formatting for anyone viewing the sheet, email alerts for the right person even when they’re away.

Visual alerts with conditional formatting

1. Select the cells to monitor (e.g., column D — Quantity)
2. Format → Conditional formatting
3. Set the rule: “Less than” → 10
4. Choose formatting (red background, bold text)
5. Click Done

Stack multiple rules: yellow for 10-20, red for below 10. Any cell that matches turns red automatically.

Email alerts

Google’s built-in option (Tools → Notification settings) sends email on any change, but can’t filter by value. There’s no way to say “only email me when column D drops below 10.”

Conditional email alerts

With Notifications for Google Sheets, create rules that combine column targeting and value conditions:

• Threshold: Email purchasing when Quantity drops below 10
• Status: Email the team when Status changes to Critical
• Deadline: Email the PM when Due Date is past and Status is not Complete
• New entry: Email support when a new row is added

Alert recipes for common situations

Budget tracker

Visual: Yellow when >80% of budget, red when >100%. Email: Notify finance when any department exceeds budget.

Inventory

Visual: Red for out-of-stock, yellow for low. Email: Alert warehouse when items drop below reorder threshold.

Project deadlines

Visual: Highlight overdue tasks. Email: Alert the project lead for overdue items.

Employee PTO

Visual: Green >10 days, yellow 5-10, red <5. Email: Alert HR when a new PTO request is submitted.

Grade tracker

Visual: Red for failing (<60), yellow for at-risk (60-70). Email: Alert the teacher when a student average drops below 65.

Best practices

Combine visual and email

Visual helps people looking at the sheet. Email helps everyone else. Use both for critical metrics.

Don’t over-alert

Too many alerts leads to alert fatigue. Only email for things that require action. Use formatting for informational indicators.

Include actionable context

“Cell D5 changed” isn’t helpful. “Widget X inventory dropped to 3 (minimum: 10). Reorder link: [link]” is actionable.

Test your alerts

After setup, trigger the alert intentionally. Change a value to the alert condition and verify the email arrives.