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!
When you run this scenario, Integromat will automatically export list of Optimy projects matching specified search criteria (you can filter by project status, form or project owner) to your Google Sheets spreadsheet. The template uses this example spreadsheet.
New project, updated project, etc.
Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.
Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.
Watches for new rows.
Creates a new version on a given part.
Creates a task in a project.
Create a budget allocation in a project.
Creates an internal extra field in a project.
Gets a form.
Retrieves data about a single project
Gets the answer of a given project part version for a given project.
Gets the file uploaded in the "document manager" of a project.
Gets a file uploaded through the form into a project.
Gets an internal extra field of a project.
Updates the status of a project
Updates the task of a project (eg: to mark it as completed).
Updates (or removes) the leader (user and/or team) of a project.
Uploads a file into the "document manager" of the project.
Uploads a file into the form of the project.
Appends a new row to the bottom of the table.
Adds a new sheet.
Cleares a specific cell.
Clears values from a specific row.
Creates a new spreadsheet.
Deletes a specific row.
Deletes a specific sheet.
Gets a specific cell.
Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.
Updates a specific cell.
Updates a row.
Lists the answers of a given project part version of a given project.
Lists files uploaded in the “document manager" of the project.
Lists files uploaded through the form into a project.
Lists internal extra fields of a project.
Lists all part versions of a project.
Lists all projects. Optionally filters by form, form part, project owner, project status.
Lists all available project statuses
Lists all tasks of a project.
Gets a range content.
Gets a list of all sheets in a spreadsheet.
Returns results matching the given criteria.
Returns results matching the given criteria. This module doesn't return a row number.