The Google Sheet Integration Jira add-on lets you effortlessly export an issue list from issue searches to Google Sheets. Follow the installation instructions below or this video tutorial.
Install the Add-On
- Log into your Jira instance as an admin.
- Click the admin dropdown and choose Add-ons. The Find new add-ons screen loads.
- Locate Google Sheets Integration.
- Click Free trial to download and install your add-on.
- You're all set! Click Close in the Installed and ready to go dialog.
Configure the Google API Project
Create a Google API Project by clicking on Select a project, and then the New Project button in the dialog. Provide it a name such as JIRA Google Sheets Integration. You will need to log in with the Google Account that you want the Google Sheets to be associated with.
Now create a Google API Service Account and associate it with the project created above. Click the Create Service Account button at the top of the screen to start the creation process.
...
On the Create service account screen that is displayed, provide a name for your service account, and a description. These values should accurately describe what the account will do, but are not critically important. When you are finished, click the Create button at the bottom of the screen below the description input to move the service account grants screenstep (2).
On the next screen, click in the Select a role area to display the role selection dialog. Give your new service account a role of Project->Owner.
After selecting the appropriate role, click on the Continue the Done button at the bottom of the screen to move to the user access grants screen.
On the user access grants screen, skip the section labeled Grant users access to this service account (optional) and proceed to the Create key (optional) section. Click on the Create Key button to display the key creation dialog.
In the key creation dialogfinish creating the service account. The Grant users access to this service account step can be skipped.
You will be returned to the Service accounts listing screen and the account you just created will be visible. In the Actions column on the far right for your account's row, click on the actions icon and select the Manage keys option.
In the key screen, find the Add Key drop down and select Create new key.
In the create key dialog that appears, tick the radio button for the JSON key type, and then click the Create button.
You will be prompted to save the new key to your machine. Accept the file and make a note of its location on your machine. This is the file that needs to be uploaded in the Configure the Add-on section later.
Close the Private key saved to your computer dialog to return to the main screen. You should see your new key ID in the Keys section. When you are finished, click on the Done Click the Closebutton at the bottom right of the screen.
After clicking the Done button you will be brought back dialog and return to the service account listing screen by clicking the Service Accounts navigation item on the left side. You should now see your new service account and key ID listed with a green checkmark check mark in the Status column. Please contact us if something does not look correct.
...