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

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

Anna Minx September 20, 2021

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
AUG Leaders

Atlassian Community Events