Jira & Google Sheets
Export Jira data seamlessly using the Google Sheets integration. Create reports in CSV format and update them from Jira. Share insights with non-Jira users while maintaining full data privacy and compliance.
How it works
SHARING INSIGHTS
Export Jira data into Google Sheets
Export JQL search results to spreadsheets and save them in Google Drive. Share key insights with non-Jira users while maintaining your Google permissions.
QUICK ACCESS
Access your Jira exports
Maintain a log of your exported search results. Open the spreadsheets in Google Drive, view their details, update them, or delete them.
REPORTING
Update your Jira exports
Save time and update exported spreadsheets with one click. Refresh data without breaking the charts or graphs you’ve built around them.
FAQ
What type of data can I export?
You can export almost every Jira field you see on the JQL research page, excluding specialized fields like attachments, JSON lists, thumbnails, some fields specific to JSM, and a few other exceptions. If you’d like to be able to export other fields or data from other integrations, let us know!
Can I schedule automatic updates for an exported spreadsheet?
Exported spreadsheets must be updated manually.
If I delete a spreadsheet from Jira, will it also delete it from Google Drive?
Deleting a log entry of an exported spreadsheet won’t automatically trash the spreadsheet from Google Drive.
If you have the right permissions for the Google Drive or folder the spreadsheet is in, you can trash the spreadsheet while deleting its log entry. If you don’t trash the spreadsheet, it will remain in the Drive but stop appearing on the Exported sheets page.
Can all users on our Jira instance access the export pages?
Yes, all users can reach both the Export issues to Google Sheets and Exported sheets pages.
All users can see the complete log of exported spreadsheets, but to view or modify a spreadsheet, they must have the right Google Drive permissions.
Can all users on our Jira instance access exported spreadsheets?
Access to exported spreadsheets from the Exported sheets follows the permissions established in Google Drive. All users can see the log of exported spreadsheets, but can only open, edit, or delete them if they have the right permissions.
