There is a new version of my Jira Backlog Google Sheet available. It will now handles multi choice fields like labels correctly, and defaults to display name or name fields for fields if they exist.
If you're new to the script you can find out more details here.
...This worked well until the team decided that they wanted to try using Jira - it worked well for them, but not for me as I had a good setup with the spreadsheet which gave me the exact information I needed, and had the burndown chart working exactly as I wanted - it took into account variations of hours available during the sprint (Some days were meeting heavy for example), which made it much more useful for checking the team's progress, and seeing if corrective action was required...
Read More...you can give read-only access to your Jira projects to the whole world (without requiring a login), but you might run into problems if your competitors got hold of the url, so that didn't seem like a great solution.
I therefore decided to use the Jira Rest API to import the backlog into a Google Spreadsheet, which could then be shared with just our organisation...
Read More