Turn new city requests into weather briefs
Add a city request to your sheet and get current conditions without another lookup.
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
Weather by City
Tool to get current weather by city. use when you need to obtain up-to-date weather details for a specific city after confirming the city name. example: "what's the weather in berlin?"
Why this helps
Weather checks interrupt planning when city requests arrive in a spreadsheet and need a quick answer.
- Get current weather details when a city request arrives.
- Keep the lookup and its report in one workflow.
- Reduce manual searching before travel or outdoor plans.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Apiverve once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a name.
- 3Tell Notis to use the city in each new row to fetch current weather and summarize it; choose the New Rows trigger and a report channel.
- 4Test with one real row containing a confirmed city name.
Questions about this workflow
What should the new row include?
Include a confirmed city name so Apiverve can look up its current weather.
Where does the result go?
Choose a report channel when creating the automation; Notis sends the run report there.
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.