Google file Asset Importer for Jira

Owned by Rickard Atthem
Last updated: 2024-08-13 by Peter Atthem
3 min read

Google file Asset Importer for Jira can import any csv file stored on Google Drive into Assets in Jira.

100% Running on Atlassians infrastructure called Forge, this means that no data is stored or transfered to Rixter AB. All is kept within your Jira instance and Atlassian agreement,

 

 

asset-importer-google.png

 

Installation

  1. Navigate to Find new apps

  2. Search for Asset Importer : Google file importer

  3. Click install

Creating an import

  1. Click Assets menu

  2. Select the Object Schema you want to import data into

  3. Click Schema Configuration button

  4. Click Roles tab

  5. Add Asset Importer: Google file import to the role Object schema managers

  6. Click Import tab

  7. Click Create Import button

  8. Select Google File Importer

  9. Enter any name regarding the file you want to import, example Cities

  10. Click Save.

Configure the Import

  1. Click the three dots on the import you created

  2. Click Configure app

  3. Setup credentials by copy paste the Google Cloud Storage service account json file content in the box in the Credentials tab.

  4. Select the scope of the application

  5. Click Enable Schedule and set the interval you wish it to run

  6. Click Resources and paste the https url to the Google file

  7. Click Load

  8. Select the columns, key and label in the generated table

  9. Click Save

Save will try to create the import mapping and the Object Type specified in the configuration.

Screenshot 2024-06-23 at 11.55.49.png

Credentials

Setup scheduled trigger

 

Select file to import

 

Manual Import

  1. Click Import Data button and the import will start fetching the data

Google Credentials

To authenticate you need to have a Google Cloud storage Service account json file

This can be done in this ways;

Google Service Account

Service account is used to have system to system communication and is recommended for Google services using iHub.

There is two sides of the setup, one in iHub Cloud and one in Google Console

Google Console
Reference create a service account https://cloud.google.com/iam/docs/service-accounts-create

  1. Goto Google Console

  2. Create a project

  3. Goto API & Services

  4. Click Credentials

  5. Click Create Credentials

  6. Create a Service Account

  7. Click on the Service User

  8. Click Keys, create new

  9. Download the Private Key as JSON

  10. Enable the API that you want to access. example Google Sheets

  11. For Google Docs, Sheets, Presentation etc share the resource with the service account to grant access

Credentials storage

The app uses Atlassian forge secret store to store the credentials encrypted.

The current version displays the credentials for the Asset Schema Admin, that has the permission o create imports.