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.

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! 

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

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?

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

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

Terms & Conditions