Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How would you get Google Script to run/update Jira() in Google Sheets?


I have a google form that imagine will be edited multiple times. It provides info into a google sheet. I need edits that update data from specific columns to trigger JQL queries based on their input. 

For instance:

A PO submits a form that creates a new row (row N) in a sheet. Column A Row N cell has the Product Name. Column B Row N row cell has the build Version

When an edit comes to the row/sheet I want it to trigger Jira to query the open issues for the product and the version and put the number in a cell in the row (Column C Row N). I imagine that I would use the Google Script onEdit function to trigger the Jira query somehow

From a dashboard this query gets me the info that I want

(issueType = Bug AND statusCategory not in ("DONE")) AND (("Product Area[Dropdown]" = Cell data Product Name AND issuetype = Bug AND "Release[Version Picker (multiple versions)]" = "Cell data Version" ) 

Thanks for considering this. I am very new to JQL and Google Script

0 answers

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events