You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
We have multiple products within our project, till today we were using excel to track all the activities(more than 60 tasks). The tasks start/end-date depends on the Go-Live and for now we had to set-up a really extensive automation, to generate all the tasks and to adjust the start/end-date based on the Go-Live date.
Since we have few excels to track different products, we are looking for a way to create an automation based on the excel details we have already in place. Is it possible? If yes, how can we proceed?
Thank you all for your help and wish you an amazing day! :)
Hi @Tommy and welcome to the community!
I really like the approach @Darryl Lee took for this one, but I have to ask why Jira can't be your source of truth rather than trying to force Excel into it? For example, each product could be a component and then you would leverage releases to manage your launch schedule.
Hi @Mark Segall
The thing is, we have multiple excels already in place, not only in our area, but also in other, thus I was thinking if there would be a way to use what we have already.
Another thing is, that the excel would be easier to handle for the people, that have no experience with jira.
For the moment we handle this on the 3 levels -> Epic -> Issue -> Task. We are still building it up and I hope it will create more value and better project tracking, rather than additional work :D
Thank you so much for your reply, I really appreciate it! :)
Hi @Tommy -- Ooooh, yeah, that's tricky and cool, and I love/hate it!
At first I thought you might be able to do a "pull" from Jira, using Automation's Send web request action
But ugh, that would require Excel being able to "publish" data as JSON, which... while you can "create" JSON (Output Excel table data as JSON), I think you can only "publish" HTML: Share it: Embed an Excel workbook on your web page or blog from OneDrive
But googling around, I thought of a different idea: What if Excel could "push" a web request to an Automation Webhook?
Yeah, that might work using the Excel WEBSERVICE function.
So right then. You'd need to update your Excel sheet so that when certain things change, it makes a WEBSERVICE call to an Automation triggered by a Webhook. You probably would need to add some conditions to look at the data that the Webhook receives, and if something changed (start/end date), etc. then you take action (update corresponding start/end date in the appropriate ticket.)
So, there's some thoughts. Let us know if you come up with something, or if you have questions about/problems with the Automation bits.