Investigate bonus total changes with current HR records
When your bonus summary changes, ask Notis to retrieve Breathe HR bonus records and highlight what needs a closer look.
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
List Employee Bonuses
Tool to retrieve employee bonuses from BreatheHR with pagination support. Use when you need to list bonuses across the organization.
Why this helps
A changed bonus total can be hard to explain when its underlying records are in a different system.
- Connect a changed total to current bonus records
- Reduce manual cross-checking during compensation reviews
- Keep the review period clear in the resulting summary
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Breathe HR once in the Notis portal.
- 2Create an automation in the portal or tell Notis what outcome you want from any channel.
- 3In one instruction, ask Notis to list and summarize Breathe HR bonuses for the review period you specify when the monitored aggregate changes, flagging if the period is missing.
- 4Pick the Google Sheets Aggregate Metric Changed trigger and choose where run reports should go.
- 5Test with one real total change and review the run report.
Questions about this workflow
Does this create or change any bonus?
No. It retrieves bonus records for review using the Breathe HR List Employee Bonuses action.
What if the metric changes without a review period?
Specify the period in your instruction or source data. Ask Notis to flag missing context rather than assume dates.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Breathe HR. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Breathe HR actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Approve Leave Request
Tool to approve a leave request in BreatheHR. Use when an authorized user needs to approve a pending leave request.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Employee
Tool to create a new employee in BreatheHR. Use when you need to add a new employee record with their personal information, contact details, and employment information. Required fields are first_name, last_name, email, and company_join_date.
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.
Create Employee Change Request
Tool to create a change request for an employee field. Use when you need to update employee information such as job title, department, or salary.
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.
Create Employee Expense
Tool to create an employee expense record in BreatheHR. Use when an employee needs to submit a new expense claim for reimbursement or record a company-paid expense.
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.
Create Employee Expense Claim
Tool to create a new expense claim for an employee. Use when you need to submit expenses for reimbursement by grouping one or more unclaimed expense records into a claim.
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.
Create Employee Sickness
Tool to create a sickness record for an employee in BreatheHR. Use when you need to log an employee's sick leave with details like type, dates, and status.
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.
Delete Employee Expense
Tool to delete an employee expense by ID. Use when you need to remove an expense record from the system.
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.
Delete Employee Training Course
Tool to delete an employee training course record by its ID. Use when you need to remove a training record from an employee's profile.
Connect any two apps with Notis in the middle.
Google Sheets and Breathe HR, 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 Breathe HR.