SSH, Google Sheets, Optimy, Zendesk Integrations

Google Sheets
SSH
Zendesk
Optimy
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.

Optimy

Generic event INSTANT

New project, updated project, etc.

Zendesk

Watch Tickets

Triggers when a new ticket is created.

Zendesk

Watch Comments on a Ticket

Triggers when a new comment is created on a specific ticket.

Zendesk

Watch Comments

Triggers when a new comment is created on any ticket.

Zendesk

Watch Users

Triggers when a new user is created.

Zendesk

Watch Organizations

Triggers when a new organization is created.

Zendesk

Watch Groups

Triggers when a new group is created.

Zendesk

Watch Views

Triggers when a new view is created.

Zendesk

Watch Articles

Triggers when a new article is created.

Zendesk

Watch Article Comments

Triggers when a new article comment is added.

Zendesk

Watch Forum Posts

Triggers when a new forum post is added.

Zendesk

Watch Forum Post Comments

Triggers when a new comment on a forum post is added.

Zendesk

Watch Tickets in a View

Triggers when a new ticket is added to a selected view.

Actions

SSH

Execute a command

Executes a command on a remote device.

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

Get a Cell

Gets a specific cell.

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.

Optimy

Create a project part version

Creates a new version on a given part.

Optimy

Create a project task

Creates a task in a project.

Optimy

Create budget allocation

Create a budget allocation in a project.

Optimy

Create project internal extra field

Creates an internal extra field in a project.

Optimy

Get form

Gets a form.

Optimy

Get project

Retrieves data about a single project

Optimy

Get project answer

Gets the answer of a given project part version for a given project.

Optimy

Get project file (document manager)

Gets the file uploaded in the "document manager" of a project.

Optimy

Get project file (form)

Gets a file uploaded through the form into a project.

Optimy

Get project internal extra field

Gets an internal extra field of a project.

Optimy

Update project status

Updates the status of a project

Optimy

Update project task

Updates the task of a project (eg: to mark it as completed).

Optimy

Update the project leader

Updates (or removes) the leader (user and/or team) of a project.

Optimy

Upload a project file (document manager)

Uploads a file into the "document manager" of the project.

Optimy

Upload a project file (form)

Uploads a file into the form of the project.

Zendesk

Create a Ticket

Creates a new ticket.

Zendesk

Edit a Ticket

Edits an existing ticket.

Zendesk

Delete a Ticket

Deletes an existing ticket.

Zendesk

Merge Tickets

Merges tickets into a single ticket.

Zendesk

Search Tickets

Returns tickets that match specified criteria.

Zendesk

Create a Comment

Creates a new comment on a ticket.

Zendesk

Get Comments

Retrieves the comments on a ticket.

Zendesk

Create a User

Creates a new user.

Zendesk

Edit a User

Edits an existing user.

Zendesk

Delete a User

Deletes an existing user.

Zendesk

Get a User

Returns information about the user specified by the given user ID.

Zendesk

Create a Group

Creates a new group.

Zendesk

Edit a Group

Edits an existing group.

Zendesk

Delete a Group

Deletes an existing group.

Zendesk

Create an Organization

Creates a new organization.

Zendesk

Edit an Organization

Edits an existing organization.

Zendesk

Delete an Organization

Deletes an existing organization.

Zendesk

Create a New Ticket Field Option

Creates or updates a drop-down ticket field option.

Zendesk

Edit Multiple Users

Edits users with specified IDs or external IDs.

Zendesk

Get Ticket Field Options

Retrieves options for a given ticket field.

Zendesk

Get User Related Information

Returns related information about the user specified by the given user ID. E.g. number of assigned tickets.

Zendesk

Search for a User

Searches for a user that matches specified criteria.

Zendesk

Upload attachments

Uploads attachments for future use in a ticket.

Iterators

Zendesk

Iterate Attachments

Processes comment attachments one at a time.

Searches

Google Sheets

Get Range Values

Gets a range content.

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.

Optimy

List project answers

Lists the answers of a given project part version of a given project.

Optimy

List project files (document manager)

Lists files uploaded in the “document manager" of the project.

Optimy

List project files (form)

Lists files uploaded through the form into a project.

Optimy

List project internal extra fields

Lists internal extra fields of a project.

Optimy

List project part versions

Lists all part versions of a project.

Optimy

List projects

Lists all projects. Optionally filters by form, form part, project owner, project status.

Optimy

List project statuses

Lists all available project statuses

Optimy

List project tasks

Lists all tasks of a project.

Integrate SSH, Google Sheets, Optimy, Zendesk with these services