Sheetpane user guide

Sheetpane brings Jira work items into Google Sheets and keeps them up to date. It has two parts:

• Sheetpane for Jira, the app your Jira admin installs from the Atlassian Marketplace.
• The Sheetpane add-on for Google Sheets, free, which each person installs from the Google Workspace Marketplace, where it's listed as "Sheetpane: Jira Connector".

Sheets only ever gets the work items the person connecting can open in Jira.

Coming soon. Sheetpane isn't on the Atlassian Marketplace or the Google Workspace Marketplace yet. Email support@brainstaticthreads.com if you'd like to hear when it launches.

Before you start

• Your Jira Cloud site needs Sheetpane for Jira installed (Jira admins: Apps → Explore more apps → search for Sheetpane).
• In Google Sheets, install the add-on: Extensions → Add-ons → Get add-ons → search for Sheetpane: Jira Connector.

Connect your spreadsheet

1. In Jira, open Settings (the gear icon, top right) → General settings, then Sheetpane in the sidebar.
2. Give the key a name, for example "Sprint report sheet", and click Create a key.
3. Copy the key. It's shown only once.
4. In Google Sheets, open Extensions → Sheetpane: Jira Connector → Open Sheetpane, paste the key and click Connect.

The sidebar shows "Connected as … on your-site.atlassian.net". Your key is stored in your Google account, not in the spreadsheet, so other editors connect with their own keys.

Add a query

1. Click New query.
2. Give it a name. Sheetpane creates a tab with that name.
3. Enter JQL, for example project = KAN AND statusCategory != Done ORDER BY priority DESC, and click Check to make sure Jira understands it.
4. Choose the columns. Standard and custom fields are both listed; the work item key is always the first column.
5. Click Save and import.

Dates and times arrive as real spreadsheet dates, so you can sort, filter and chart them. They're shown in the spreadsheet's time zone (File → Settings → Time zone).

A spreadsheet can hold up to 20 queries. Edit changes a query; Delete removes it but leaves its tab.

Keep it up to date

• Refresh now reloads the whole tab.
• Schedule: choose Every hour or Every day under a query. Scheduled refreshes run in the background, as you, even when the spreadsheet is closed.
  • Hourly refreshes only fetch work items updated since the last run and update their rows. Once a day Sheetpane reloads the whole tab, which also removes work items that no longer match.
  • Very large queries that don't finish in one run carry on at the next run; the sidebar says "still loading".
• Each query shows when it was last refreshed, how many rows it has, and any problem.

Sheetpane rewrites its own tabs on each full refresh, so put your formulas, charts and pivot tables on other tabs that refer to them.

Sharing spreadsheets

Sheetpane only fetches work items the connected person can open in Jira. After that, Google Sheets' sharing decides who sees them:

• Everyone the spreadsheet is shared with can see every Sheetpane tab, including work items they can't open in Jira.
• Saved queries belong to the spreadsheet, so everyone who uses Sheetpane in it sees and can edit them. Each person connects with their own key.
• Each saved query has an owner: the person who created it, last changed its JQL or columns, or set its schedule. Scheduled refreshes run with the owner's key, so they only ever fetch what the owner can open. If someone else edits a query, it becomes theirs and runs with their key from then on, and its schedule runs only once they choose it again. The sidebar says when a query is scheduled by another editor.
• Refresh now always uses the key of the person clicking it.

Share spreadsheets that use Sheetpane only with people who should see that data.

Disconnect

Click Disconnect at the bottom of the sidebar. Sheetpane forgets your key, in this and every other spreadsheet, and your scheduled refreshes pause until you connect again. The tabs and saved queries stay. If you no longer need the key, revoke it in Jira too.

Manage keys

In Jira → Settings (⚙) → General settings → Sheetpane you can see your keys, when each was last used, and Revoke any of them. Revoking a key stops every sheet that uses it. You can have up to 10 keys.

For Jira admins

Jira settings → Apps → Sheetpane:

• Let people use Sheetpane on this Jira site: when off, nobody can create keys and every sheet stops refreshing.
• Usage: how many people have keys, and requests and rows over the last 30 days.
• Revoke all keys: use this if a key may have leaked.

Troubleshooting

• "Google couldn't run Sheetpane": this usually means you're signed in to more than one Google account in the same browser. Open the spreadsheet in a window signed in to just one account (a private window works).
• "This Sheetpane key was revoked…": create a new key in Jira and connect again.
• "A Jira admin has turned Sheetpane off": ask your Jira admin.
• A JQL error: the sidebar shows Jira's own explanation; use Check while editing.
• Fewer rows than expected: Sheetpane only returns work items you can open in Jira.
• "Jira is busy": Jira limits how fast apps can read data; Sheetpane tries again on the next refresh.
• "Sheetpane needs your permission first", or a schedule won't turn on: Google lets you untick permissions when you install. Close the sidebar, open it again from the Extensions menu and allow everything Sheetpane asks for. Schedules need "run when you're not present".

Privacy

Sheetpane for Jira sends Google Sheets only the fields you choose, for the work items you can open, and stores no work item content itself. In Google, your key is kept in your Google account (not in the spreadsheet), and saved queries are kept with the spreadsheet. Sheetpane uses only the spreadsheet you open it in and never sends its contents anywhere. There are no Brain Static Threads servers in between. See the privacy policy.

Support

Email support@brainstaticthreads.com. We reply within 2 business days.

Jira is a trademark of Atlassian. Google Sheets is a trademark of Google LLC. Sheetpane isn't made or endorsed by Atlassian or Google.