Google Sheets and Jira

Google Sheets

Triggers

• New row in a Google SheetRuns when a new row is added to a Google Sheets spreadsheet, with the row's cells by their column headings and the spreadsheet and tab it was added to, for a step that writes back to the row, such as Update cells in row.

Actions

• Add rowAdd a row to the end of a tab.
• Create spreadsheetCreate a new spreadsheet.
• Delete spreadsheetDelete a spreadsheet permanently.
• Overwrite rowOverwrite a whole row, from column A, with values in column order. To change only some cells of a row, use Update cells in row.
• Update cells in rowSet some cells of one row by column name, leaving the rest of the row as it is. Pair it with Read rows to write a result back to the row it came from (row.row_number). A column that doesn't exist yet is added to the header row.
• Clear rowEmpty a row's cells without deleting the row.

Jira

Triggers

• New issueRuns when an issue is created in Jira.
• Issue status changedRuns each time an issue moves to another status in Jira, such as from In Progress to Done, with who moved it and when.
• New commentRuns when someone comments on an issue in Jira, with the comment, who wrote it and the issue it is on.

Actions

• List projectsList the Jira projects your connected account can see.
• Create an issueCreate an issue in a Jira project, with a title and, if you like, a description, type, priority and assignee.
• List the statuses an issue can move toList the statuses a Jira issue can move to from the one it is in now, with the move that takes it to each.
• Move an issue to a new statusMove a Jira issue to another status, such as In Progress or Done. The project's workflow decides which statuses it can move to from the one it is in now.
• Comment on an issuePost a comment on a Jira issue.
• Get an issueLook up a Jira issue: its title, description, status, assignee, priority, labels and due date.