Calculate an age breakdown from each new entry
Let Notis calculate an age breakdown when a date of birth is added to your sheet.
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
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"
Why this helps
Manual age calculations add friction when intake or planning records arrive in a spreadsheet.
- Calculate an age breakdown from a date of birth.
- Handle each new entry as it arrives.
- Keep the result in a run report for easy review.
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 name it.
- 3Tell Notis to calculate the age breakdown from the date of birth in each new row; select New Rows and a report channel.
- 4Test with one real row containing a valid date of birth.
Questions about this workflow
What age details can it return?
The action provides a breakdown in years, months, weeks, and days.
Does it update the spreadsheet?
This workflow runs the Apiverve calculation and sends a report; no Sheets update action is listed here.
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.