Check supported country options when sheet criteria change
Update a monitored range and have Autom return supported country matches for a quick review.
Trigger
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Action
Google Countries
Tool to list google-supported countries. use when you need to filter or suggest countries based on a search string.
Why this helps
A changed market brief can leave country eligibility or targeting options unchecked.
- Run a country lookup when monitored criteria change.
- Use the changed range as the lookup context.
- Review supported country matches in the run report.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Autom once in the Notis portal.
- 2Create an automation in Automations with a prompt to use the changed range's search phrase to list matching Google-supported countries.
- 3Pick Cell Range Values Changed as the trigger and select the range to monitor.
- 4Choose where run reports should go, then test with one real range change.
Questions about this workflow
What change starts the lookup?
A value change in the specified A1 range starts the workflow. Use the range for a country search phrase or related criteria.
Does the workflow validate a market plan?
No. Autom returns supported country matches for review. It does not determine whether a market plan is suitable.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Autom. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Autom actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Google Countries
Tool to list google-supported countries. use when you need to filter or suggest countries based on a search string.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Google Images
Tool to fetch images from google search results. use when you need urls, titles, domains, and metadata for images matching a query.
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Google Languages
Tool to retrieve google-supported languages. use when you need a list of language codes for localization.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Google Locations
Tool to retrieve google-supported locations. use when searching for locations by name. returns locations ordered by reach (most populous first).
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Connect any two apps with Notis in the middle.
Google Sheets and Autom, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Autom.