Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Google Sheets - JSM Asset import process

Alejandro Alcuaz Temiño February 13, 2024

Hello everyone,

My team and I are currently working on introducing Assets into our requests. As of now we are able to import a csv uploaded directly from our computers, but as our company is G-Suite oriented, we would like to find a solution that helps us with our import process and its automation.

We are seeking for a solution that allows us to update the data import from a specific google sheet that periodically updates. Once that information updates inside the google sheets, we would like to update all the objects inside the same import that was once created.

If any of you found the same problem, all help would be welcome!

 

Thank you all in advance

 

2 answers

0 votes
Ignacio Aredez
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2024

To automate the import of assets from Google Sheets to Jira Service Management (JSM), you can follow this process:

Preparation: Ensure your Google Sheets data format matches JSM's import requirements.

Integration Method:

Use Atlassian Marketplace Apps that connect Google Sheets with Jira.
Or, use automation platforms like Zapier or Integromat (Make) to create workflows.
Alternatively, develop a custom script that uses both Google Sheets and Jira APIs for more control.


Setup:

For apps, follow their setup guides.
For Zapier/Make, set up a zap/automation where the trigger is the update in Google Sheets, and the action updates JSM assets.
For a custom script, schedule it to run at intervals that match your update frequency, using APIs to transfer data.


Implement Logic:

Ensure your solution can identify and update changed data without duplicating.
Test: Validate the integration with a small dataset before full deployment.

Monitor and Maintain: Set up monitoring for errors and prepare for maintenance needs.

Document and Train: Document the process and train your team on the new workflow.

0 votes
Humashankar VJ
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2024

Hi @Alejandro Alcuaz Temiño - Have you tried setting up trigger to run the import script at periodic interval - that way you able to fix this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events