How to send an email when a Google Sheets cell crosses a limit
By Jake Marsh · Updated
To get an email when a Google Sheets cell crosses a limit, create a report in Scheduled Sheet Reports, open Only send when..., type the cell (such as Inventory!C2) under Only when this cell..., pick a rule like is less than and a value like 20, and set When to how often to check, such as every 2 hours on workdays. The report is checked at each of those times and sent only when the rule is true.
Rules you can use
| Rule | Example |
|---|---|
| is more than, is at least | Budget!D5 is more than 10000 |
| is less than, is at most | Inventory!C2 is less than 20 |
| equals, is not | Status!B1 equals Late |
| contains | Tickets!A2 contains urgent |
| is empty, is not empty | Signups!B2 is not empty |
The rule looks at one cell. To watch something across many rows, add a cell that works it out, such as =COUNTIF(Stock!C2:C, "<20") for the number of products under 20, and set the rule to that cell is more than 0.
Steps
- Open Extensions, Scheduled Sheet Reports, Open reports, then New report.
- Pick What to send. Send the rows that explain the alert, such as the stock list, so the email shows what's low.
- Add yourself or the team as recipients.
- Write a subject that says what happened, for example
Low stock: {{Stock!F1}} products under 20. - Open Only send when... and set the cell, the rule and the value.
- Set When to how often to check. Every few hours with an hour range checks during work hours; Daily checks once a day.
- Click Save and schedule.
Only when something changed
Tick Skip when nothing changed since the last send to get an email only when the data is different from what was sent last time. This works on its own, without a cell rule, as a "tell me when this tab changes" alert, and together with a rule, so a low-stock alert doesn't repeat every two hours while nothing has moved.
How quickly it sends
Google runs add-on timers once an hour, so the add-on checks at the times your schedule sets, within that hour. That suits stock levels, budgets and status lists. It doesn't send the instant someone edits a cell, which would need a script that runs on every edit.
What it costs
Scheduled Sheet Reports is $6.99 a month or $59 a year per Google account. Free trial: 20 scheduled sends or 14 days, whichever comes first. No card needed. Every plan and the install link are on the Scheduled Sheet Reports page.
Scheduled Sheet Reports
Email a range or a whole sheet on a schedule, with a stop button that always works $6.99 a month or $59 a year per Google account.
Questions
Do skipped checks use up my trial?
No. A check where the rule isn't met is logged as skipped and doesn't count. Only a send does.
Where can I see when it checked?
The Send log lists the last 60 sends, skips, pauses and errors in the spreadsheet, with the time of each.
Can the rule use a cell on another tab?
Yes. Type the tab name, an exclamation mark and the cell, such as Summary!B2.
Can several people get the alert?
Yes. Add up to 50 recipients in To, Cc and Bcc.
More Scheduled Sheet Reports guides
- How to email each person only their rows from a Google Sheet
- How to email a Google Sheet as a PDF automatically