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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


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

Atlassian Community Events