Set it up

You need a Jira Cloud site where you can install apps, and a Google account that can edit the spreadsheet.

1. Install the app from the Atlassian Marketplace. (The listing link is added at launch.)
2. In Jira, open Apps → Sheets sync.
3. Click Connect Google account and sign in. In Google’s window, keep the Google Drive box ticked (“See, edit, create and delete only the specific Google Drive files that you use with this app”). Without it, the app can’t open your spreadsheet, and it will ask you to connect again.
4. Click Add a report:
   • give it a name;
   • choose one of your saved Jira filters, or type the JQL; Check filter tells you how many issues it finds;
   • click Pick spreadsheet and choose the file in Google’s picker, or create a new one in your Drive. The app can open only the files you pick or it creates.
5. Click Save and update now. A tab named after the report appears with your issues, and a second tab, “… changes”, starts logging changes. From then on, changes in Jira reach the sheet within minutes.

Everything else is under More options, with sensible defaults: the tab’s name, the columns, whether finished issues stay, what happens when an issue leaves the filter, what row 1 holds (the update time or the headers), the extra tabs (Summary, daily trend, time in status), who sees the report in Jira, and who gets its alerts.

If you chose a saved filter, Follow (on by default) keeps the report in step when someone changes that filter in Jira.

Add your own columns

Type anything to the right of the In filter column: notes, owners, formulas. The app never writes there, and each row stays with its issue when the data changes.

Share it with your team

In the report’s settings, choose who sees it on the app’s page: only you, groups your Jira admin offers, or everyone on the site. To let people open the spreadsheet itself, share it in Google. The sheet shows the issues as you see them in Jira, to anyone who can open it.

Who gets the alert email

The report’s owner, the person who set it up, and the members of any Jira groups chosen for the report (you can pick groups you belong to) or by a Jira admin for every report. Jira sends it, so it comes from your Jira site and goes to that person’s Jira email address. Because Jira can only send an email about an issue, the email names the first issue in your filter and says so; that issue is fine. A Jira admin can turn alert emails off; the alert still shows on the app’s page.

For Jira admins

The app’s settings are in Jira settings → Apps → Sheets sync (or Configure in Manage apps): every report on the site, who may use the app and add reports, which sharing is allowed, data safety (allowed Google domains, how far spreadsheets may be shared, fields that never leave Jira), the defaults new reports start with, alert emails, and an activity log of who did what. More in Security and data safety.