Why IMPORTRANGE does not trigger conditional notifications

An external change imported through IMPORTRANGE is not a supported conditional-notification trigger. Seeing a new value in your dashboard does not mean an email rule will fire. Google’s help explicitly identifies changes from other files, including IMPORTRANGE, as a limitation. Conditional notification limitations

This is a diagnostic guide. It does not require a script, third-party add-on, paid API, scheduled job, or sending test mail to colleagues.

Check feature availability first

Use the Google Sheets web app on a computer. Conditional notifications are available only to certain work or school accounts. Google’s corrected September 2025 announcement lists:

• Business Standard and Business Plus
• Enterprise Starter, Standard and Plus
• Education Plus
• Enterprise Essentials

The announcement raises the limit to 20 rules per spreadsheet and notes that its original availability list was corrected. Do not rely on copied announcements claiming universal personal-account support. Confirm your actual edition and menu availability with your administrator. Google’s corrected availability and rule-limit announcement

A rule creator needs owner or edit access. Receiving an alert is a separate question from being able to configure the feature. Google’s feature introduction

1. Trace where the changed value originates

Consider two synthetic files:

Source file, tab Stock, A1:B3

Item	Quantity
Notebook	12
Pen	4

Dashboard file, A1

=IMPORTRANGE("SOURCE_SPREADSHEET_URL","Stock!A1:B3")

Replace the placeholder only in your own authorized practice files. If access is not already established, review the source and destination audiences before connecting them: destination editors can use an authorized connection to import other parts of that source. IMPORTRANGE documentation

A proposed rule watches dashboard B2:B3 for quantities below 5. The source owner changes Notebook from 12 to 3. After import refresh, the dashboard may correctly show 3. That update still belongs to the unsupported external-data case. The expected business state is now two low-stock items; that is a data result, not proof of notification delivery.

For diagnosis, write down four facts: source value, displayed destination value, rule trigger range, and event time. This separates a stale import from a missing notification without repeatedly rebuilding formulas.

2. Inspect the existing rule and history

Open Tools → Conditional notifications, inspect the rule’s range and conditions, then choose View trigger history. History covers 30 days. A successful run does not guarantee immediate delivery; notifications can be delayed or consolidated, and undone changes may prevent mail. Only individual Gmail or Workspace recipients are supported, not group addresses or non-Google providers. Rule settings, recipients and history

Use the evidence to narrow the fault:

Observation	What to investigate
Dashboard still shows 12	The import connection or refresh, before email behavior
Dashboard shows 3 but no corresponding history event	External-data trigger limitation
History records a failed or partial run	The rule and notification processing details
A successful entry exists but inbox is empty	Delivery timing, recipient configuration, and whether the change was undone

Do not overwrite the imported array with a manual quantity to “repair” the dashboard. That breaks the data pipeline and changes the problem being tested.

3. Choose a workflow that matches the event

For people typing stock changes: Consider putting a notification rule in the source spreadsheet, on the actual manually edited quantity column, if its owner approves the rule and recipients. Test a harmless synthetic edit with an authorized recipient before relying on it. This moves the rule to where the edit happens; it does not make an external refresh a supported event.

For a dashboard fed entirely by other systems: Treat the sheet as a review surface. A source system’s own supported alerting may be a better fit. Investigate its event, permissions, delivery guarantees and costs separately. Do not assume a rule moved one file upstream will help if that source is itself externally refreshed.

For a manual low-stock review: Use a separate review output such as the FILTER function to list low quantities, and have the responsible person check it as part of the existing operating process. The formula is a view of the data, not an email sender.

Avoid misleading fixes

Wrapping the imported result in IF does not establish a documented notification guarantee. Neither does applying a new number format. Google’s help also warns that volatile formulas can miss updates while the document is closed; adding TODAY or NOW is not a dependable workaround. Other trigger limitations

Do not infer that changing recalculation settings converts imported changes into supported notification events. Do not use silence from the inbox as proof that inventory is healthy. For time-critical stock decisions, keep an independently verified operational check until an appropriate alerting workflow has been tested.

Verification and limits

For the example, Notebook 12 → 3 changes the number of items below 5 from one to two. That arithmetic was independently checked. The missing-email conclusion comes from Google’s documented trigger limitation, not from a mail-delivery experiment.

Testing disclosure: Official documentation reviewed October 16, 2026. This tutorial has not been tested in Google Sheets. No rule was created, no email was sent, and no scheduled automation was installed. Account availability, actual refresh timing and delivery behavior require validation in the relevant account.