This page will guide you through the initial setup of the Google add-on, as well as how to use it to update your Jira issues and perform other Jira tasks from Google Sheets.
| Anchor | ||||
|---|---|---|---|---|
|
...
When the process is complete, the dialog will display a success message and close itself. After the metadata has been updated, you are ready to start using the add-on!
| Anchor | ||||
|---|---|---|---|---|
|
To start using the add-on to sync Google Sheets changes back to Jira, open the Issue Actions sidebar. This is done through the "Issue Actions" menu item for the add-on, located at Add-ons → MobilityStream Jira Integration → Issue Actions.
The Issue Actions sidebar must be opened every time you want to use the add-on to sync issues or access other Jira features from within Google Sheets.
Opening the Issue Actions sidebar will update your sheet with some changes to the header row to help identify which columns in your sheet can be synced back to Jira. Fields that can be synced back to Jira will have their borders changed to blue, and a small note indicator added. The note also helps to explain that the field will sync back to Jira.
With the Issue Actions sidebar open, you can start editing Jira issues, or access other Jira issue features of the add-on. Select any cell in a Jira issue row, and the Issue Actions sidebar changes to show which Jira issue you are currently focused on. The Issue Actions sidebar also provides links for other actions that can be performed on the Jira issue, such as viewing and adding comments. For more information on the actions available in the Issue Actions sidebar, go to the Issue Actions section.
After focus is placed in a spreadsheet cell, you can change the cell's value and if it is for a field that syncs back to Jira, your change will sync back to Jira after you finish editing the cell. Certain cells that are single-select fields in Jira, such as Assignee, Reporter, and Priority, will change to single-select drop downs in Google Sheets after you place your cursor in them. This change can take up to 1 second, so please be patient and wait for the drop down indicator arrow to appear.
If you place focus in a cell that is not a single-select field in Jira, such as Description, Summary, or other text fields, you can edit the value immediately.
After changing a cell value, the add-on will attempt to send your changes back to Jira, and display a success or failure toast in the bottom right of Google Sheets depending on the result.
| Anchor | ||||
|---|---|---|---|---|
|
The Issue Actions sidebar allows you to perform other actions on Jira issues in your sheet, even if the data associated with these issues is not present in your sheet. These actions are available as links in the Issue Actions sidebar, and are described below.
| Anchor | ||||
|---|---|---|---|---|
|