Check Breathe HR absences when planning data changes
When your planning range changes, ask Notis to retrieve the relevant Breathe HR absences and summarize what needs attention.
Trigger
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.
Action
List Absences
Tool to list all absences with optional filtering by date range, employee, department, and type. Use when you need to retrieve absence records from BreatheHR with pagination support.
Why this helps
Checking HR absences manually after every staffing plan change adds another context switch to an already busy day.
- Get relevant absence information when planning data changes
- Reduce manual cross-checks before staffing decisions
- Summarize affected dates and employees for faster review
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 use the changed range's stated dates or employee details to list relevant Breathe HR absences and summarize any overlap, flagging missing date or employee context.
- 4Pick the Google Sheets Cell Range Values Changed trigger and choose where run reports should go.
- 5Test with one real range change and review the run report.
Questions about this workflow
Does this change or approve any absence?
No. It retrieves and summarizes absence records using the Breathe HR List Absences action.
What context should the changed range contain?
Include or clearly identify the relevant date range or employee details. Ask Notis to flag a change that does not provide enough context for a useful lookup.
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.