Google Sheets, Slack, Deputy Integrations

Deputy
Google Sheets
Slack
Try Integromat for FREE
No credit card. You'll love it.

What is Integromat?

GmailWatch emailsGoogle SheetsAdd a rowGmailIterate attachmentsRouterFacebookCreate a postArchiveCreate an archiveDropboxUpload a fileDocuments onlyImages onlyWhen new email arrivesAdd a row to a sheetProcess attachmentsone by one ...Post images to pageZip all documentsUpload archive

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!

Triggers

Google Sheets

Perform a Function INSTANT

Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.

Google Sheets

Watch Changes INSTANT

Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.

Google Sheets

Watch Rows

Watches for new rows.

Slack

New Event INSTANT

Triggers when new messages or other events are created.

Slack

Watch Direct Messages

Triggers when a new message is added to a direct message channel.

Slack

Watch Files

Triggers when a new file is added.

Slack

Watch Multiparty Direct Messages

Triggers when a new message is added to a multiparty direct message channel.

Slack

Watch Private Channel Messages

Triggers when a new message is added to a private channel.

Slack

Watch Public Channel Messages

Triggers when a new message is added to a public channel.

Slack

Watch Users

Triggers when a new user is added.

Deputy

Watch Employees Deletion INSTANT

Triggers when an employee has been deleted.

Deputy

Watch Employees Updates INSTANT

Triggers when an employee has been updated.

Deputy

Watch New Area/Departments INSTANT

Triggers when a new area or department has been created.

Deputy

Watch New Comments INSTANT

Triggers when a comment has been added.

Deputy

Watch New Employees INSTANT

Triggers when a new employee has been created.

Deputy

Watch New Leave Requests INSTANT

Triggers when a new leave request has been submitted.

Deputy

Watch News Feed Deletion INSTANT

Triggers when an announcement has been deleted.

Deputy

Watch New Schedules INSTANT

Triggers when a new schedule has been added.

Deputy

Watch New Timesheets INSTANT

Triggers when a new timesheet has been saved.

Deputy

Watch Schedules Deletion INSTANT

Triggers when a schedule has been deleted.

Deputy

Watch Schedules Updates INSTANT

Triggers when a schedule has been updated.

Deputy

Watch Timesheets Updates INSTANT

Triggers when a timesheet has been updated.

Actions

Google Sheets

Add a Row

Appends a new row to the bottom of the table.

Google Sheets

Add a Sheet

Adds a new sheet.

Google Sheets

Clear a Cell

Cleares a specific cell.

Google Sheets

Clear a Row

Clears values from a specific row.

Google Sheets

Create a Spreadsheet

Creates a new spreadsheet.

Google Sheets

Delete a Row

Deletes a specific row.

Google Sheets

Delete a Sheet

Deletes a specific sheet.

Google Sheets

Get a Cell

Gets a specific cell.

Google Sheets

Make an API Call

Performs an arbitrary authorized API call.

Google Sheets

Perform a Function - Responder

Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.

Google Sheets

Update a Cell

Updates a specific cell.

Google Sheets

Update a Row

Updates a row.

Slack

Add a Star

Adds a star to a channel.

Slack

Archive a Channel

Archives a channel.

Slack

Complete a Reminder

Completes a reminder.

Slack

Create a Channel

Creates a channel.

Slack

Create a Message

Creates a message.

Slack

Create a Reminder

Creates a reminder.

Slack

Create a Text File

Creates a text file.

Slack

Delete a File

Deletes a file.

Slack

Delete a Message

Removes a message.

Slack

Delete a Reminder

Removes a reminder.

Slack

Download a File

Downloads a file.

Slack

Get a File

Returns details about a file.

Slack

Get a Channel

Returns information about a workspace channel.

Slack

Get a Private Channel Message

Returns a message with a given ID from a specified private channel.

Slack

Get a Public Channel Message

Returns a message with a given ID from a specified public channel.

Slack

Get a Reminder

Returns details about a reminder.

Slack

Get a User

Returns details about a member of a workspace.

Slack

Invite Users

Invites 1-30 users to a public or private channel.

Slack

Join a Channel

Joins to an existing channel.

Slack

Kick a User

Removes a user from a channel.

Slack

Leave a Channel

Leaves a channel.

Slack

Make an API Call

Performs an arbitrary authorized API call.

Slack

Remove a Star

Removes a star from a channel.

Slack

Search for User

Retrieves a single user by looking them up by their registered email address.

Slack

Set a Status

Update a user's current status.

Slack

Set the Purpose of a Channel

Changes the purpose of a channel.

Slack

Set the Topic of a Channel

Changes the topic of a channel.

Slack

Unarchive a Channel

Unarchives a channel.

Slack

Update a Message

Updates a message.

Slack

Upload a File

Creates or uploads a file.

Deputy

Activate a Terminated Employee

Activates a terminated employee.

Deputy

Approve a Timesheet

Approves a timesheet.

Deputy

Create a Location

Creates a new location (workplace / company).

Deputy

Create an Area / Department

Creates an area / department.

Deputy

Create an Employee

Creates a new staff member.

Deputy

Create a News Feed

Creates a news feed announcement.

Deputy

Create a Schedule

Creates a new schedule / roster.

Deputy

Create a Task

Creates a new task.

Deputy

Create / Update a Journal

Creates or updates a journal.

Deputy

Delete a Discarded Employee

Deletes a discarded / terminated employee's account in Deputy.

Deputy

Delete a Location

Deletes a location in Deputy after migrating associated employees to another location.

Deputy

Delete a Schedule

Discards a schedule.

Deputy

End a Timesheet

Ends a shift that is in progress.

Deputy

Get a Location Details

Provides details about the specified location.

Deputy

Get a Location Settings

Provides settings of a specific location.

Deputy

Get an Employee

Provides details about the specified employee.

Deputy

Get a Schedule

Provides details of a schedule.

Deputy

Get My Contact and Address

Provides a user's contact and address.

Deputy

Get My Details

Provides a user's details.

Deputy

Invite an Employee

Invites an employee.

Deputy

Make an API Call

Performs an arbitary authorized API call.

Deputy

Pause / Unpause a Timesheet

Pauses / unpauses a user's timesheet.

Deputy

Publish a Schedule

Publishes a schedule.

Deputy

Start a Timesheet

Starts a shift for your staff.

Deputy

Terminate an Employee

Terminates an active employee.

Deputy

Update a Location Settings

Updates a location settings.

Deputy

Update an Employee

Updates an employee details.

Deputy

Update a Schedule

Updates a Schedule.

Deputy

Update or Create a Timesheet

Updates a given timesheet or creates a new one.

Searches

Google Sheets

Get Range Values

Gets a range content.

Google Sheets

List Sheets

Gets a list of all sheets in a spreadsheet.

Google Sheets

Search Rows

Returns results matching the given criteria.

Google Sheets

Search Rows (Advanced)

Returns results matching the given criteria. This module doesn't return a row number.

Slack

List Files

Returns a list of files within the team.

Slack

List Channels

Returns a list of all channels in a workspace.

Slack

List Members in Channel

Retrieve members of a channel.

Slack

List Reactions

Returns reactions a user made.

Slack

List Reminders

List all reminders created by or for a given user.

Slack

List Replies

Retrieves a thread of messages posted to a conversation.

Slack

List Users

Returns a list of all users in the workspace.

Slack

Search for Message

Returns messages matching a search query.

Deputy

List Employees

Lists all employees.

Deputy

List Location's News Feeds

Lists news feeds for a specific location.

Deputy

List My Colleagues

Lists a user's colleagues.

Deputy

List My Completed Tasks

Lists a user's completed tasks.

Deputy

List My Leave Requests

Lists a user's leave requests.

Deputy

List My Locations

Lists a user's locations.

Deputy

List My News Feeds

Lists a user's news feeds.

Deputy

List My Notifications

Lists a user's notifications.

Deputy

List My Schedule Shifts

Lists a user's schedule shifts.

Deputy

List My Timesheets

Lists a user's timesheets.

Deputy

List My Unavailability Records

Lists a user's unavailability records.

Deputy

List Schedules

Lists all schedules (-12 hours to 36 hours from current date).