Follow up when your sickness metric changes
When your sickness summary moves, have Notis pull the relevant Breathe HR records and give you a focused review summary.
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 Sicknesses
Tool to list all sickness records from BreatheHR with optional date filtering. Use when you need to retrieve sickness absence records with support for filtering by employee, department, date range, and RotaCloud integration status.
Why this helps
A changing absence metric can raise questions, but tracing it back to individual records takes time.
- Turn a changed summary into a focused record review
- Reduce time spent navigating between metric and HR data
- Keep the relevant period explicit in the follow-up
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 the intended outcome from any channel.
- 3In one instruction, ask Notis to retrieve and summarize Breathe HR sickness records for the review period you specify when the monitored aggregate changes, and to flag if the period is not available.
- 4Pick the Google Sheets Aggregate Metric Changed trigger and choose where run reports should go.
- 5Test with one real metric change and review the run report.
Questions about this workflow
Can the metric alone tell Notis which dates to review?
No. Supply the review period in the sheet or instruction. Ask Notis to flag a change if that period is unclear.
Does this alter sickness records?
No. It retrieves and summarizes records using the Breathe HR List Sicknesses action.
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.