Use a changed sheet metric to prompt a balance adjustment
When a tracked balance calculation changes, have Notis apply the adjustment you describe to the specified employee's BambooHR time off balance.
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
Adjust employee time off balance
This endpoint allows you to adjust the time off balance for a specific employee in bamboohr. it's used to make corrections, add or subtract time off, or reconcile discrepancies in an employee's time off records. the adjustment is applied to a particular time off type (e.g., vacation, sick leave) on a specified date. this tool is particularly useful for hr administrators who need to manually modify time off balances due to policy changes, corrections, or special circumstances. it provides a way to maintain accurate time off records without altering the underlying accrual rules or past time off requests. note that this adjustment will be reflected in the employee's time off history and may affect future balance calculations.
Why this helps
Reconciling a tracker against HR balances can become a separate task that is easy to postpone.
- Turn a changed calculation into a clear reconciliation task
- Apply a stated adjustment without rechecking the tracker manually
- Keep an audit trail through automation run reports
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and BambooHR once in the Notis portal.
- 2Create an automation and state the employee, time off type, and adjustment rule Notis should apply when the metric changes.
- 3Pick the Google Sheets Aggregate Metric Changed trigger and choose where run reports go.
- 4Test with one real example and confirm the BambooHR balance.
Questions about this workflow
Does a changed metric tell Notis which employee to adjust?
Not by itself. Provide the employee, time off type, and a clear adjustment rule in your instruction or the monitored data.
Will it infer how to reconcile the difference?
No. Describe the intended adjustment and its amount or calculation. Notis cannot infer an unstated baseline or policy.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Bamboohr. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Bamboohr actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add benefit group employee record
This endpoint allows you to associate an employee with a specific benefit group in bamboohr for a defined period. it's used when you need to enroll an employee in a new benefits package or update their existing benefits enrollment. the association can be set for a specific time frame or left open-ended for ongoing enrollment. this tool is particularly useful for hr administrators managing employee benefits, especially during onboarding, annual enrollment periods, or when an employee's benefit status changes. note that this endpoint only creates the association; it doesn't provide details about the benefits themselves or handle the actual enrollment process in specific benefit plans.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create employee benefit entry
Creates or updates an employee benefit in the bamboohr system. this endpoint allows you to manage various aspects of an employee's benefit enrollment, including coverage details, financial contributions, and enrollment status. it's primarily used when setting up new benefits for an employee, making changes to existing benefits, or updating enrollment statuses. the endpoint is versatile, handling different types of benefits with various contribution structures for both employees and the company. it's important to note that while many fields are optional, they may be required depending on the specific benefit type and company policies. this endpoint should not be used for bulk updates or to retrieve benefit information; separate endpoints likely exist for those purposes.
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 dependent record
This endpoint allows you to create a new dependent for an existing employee in the bamboohr system. it is used to add family members or other individuals who are dependent on the employee, which is crucial for benefits administration, tax purposes, and other hr-related tasks. the endpoint requires detailed information about the dependent, including personal details, contact information, and status indicators. it should be used when onboarding new employees with dependents, updating family information, or managing benefits enrollment periods. note that some fields contain sensitive personal information, so ensure proper data security measures are in place when using this endpoint.
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.
Modify employee withholding details
This endpoint updates an employee's withholding information for tax purposes in the bamboohr system. it allows modification of federal, state, and local tax withholding amounts, including any additional withholdings, as well as specifying the applicable tax state and local jurisdiction. this tool should be used when there are changes to an employee's tax situation, such as filing status changes, additional jobs, or relocation. it's crucial for maintaining accurate payroll calculations and tax compliance. the endpoint doesn't calculate tax amounts; it only updates the stored values based on the provided information. users should ensure they have the correct withholding information before making updates, as incorrect data may lead to under or over-withholding of taxes.
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 direct deposit account
Updates the direct deposit account information for a specific employee in the bamboohr system. this endpoint allows you to modify existing direct deposit accounts or add new ones for an employee. it's particularly useful when an employee changes their bank account, adjusts their deposit allocations, or wants to split their paycheck across multiple accounts. the endpoint requires the company domain and employee id in the url path, and accepts an array of account objects in the request body, each detailing the specifics of a direct deposit account. this tool should be used with caution as it directly affects an employee's payment method, and any errors could result in payroll issues.
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.
Post employee paystub details
Creates a new employee pay stub in the bamboohr system. this endpoint allows for the detailed recording of an employee's pay information for a specific pay period, including gross and net pay, taxes, deductions, and direct deposit allocations. it should be used when processing payroll to maintain accurate financial records for each employee. the endpoint captures both current pay period data and year-to-date totals, providing a comprehensive view of an employee's earnings and deductions. it's particularly useful for integrating external payroll systems with bamboohr, ensuring that hr records are synchronized with actual payroll data. note that this endpoint does not process actual payments; it only records the pay stub information in the bamboohr system.
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.
Create employee unpaid paystub
Posts unpaid pay stubs for a specific employee in the bamboohr system. this endpoint allows you to add or update information about pay periods for which an employee has not been paid. it's useful for tracking delayed payments, managing payroll discrepancies, or recording periods of unpaid leave. the function requires the employee's id and an array of unpaid period dates. use this when you need to update an employee's payroll record with periods that haven't been compensated yet. note that this endpoint doesn't process payments; it only records the unpaid periods for tracking and future processing.
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.
Create company benefit
This endpoint creates a new company benefit in bamboohr. it allows hr administrators to set up various types of employee benefits, including health insurance, retirement plans, and reimbursement programs. the endpoint captures essential details such as benefit type, start and end dates, deduction information, and compliance with aca requirements. use this endpoint when adding a new benefit offering or updating an existing benefit with new terms. it's particularly useful during open enrollment periods or when changing benefit providers. note that this endpoint does not enroll employees in the benefit; it only sets up the benefit at the company level.
Connect any two apps with Notis in the middle.
Google Sheets and Bamboohr, 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 Bamboohr.