Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Update Google Spreadsheet Row when Status Changes in Jira

  • February 7, 2023
  • 4 replies
  • 355 views
M

Hello,

I am wondering if it is possible to update a cell in a google sheet when the status of a Jira ticket has changed?

I am using Jira Software Cloud and my project is a Kanban board. It is linked to a Google Spreadsheet. When the status changes on the Kanban board (i.e. from “To Do” to “In Progress”), I want the “Status” column in the Google Spreadsheet to update accordingly. 

I have already set it up so that when a new row is added to the spreadsheet, the Jira ticket is created. Now, I want to close the loop so that when the Jira ticket status changes, the status in the spreadsheet also changes. The spreadsheet and the Jira board are shared with different audiences.

Thanks! 

Best answer by Troy Tessalone

Hi @Meg L. 

Good question.

Try these Zap steps:

  1. Trigger: Jira - Updated Issue
  2. Action: GSheets - Find Row
  3. Action: GSheets - Update Row
    1. Map the Row ID from step 2
View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Troy TessaloneZapier Expert
  • Zapier Expert
  • 30962 replies
  • Answer
  • February 7, 2023

Hi @Meg L. 

Good question.

Try these Zap steps:

  1. Trigger: Jira - Updated Issue
  2. Action: GSheets - Find Row
  3. Action: GSheets - Update Row
    1. Map the Row ID from step 2
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M
  • Meg L.Beginner
  • Author
  • Beginner
  • 1 reply
  • February 9, 2023

Hi Troy - in this case, when the ticket status is updated, I want it to update the status column in the spreadsheet, for the row that corresponds to the ticket. Is there a way to dynamically map the gsheet row based on an ID?


I also don’t see how to select the specific Jira project I want mapped to the spreadsheet. Any advice?

jmacey
  • jmacey
  • New
  • 2 replies
  • February 15, 2023
Troy Tessalone wrote:

Hi @Meg L. 

Good question.

Try these Zap steps:

  1. Trigger: Jira - Updated Issue
  2. Action: GSheets - Find Row
  3. Action: GSheets - Update Row
    1. Map the Row ID from step 2

I tried this but unfortunately it says “ID No data” So this isn’t working for me

jmacey
  • jmacey
  • New
  • 2 replies
  • February 15, 2023
Meg L. wrote:

Hi Troy - in this case, when the ticket status is updated, I want it to update the status column in the spreadsheet, for the row that corresponds to the ticket. Is there a way to dynamically map the gsheet row based on an ID?


I also don’t see how to select the specific Jira project I want mapped to the spreadsheet. Any advice?

@Meg L. if you have the paid Zapier account you can set a “Filter by Zapier” as a final action in the zap, and filter for the specific project you need

jesse
1 person likes this
  • jesse
    jesse
Terms & Conditions