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

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 these ways;

From Google …

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.