Integromat will automate processes that you currently handle manually. It is not only capable of connecting apps but can also transfer and transform data. It works 24 hours a day, seven days a week and does not require your intervention. Simply set Integromat to do what you want and let it work for you. Save your time!
This template exports or updates Deputy schedules to a Google Sheets spreadsheet as soon as changes are made in Deputy. New schedules are added as new rows. Changes to existing schedules in Deputy will update the corresponding row in the target Google Sheets spreadsheet (sample spreadsheet here). Deletions of schedules in Deputy will NOT be synced with the spreadsheet by this template. In order to also sync the deletions, please also implement this template.
This scenario deletes corresponding rows from a Google Sheets spreadsheet (sample is here) whenever a schedule is deleted in Deputy. Please visit also this template which creates or updates Deputy schedules in Google Sheets. You will likely need to use both templates if you want to fully sync Deputy schedules with Google Sheets.
This template creates new employees in Deputy based on new rows in Google Sheets. The sample Google Sheets spreadsheet is here. The template is scheduled to run every hour. You can change this after you set up the template
Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.
Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.
Watches for new rows.
Triggers when an employee has been deleted.
Triggers when an employee has been updated.
Triggers when a new area or department has been created.
Triggers when a comment has been added.
Triggers when a new employee has been created.
Triggers when a new leave request has been submitted.
Triggers when an announcement has been deleted.
Triggers when a new schedule has been added.
Triggers when a new timesheet has been saved.
Triggers when a schedule has been deleted.
Triggers when a schedule has been updated.
Triggers when a timesheet has been updated.
Appends a new row to the bottom of the table.
Adds a new sheet.
Cleares a specific cell.
Clears values from a specific row.
Creates a new spreadsheet.
Deletes a specific row.
Deletes a specific sheet.
Gets a specific cell.
Performs an arbitrary authorized API call.
Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.
Updates a specific cell.
Updates a row.
Activates a terminated employee.
Approves a timesheet.
Creates a new location (workplace / company).
Creates an area / department.
Creates a new staff member.
Creates a news feed announcement.
Creates a new schedule / roster.
Creates a new task.
Creates or updates a journal.
Deletes a discarded / terminated employee's account in Deputy.
Deletes a location in Deputy after migrating associated employees to another location.
Discards a schedule.
Ends a shift that is in progress.
Provides details about the specified location.
Provides settings of a specific location.
Provides details about the specified employee.
Provides details of a schedule.
Provides a user's contact and address.
Provides a user's details.
Invites an employee.
Performs an arbitary authorized API call.
Pauses / unpauses a user's timesheet.
Publishes a schedule.
Starts a shift for your staff.
Terminates an active employee.
Updates a location settings.
Updates an employee details.
Updates a Schedule.
Updates a given timesheet or creates a new one.
Gets a range content.
Gets a list of all sheets in a spreadsheet.
Returns results matching the given criteria.
Returns results matching the given criteria. This module doesn't return a row number.
Lists all employees.
Lists news feeds for a specific location.
Lists a user's colleagues.
Lists a user's completed tasks.
Lists a user's leave requests.
Lists a user's locations.
Lists a user's news feeds.
Lists a user's notifications.
Lists a user's schedule shifts.
Lists a user's timesheets.
Lists a user's unavailability records.
Lists all schedules (-12 hours to 36 hours from current date).