Resolve location names from new sheet rows
Queue a location name once and get matching Google-supported locations back in the run report.
Trigger
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Action
Google Locations
Tool to retrieve google-supported locations. use when searching for locations by name. returns locations ordered by reach (most populous first).
Why this helps
Location research can stall when an informal place name needs to be resolved before campaign planning.
- Kick off location lookups when a new row is added.
- See matches ordered by reach for easier review.
- Avoid manually reopening each request to run a location search.
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 search Google Locations using each new row's location name.
- 3Pick New Rows in Google Sheet as the trigger.
- 4Choose where run reports should go, then test with one real location name.
Questions about this workflow
What kind of input works best?
Use a place name or location phrase in the new row. Autom returns Google-supported location matches ordered by reach.
Will this choose a location for me?
No. The results are suggestions for review; the listed action does not make a selection or update the spreadsheet.
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.