Documentation
Getting started
- Install SteadyRows for Jira from the Google Workspace Marketplace and approve Google's permission prompt (see the scopes we ask for and why).
- Open a Google Sheet on a computer (add-ons do not run in the mobile apps). In the menu choose Extensions, then SteadyRows for Jira, then Open. The sidebar opens.
- Click Connect to Jira and sign in with Atlassian (next section).
- Click New import, enter a JQL query, choose columns and click Save & run.
Your 14-day Pro trial starts on first use, no card needed. SteadyRows works with Jira Cloud only.
Connect to Jira
Click Connect to Jira. A tab from Atlassian opens asking you to approve access for the sites you choose. SteadyRows requests read-only permissions (read:jira-work, read:jira-user) and offline_access so scheduled refreshes keep working. Approve, close the tab and return to the sheet; the sidebar continues by itself. If no tab opened, use the Continue to Atlassian link in the sidebar.
- If you have several Jira sites, pick the site for each import.
- If Atlassian shows a warning that the app is not reviewed, it appears for any app that Atlassian has not individually reviewed. SteadyRows is read-only.
- Disconnect in the sidebar deletes the stored tokens. To revoke access on Atlassian's side too, visit id.atlassian.com/manage-profile/apps.
- If the connection expires, the sidebar shows Reconnect to Jira.
Create an import (JQL or saved filter)
An import is a saved query that fills one sheet tab. Choose New import, then either:
- Write JQL, for example
project = ABC AND status != Done ORDER BY created DESC. Use a bounded query (with a condition such as a project or date), as Jira does not accept an unboundedORDER BYon its own. - Pick a saved Jira filter that you own or have favourited. SteadyRows reads the filter's JQL each time you refresh, so changes you make to the filter in Jira apply on the next refresh.
Use a preview to check the query before the first run. Large imports run in batches with saved progress. If Google's six-minute limit is reached, SteadyRows stops cleanly and continues rather than failing. Imports can contain thousands of issues. The Free plan imports the first 500.
Columns and custom fields
- Issue Key is always column 1; it identifies each row.
- Search the field list and tick the fields you want. They appear in the order you choose.
- Custom fields (for example Sprint, Story point estimate, Start date, or your own fields) are a Pro feature. Rich text fields are converted to plain text.
- Columns are tracked by Jira field ID, not by header text. You can rename headers in the sheet, and rename fields in Jira, without breaking the sync.
- Your own columns (formulas, notes, anything you add) are never written to. You can insert them anywhere, including between imported columns. Row order is kept stable so formulas stay aligned.
- When an issue no longer matches the query, choose Remove rows (default) or Keep them. A very large removal asks for your confirmation first.
- Values that could be read as a formula, a date or a number with leading zeros (for example
=1+1,007) are stored as text, so imported content never runs as a formula.
Comments
Comments are a Pro feature. Turn on Include comments in the import options. SteadyRows puts the comments of each issue into one cell, oldest to newest. By default it includes the newest 20 comments per issue; you can set a limit up to 100. Comment text is converted from Jira's rich text format to plain text.
Refreshing and scheduled refresh
- Manual: click Refresh next to an import. Available on every plan.
- Scheduled (Pro, including the trial): in Refresh schedule choose 1 hour, 6 hours or 24 hours. A timer runs on Google's servers as you, and refreshes the imports in that spreadsheet that are due. Scheduled refresh stops if you uninstall the add-on.
- Why not faster than hourly? Google does not allow add-on time-driven triggers to run more often than once per hour. This is a Google limit.
- Google also caps total trigger running time per day. If you have many large imports, prefer longer intervals.
- Scheduled runs cannot show a message on screen, so the last run status of each import is shown in the sidebar.
Plans and licence activation
| Free | Pro (trial or paid) | |
|---|---|---|
| Saved queries | 1 | Unlimited |
| Issues per query | 500 | Unlimited |
| Custom fields | No | Yes |
| Comments | No | Yes |
| Refresh | Manual | Manual + scheduled (1h, 6h, 24h) |
To buy Pro, click Upgrade to Pro in the sidebar. After checkout (handled by Polar) you receive a licence key by email. Paste it into the licence section and click Activate. One key can be activated up to 10 times, so your team can share it. Deactivate frees an activation (for example when someone leaves). The add-on re-checks your key about once a day; if it cannot reach the licence server, Pro stays on for up to 7 days. Cancel or manage billing in the Polar customer portal. When a subscription ends the key stops working and the add-on returns to Free. Data already in your sheet stays.
If your Pro-only settings are still saved after a downgrade, the sidebar offers Remove Pro settings, and the import continues with Free features.
Troubleshooting
"A server error occurred while reading from storage" or PERMISSION_DENIED
If you're signed in to several Google accounts, Google may run the add-on as a different account than the one that owns the sheet, which fails. This is a known Google Apps Script limitation. Fix: open the sheet in a private (incognito) window with one account only, or sign out of the other accounts, then reload the sheet and try again.
"Your Jira connection expired"
Click Reconnect to Jira. This happens if access was revoked on Atlassian's side or the connection was unused for a long time.
The Jira tab did not open, or authorization timed out
Allow pop-ups for docs.google.com or click Continue to Atlassian. Then click Connect to Jira again. Do this within 10 minutes of the first click.
Only 500 issues were imported, or Pro columns are missing
You are on the Free plan (the trial ended or no valid licence is active). Upgrade to Pro, or reduce the query with JQL.
An issue I expected is missing, or the query is rejected
Jira only returns issues you can see. Check the JQL in Jira's own issue search. Bounded queries only (add a project or date condition). Jira's search can lag a few seconds to minutes behind recent changes.
"This license key is not valid", reached activation limit, or no longer active
Check that you pasted the whole key. A key can be active on up to 10 spreadsheets/accounts; use Deactivate where it is no longer needed, or contact us. A cancelled or expired subscription stops the key.
The scheduled refresh did not run
Scheduled refresh needs Pro. It runs at most once per hour and Google may delay triggers by some minutes. Check the import's last run status in the sidebar. Reconnect to Jira if the status says the connection expired.
Still stuck?
Email support@steadyrows.com. See what to include.