JIRA Cloud Platform, Google Sheets, Optimy Integrations

Google Sheets
JIRA Cloud Platform
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

JIRA Cloud Platform

Watch Issues INSTANT

Watches changes to issues and filter them via JQL. Requires JIRA Administrator rights to automatically register webhooks.

JIRA Cloud Platform

Watch Issues (manual webhook registration) INSTANT

Watches Issues. You can use this module if you don't have Administrator rights in JIRA and ask your Administrator to register a webhook for you.

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.

Actions

JIRA Cloud Platform

Add a Comment

Adds a new comment to an issue.

JIRA Cloud Platform

Add an Attachment

Adds an attachment to an issue.

JIRA Cloud Platform

Assign Issue

Assigns the issue to the user. Use this module to assign issues for the users having “Assign Issue” permission, and not having the “Edit Issue” permission. If User Name parameter is set to “-1” then automatic issue assignee is used. An empty User Name will remove the assignee.

JIRA Cloud Platform

Create an Issue

Creates a new issue.

JIRA Cloud Platform

Delete a Comment

Deletes a specific comment.

JIRA Cloud Platform

Delete an Issue

Deletes a specific issue.

JIRA Cloud Platform

Get an Attachment

Retrieves an attachment's metadata.

JIRA Cloud Platform

Get and Download Attachment

Retrieves an attachment and downloads it.

JIRA Cloud Platform

Get an Issue

Retrieves an issue.

JIRA Cloud Platform

Make an API Call

Performs an arbitrary authorized API call.

JIRA Cloud Platform

Remove Attachment

Removes a specific attachment.

JIRA Cloud Platform

Update a Comment

Updates a comment.

JIRA Cloud Platform

Update an Issue

Updates an issue.

JIRA Cloud Platform

Update an Issue Status (Transition Issue)

Updates an existing issue status/transition.

JIRA Cloud Platform

Upsert an Issue

Creates an issue when there is no id provided, otherwise updates the issue with the id provided.

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.

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.

Searches

JIRA Cloud Platform

List Issue Comments

Retrieves comments for a specific issue.

JIRA Cloud Platform

Search Issues

Searches issues using JQL.

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.

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.