Google Sheets - JSM Asset import process

Question

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

Ignacio Aredez GenAI Expert · Answer

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.

Humashankar VJ · Answer

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