Use an aggregate change to trigger an airport distance lookup
When a tracked metric changes, get a distance lookup for the airport pair represented in your monitored data.
Trigger
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.
Action
Get airport distance by IATA
Tool to get distance between two airports by their iata codes. use when you have valid airport iata codes and need the flight distance.
Why this helps
A changed planning metric can be easy to miss when it should prompt a related travel check.
- Use a changed aggregate as a signal to start a travel lookup.
- Retrieve distance for valid IATA airport codes present in the monitored data.
- Receive the outcome in a run report.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Apiverve once in the Notis portal.
- 2Create an automation from Automations, New Automation, and name it.
- 3Tell Notis which valid airport IATA codes in the monitored spreadsheet data to use for the distance lookup and how to report it; select Aggregate Metric Changed and a report channel.
- 4Test with a real aggregate change and a row containing a valid airport pair.
Questions about this workflow
What does the trigger monitor?
It fires when a configured SUM, COUNT, AVG, MIN, or MAX result changes.
What inputs does the lookup need?
It needs valid airport IATA codes. Ensure the relevant codes are available in the spreadsheet context.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Apiverve. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Apiverve actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Advice Generator
Tool to generate a random piece of advice. use when you need spontaneous guidance or motivation.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Age Calculator
Tool to calculate age from date of birth. use when you need a breakdown of years, months, weeks, and days from a given dob. example: "calculate age for dob=1990-01-01"
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.
Get Airline Info by Name
Tool to get airline info by name. use after obtaining the official airline name.
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.
Get airport distance by IATA
Tool to get distance between two airports by their iata codes. use when you have valid airport iata codes and need the flight distance.
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.
Get Airport Info by ICAO Code
Tool to get airport information by icao code. use when you have a valid 4-letter icao code and need detailed airport information.
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.
Air Quality
Tool to get air quality data for a city. use when you need current aqi, pollutant levels, and a health recommendation.
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.
Find antonyms for a word
Tool to get antonyms for a word. use when you need opposite terms for text analysis.
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.
App Store Scraper
Tool to fetch detailed app metadata from the app store. use when you have a valid app store app id and country code.
Connect any two apps with Notis in the middle.
Google Sheets and Apiverve, 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 Apiverve.