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

Optimy

Generic event INSTANT

New project, updated project, etc.

Google Sheets

Watch a worksheet

Triggers when a user adds a new row to a selected worksheet.

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.

Optimy

Create a project part version

Creates a new version on a given part.

Optimy

Create project internal extra field

Creates an internal extra field in a project.

Optimy

Update project status

Updates the status of a project

Optimy

Upload a project file (form)

Uploads a file into the form of the project.

Optimy

Get project internal extra field

Gets an internal extra field of a project.

Optimy

Create a project task

Creates a task 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

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

Get project file (form)

Gets a file uploaded through the form into a project.

Optimy

Create budget allocation

Create a budget allocation in a project.

Google Sheets

Add a row

Google Sheets

Update a row

Google Sheets

Delete a row

Google Sheets

Select rows

Returns rows that match the criteria specified in a selected worksheet.

Google Sheets

Update a cell

Google Sheets

Add a worksheet

Google Sheets

Delete a worksheet

Google Sheets

Get a cell

Returns the contents of a specified cell.

Google Sheets

List worksheets

Gets a list of worksheets in spreadsheet.

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

Search for a user

Searches for a user that matches specified criteria.

Iterators

Zendesk

Iterate attachments

Processes comment attachments one at a time.

Searches

Optimy

List project statuses

Lists all available project statuses

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 tasks

Lists all tasks of a project.

Optimy

List project files (form)

Lists files uploaded through the form into a project.

Optimy

List project files (document manager)

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

Optimy

List project answers

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

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