Project tracking/dashboard on google sheets

[Nandita Parthasarathy]

Hi, any suggestions on how to create a project dashboard of multiple products(different projects on jira could) on google sheets by fetching the data from JIRA? 

I am looking to gather current and future sprint details in terms of start and end date, number of issues (in progress, completed, pending, to do, with specific labels etc) 

basically, this is mostly for the operations to keep track of multiple project timelines and monitor if it is on track. 

[Bill Sheboy]

Hi @Nandita Parthasarathy  -- Welcome to the Atlassian Community!

Have you seen this article on the Jira Cloud add-on for Google Sheets?  Using this you may be able to create your dashboard.

https://community.atlassian.com/t5/Jira-articles/Try-the-new-Jira-Cloud-add-on-for-Google-Sheets/ba-p/1016436

Best regards,

Bill