How to Send Automatic Emails from Google Sheets
Google Sheets can send emails automatically when data changes, new rows are added, or conditions are met. Three ways to set it up.
What automatic emails means
Two common meanings: notification emails (“email me when the sheet changes”) and outbound emails (“email the person in column C when their row changes”). This guide covers both, focusing on notifications — the most common use case.
Method 1: Built-in notification rules
Tools → Notification settings → email on any change. Takes 30 seconds. No filtering, can’t customize content, only notifies you. Best for personal sheets where you want a simple heads-up.
Method 2: Apps Script
Write JavaScript in Extensions → Apps Script. Full control over conditions, recipients, and email content. Requires coding knowledge and an installable trigger (not the simple onEdit).
onEdit() trigger cannot send emails. You must create an installable trigger: Triggers → Add Trigger → From spreadsheet → On edit. Also, Apps Script has a 100 emails/day limit for personal Gmail (1,500 for Workspace).Method 3: Add-on (no code)
Notifications for Google Sheets gives you Apps Script-level flexibility without code:
- Watch specific columns or cells
- Set value conditions (equals, contains, greater than)
- Send to any email address
- Include old value, new value, and who made the change
Email content templates
Status change
Subject: [Sheet] — Row status changed to {{new_value}}
Body: {{editor}} changed row {{row}} from {{old_value}} to {{new_value}} on {{timestamp}}.
Threshold alert
Subject: Low inventory — {{item_name}}
Body: {{item_name}} is now {{quantity}}, below the minimum of 10. Please reorder.
New entry
Subject: New entry in {{sheet_name}}
Body: A new row was added by {{editor}} on {{date}}.
Google’s email sending limits
| Account type | Daily limit |
|---|---|
| Personal Gmail | 100 emails/day |
| Google Workspace | 1,500 emails/day |
Tips for reliable automation
1. Be specific about triggers
“Column E changes to Approved” is useful. “Any cell changes” is noise.
2. Include context in the email
“Your sheet was edited” is useless. Include what changed, who changed it, and the old/new values.
3. Test first
Test on a copy before applying to production. Make a few edits and verify emails arrive correctly.
4. Watch deliverability
Automated emails from Google Sheets go through Gmail and have good deliverability, but use clear subject lines and don’t send excessively.
Never miss a spreadsheet change again
Notifications for Google Sheets sends you email alerts when your spreadsheet is edited. No coding required. Set up in under a minute.
Get Started Free