Look up airline details from a new row
Collect airline names in one sheet and get information as each request arrives.
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
Get Airline Info by Name
Tool to get airline info by name. use after obtaining the official airline name.
Why this helps
Travel research takes extra time when airline details must be looked up one request at a time.
- Look up information using the official airline name.
- Process new airline research requests as rows arrive.
- Send the retrieved information to a chosen report channel.
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 to look up information for the official airline name in each new row and report it; select New Rows and a report channel.
- 4Test with one real row containing an official airline name.
Questions about this workflow
Can I use an airline nickname?
Use the official airline name, as required by the listed action.
Where can I review the result?
Choose a report channel during automation setup.
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.