Google Sheets, IPEX Helpdesk Integrations

Google Sheets
IPEX Helpdesk
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.

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.

IPEX Helpdesk

Add a Message

Adds a new message (comment) in the ticket.

IPEX Helpdesk

Add an User Tag

Adds a tag into user properties.

IPEX Helpdesk

Add Related Tickets

Adds relation between tickets.

IPEX Helpdesk

Create a Customer

Creates a new customer.

IPEX Helpdesk

Create an Anonymous Ticket

Creates a new anonymous ticket. If the user's email is not registered, the new user account will be created if the ticketing is configured so.

IPEX Helpdesk

Create an User Account

Creates a new user account by administrator.

IPEX Helpdesk

Create a Ticket

Creates a new ticket.

IPEX Helpdesk

Get a Customer

Gets customer details.

IPEX Helpdesk

Get an Operator Group

Gets operator group detail.

IPEX Helpdesk

Get an User Account

Gets user account's detail.

IPEX Helpdesk

Get a Ticket

Returns a ticket detail.

IPEX Helpdesk

Get Fields Description of Customer

Description for customer's fields.

IPEX Helpdesk

Get Fields Description of User Account

Description for user's account fields.

IPEX Helpdesk

Get Track Time Records

Gets report of Track Time Records (required version >= 4.14).

IPEX Helpdesk

Import Customers

Bulk create/update customers. Max bulk size is 500 customers. (required version >= 4.16.0)

IPEX Helpdesk

Import User Accounts

Bulk create/update user accounts/contacts. Max bulk size is 100 user accounts. (required version >= 4.16.0)

IPEX Helpdesk

Update a Customer

Updates a customer data via PATCH method. (required version >= 4.16.0)

IPEX Helpdesk

Update an User Account

Updates user account data via PATCH method. (required version >= 4.16.0)

IPEX Helpdesk

Update a Ticket Workflow

Changes ticket workflow state.

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.

IPEX Helpdesk

List Country Codes

Lists country codes.

IPEX Helpdesk

Search Customers

Searches customers by filter.

IPEX Helpdesk

Search Tickets

Lists tickets by filter.

IPEX Helpdesk

Search User Accounts

Searches user accounts by filter.

Integrate Google Sheets, IPEX Helpdesk with these services