Get an air quality check from a new row
Capture a city once and have its current air quality summarized for you.
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
Air Quality
Tool to get air quality data for a city. use when you need current aqi, pollutant levels, and a health recommendation.
Why this helps
City lists can be hard to act on when current air quality requires a separate lookup.
- Fetch current AQI and pollutant details for a row's city.
- Include the available health recommendation in the report.
- Avoid switching tools to check each location.
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 check the air quality for the city in each new row and report AQI, pollutants, and the recommendation; choose New Rows and a report channel.
- 4Test with one real row containing a confirmed city name.
Questions about this workflow
Does this provide historical air quality?
The listed Apiverve action returns current air quality data, not a historical series.
What information is needed?
A city name is needed for the lookup.
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.