Make absence balance changes easier to follow
Keep balance updates visible in a spreadsheet your operations team can review when needed.
Trigger
Absence Balance Changed
Triggers when a worker's absence balance changes. This trigger monitors a specific worker's absence plan balance and detects any changes to the balance details including quantity available, effective date, position, or other related fields. Uses snapshot-based diffing to detect meaningful changes.
Action
Batch update spreadsheet
Updates a specified range in a google sheet with given values, or appends them as new rows if `first cell location` is omitted; ensure the target sheet exists and the spreadsheet contains at least one worksheet.
Why this helps
Balance changes can be hard to track when people need to revisit Workday to understand what moved.
- Create a convenient view of monitored balance updates.
- Reduce repeated checking for changes in Workday.
- Keep a record of event details in an existing spreadsheet.
Setup
Build it in a few focused steps.
- 1Connect Workday and Google Sheets once in the Notis portal.
- 2Create an automation in the portal or tell Notis in plain language from any channel.
- 3Ask Notis in one instruction to update a restricted-access balance log with available change details.
- 4Choose the Absence Balance Changed trigger and select where run reports should go.
- 5Test with one real balance change and confirm the log is appropriate for its intended viewers.
Questions about this workflow
What does this trigger monitor?
It monitors a specific worker's absence plan balance and detects changes to its details.
Can it calculate a balance history before setup?
No. The trigger detects changes going forward; any earlier history must already be available in Workday or supplied separately.
Should this sheet be broadly shared?
Absence balance details can be sensitive employee information. Use a spreadsheet with access limited to people who need it.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Workday to Google Sheets. A trigger fires from one place; an action lands in another.
Workday triggers
Google Sheets actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Sheet to Spreadsheet
Adds a new sheet (worksheet) to a spreadsheet. use this tool to create a new tab within an existing google sheet, optionally specifying its title, index, size, and other properties.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Aggregate Column Data
Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
Absence Balance Changed
Triggers when a worker's absence balance changes. This trigger monitors a specific worker's absence plan balance and detects any changes to the balance details including quantity available, effective date, position, or other related fields. Uses snapshot-based diffing to detect meaningful changes.
Append Dimension
Tool to append new rows or columns to a sheet, increasing its size. use when you need to add empty rows or columns to an existing sheet.
Balance Details Changed
Triggers when details of a specific balance change (quantity, accruals, adjustments, etc.). This trigger monitors a specific worker's absence plan balance and detects any changes to the balance details including quantity available, effective date, position, or other related fields. Uses snapshot-based diffing to detect meaningful field changes.
Batch get spreadsheet
Retrieves data from specified cell ranges in a google spreadsheet; ensure the spreadsheet has at least one worksheet and any explicitly referenced sheet names in ranges exist.
Interview Feedback Submitted or Updated
Triggers when interview feedback is submitted or updated for a specific interview. This trigger monitors a specific interview and fires when new feedback entries are detected or existing feedback is modified.
Batch update spreadsheet
Updates a specified range in a google sheet with given values, or appends them as new rows if `first cell location` is omitted; ensure the target sheet exists and the spreadsheet contains at least one worksheet.
Job Posting Changed
Triggers when a specific job posting's details change (title, status, posting dates, location, etc.). This trigger monitors a single job posting and fires when any of its fields are modified.
Batch Update Values by Data Filter
Tool to update values in ranges matching data filters. use when you need to update specific data in a google sheet based on criteria rather than fixed cell ranges.
Job Posting Questionnaire Changed
Triggers when a job posting's candidate questionnaire is added or changed. This trigger monitors a specific job posting's questionnaires and detects any changes including additions, removals, or modifications to questionnaires and questions. Uses snapshot-based diffing to detect meaningful changes.
Clear Basic Filter
Tool to clear the basic filter from a sheet. use when you need to remove an existing basic filter from a specific sheet within a google spreadsheet.
New Absence Balance
Triggers when a new absence balance record becomes available for a worker. This trigger monitors a specific worker's absence balances and detects when new balance records appear (e.g., a new plan/bucket becomes available). Uses snapshot-based diffing to compare balance record IDs between polls.
Clear spreadsheet values
Clears cell content (preserving formatting and notes) from a specified a1 notation range in a google spreadsheet; the range must correspond to an existing sheet and cells.
Connect any two apps with Notis in the middle.
Workday and Google Sheets, 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 Google Sheets.