Atlassian Team members are employees working across the company in a wide variety of roles.
July 15, 2019 edited
@Ayush Mishra The =JIRA function does not support modification of the column header names directly.
One workaround could be to add new columns to the right of the columns that the function returns and add your conditional formula or referenced values with your desired column names, and then hide the corresponding source columns that are returned from the =JIRA function.
Thank you folks so much for creating this plugin. This is exactly what I needed!
It would be nice to have more insight into why communications fail however. After about an hour, my refreshes stopped working and it doesn't say why, only to try again, or contact atlassian support :(
I'm getting [field type not supported] when I pull a field with field type 'Version Picker (single version). Can you please submit a request for this field type to be supported?
Atlassian Team members are employees working across the company in a wide variety of roles.
July 22, 2019 edited
@msalem I have created https://jira.atlassian.com/browse/API-134 for you. Kindly watch/comment/vote that ticket to keep yourself up-to-date with this. Thanks and let us know if you have any further questions.
@donovan@Catherine Chang@Rahul Patil Our organization is very intrigued by this add-on, but we just have a couple of questions regarding data security. When our G Suite admin goes to whitelist this add-on, one of the necessary privileges we must enable is as follows:
"This app wants permission to:
See your spreadsheets
Edit your spreadsheets
Create new spreadsheets
Upload or download your spreadsheets
Organize and delete any of your spreadsheets
See and change the people you share spreadsheets with
There may be sensitive information in your spreadsheets, like financial records or personal lists."
We understand the need to view, edit, create, organize, and integrate with G Sheet privacy settings. But what is this add-on's need for uploading or downloading our sheets? How are these sheets stored by Atlassian?
In addition, many of the folks who would utilize this add-on do, in fact, have access to sensitive information in sheets on our Team drives. Could this add-on view/download that information passively? Or must the user actively use the add-on in those sensitive sheets?
Thank you for your time! This add-on appears to be a life saver.
I love this plugin, and would like to use the auto-update feature as well. But like Brenden Beatty said, there's no way I'm granting Upload/Download/Delete status on our confidential Sheets to a third party.
Our add-on does not actually store any spreadsheet data, and never accesses documents that the add-on is not installed in. This add-on requires upload/download (read/write) access to determine if it might possibly overwrite data that it needs to warn the user about, but we never store that data, and of course we write to the spreadsheet document to copy data from Jira to it.
As it turns out, this add-on requests only the minimum scopes necessary to perform the advertised functionality. Google's scopes are quite coarse grained and so we wind up obtaining more than we really use. For example, we never download or delete documents, and never access documents that our add-on is not installed in. The privacy of our users' data is important to us and we will do our part to respect it, in accordance with our published privacy policy.
Is it possible to pull tickets from the specified board from Jira to Google Sheets?
I am trying to create a prioritization board and send this to Google Sheet so that my customers will be able to see the open tickets and their order based on their priority.
Atlassian Team members are employees working across the company in a wide variety of roles.
November 15, 2019 edited
@Evrim Demir yes, if you have a JQL which lists tickets belonging to a specific board (in the order you want), it can be used in the JQL tab of the 'Get data from Jira' menu.
Currently you cannot specify board/project through UI, you'll have to use JQL for that. Hope this helps.
I recommend making a copy of the board filter that you are using. You will want to probably add 'and resolution is empty' if you only want to show unresolved issues along with any other filters. I get the report looking like I want in Jira and then save the query. Then use that Query in the Filters tab of the Add-on. It works great.
is there any way to get JIRA for sheets to be drive off a single cell? I'd like to create a dynamic doc where i can search by JIRA ID and all the data in the sheet will refresh, including graphs etc
77 comments