+are joining forces |Read moreabout the journey ahead!

Google Sheets, Deputy, Xero Integrations

Deputy
Google Sheets
Xero
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.

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.

Xero

Watch Bank Transactions

Triggers when a bank transaction is added or updated.

Xero

Watch Bank Transfers

Triggers when a new bank transfer is created.

Xero

Watch Contacts

Triggers when a contact is created or updated.

Xero

Watch Credit Notes

Triggers when a credit note is added or updated.

Xero

Watch Invoices

Triggers when an invoice is added or updated.

Xero

Watch Items

Triggers when a new item is created.

Xero

Watch Manual Journals

Triggers when a manual journal is created or updated.

Xero

Watch Payments

Triggers when a payment is created or updated.

Xero

Watch Purchase Orders

Triggers when an order is added or 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.

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.

Xero

Add a Contact to a Contact Group

Adds a contact to a specified contact group.

Xero

Archive a Contact

Archives a contact with a given ID.

Xero

Create a Bank Transaction

Creates a new bank transaction.

Xero

Create a Bank Transfer

Transfers a specified amount from one account to another.

Xero

Create a Contact

Creates a new contact.

Xero

Create a Contact Group

Creates a contact group.

Xero

Create a Credit Note

Creates a new credit note.

Xero

Create a History Note

Adds a note to a record.

Xero

Create a Manual Journal

Creates a manual journal.

Xero

Create an Employee

Creates a new employee.

Xero

Create an Invoice

Creates a new invoice.

Xero

Create an Item

Creates a new item.

Xero

Create a Payment

Use this method to apply payments to approved AR and AP invoices or refund AR or AP credit notes.

Xero

Create a Purchase Order

Creates a new purchase order.

Xero

Create a Quote

Creates a quote.

Xero

Delete a Contact Group

Deletes all contacts from a contact group.

Xero

Download an Attachment

Downloads an attachment.

Xero

Download an Invoice

Downloads an invoice.

Xero

Get a Bank Transaction

Returns information about a transaction with a specified ID.

Xero

Get a Contact

Retrieves contact information by ID.

Xero

Get a Contact Group

Returns information about a contact group.

Xero

Get a Credit Note

Returns information about a credit note with a specified ID.

Xero

Get a Manual Journal

Returns information about a manual journal.

Xero

Get an Account

Returns information about an account with a specified ID.

Xero

Get an Invoice

Returns information about an invoice with a given ID.

Xero

Get an Invoice URL

Retrieves Xero online invoice URL.

Xero

Get an Item

Searches for an item by item ID or item code.

Xero

Get a Payment

Retrieves information about a payment with a specified ID.

Xero

Get a Purchase Order

Returns information about a purchase order with a specified ID.

Xero

Make an API Call

Performs an arbitrary authorized API call.

Xero

Remove a Contact from a Contact Group

Removes a contact from a contact group.

Xero

Send an Invoice via Email

The email will be sent to the primary email address of the contact on the invoice. The invoice must be of Type ACCREC and a valid Status for sending (SUMBITTED,AUTHORISED or PAID).

Xero

Update a Contact

Updates a contact by ID.

Xero

Update an Employee

Updates an employee by ID.

Xero

Update an Invoice

Updates an invoice by ID.

Xero

Update an Item

Updates an item by ID.

Xero

Upload a File

Uploads a file to a selected object.

Xero

Upload a File (Files API)

Uploads a file using Files API.

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.

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).

Xero

Get a Bank Statements Report

Returns bank statements for a selected bank account.

Xero

Get a Bank Summary

Returns the balances and cash movements for each bank account.

Xero

Get History of Changes

Retrieves the changes made to a given object.

Xero

List Attachments

Retrieves a list of attachments.

Xero

Search for Accounts

Finds an account by ID, name, or code.

Xero

Search for Contact Groups

Searches for a contact group.

Xero

Search for Contacts

Searches for a contact by name or email.

Xero

Search for Invoices

Searches for an invoice.

Xero

Search for Items

Returns a list of items.

Xero

Search for Manual Journals

Searches for a manual journals.

Xero

Search for Tax Rates

Finds a tax rate by name.