Optimy, Teamwork, Google Sheets Integrations

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

Teamwork

New event INSTANT

Triggers when a new event occurs (for example, when a new task is added or completed).

Teamwork

Watch companies

Triggers when a new company is added.

Teamwork

Watch files

Triggers when a new file is uploaded.

Teamwork

Watch milestones

Triggers when a new milestone is added.

Teamwork

Watch people

Triggers when a new person (user or contact) is added.

Teamwork

Watch projects

Triggers when a new project is created.

Teamwork

Watch task lists

Triggers when a new task list is added.

Teamwork

Watch tasks

Triggers when a new task is added.

Teamwork

Watch time entries

Triggers when a new time entry is added.

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

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.

Teamwork

Add a person to a project

Adds a selected person to a project.

Teamwork

Complete a task

Markes the specified task as complete.

Teamwork

Create a calendar event

Creates a new calendar event.

Teamwork

Create a company

Creates a new company.

Teamwork

Create a link

Adds a new link to a selected project.

Teamwork

Create a milestone

Creates a new milestone.

Teamwork

Create a person

Creates a new person.

Teamwork

Create a project

Creates a new project.

Teamwork

Create a subtask

Adds a new subtask to a selected task.

Teamwork

Create a task

Adds a new task to a specified task list.

Teamwork

Create a task list

Creates a new task list in a specified project.

Teamwork

Create a time entry

Adds a new time entry to a given project or task.

Teamwork

Delete a calendar event

Deletes a calendar event.

Teamwork

Delete a company

Deletes a company with a given ID.

Teamwork

Delete a file

Deletes a file with a given ID.

Teamwork

Delete a link

Deletes the link specified by link ID.

Teamwork

Delete a milestone

Deletes a milestone with a given ID.

Teamwork

Delete a person

Deletes a person with a given ID.

Teamwork

Delete a project

Deletes a project with a given ID.

Teamwork

Delete a task

Deletes a task with a given ID.

Teamwork

Delete a task list

Deletes a task with a given ID.

Teamwork

Download a file

Downloads a file with a given ID.

Teamwork

Get a company

Retrieves information about a company with a given ID.

Teamwork

Get a milestone

Retrieves information about a milestone with a given ID.

Teamwork

Get a person

Retrieves information about a person with a given ID.

Teamwork

Get a project

Retrieve information about a project with a given ID.

Teamwork

Get a task

Retrieves information about a task with a given ID.

Teamwork

Get a task list

Retrieves information about a task list with a given ID.

Teamwork

Get a time entry

Returns a time entry by ID.

Teamwork

Remove a person from a project

Removes a selected person from a project.

Teamwork

Set project owner

Sets a selected person as a project owner.

Teamwork

Update a person

Updates a person with a given ID.

Teamwork

Update a project

Updates a project with a given ID.

Teamwork

Update a task

Modifies information about a task with a specified ID.

Teamwork

Upload a file

Uploads a file into a specific project.

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.

Searches

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.

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.