Help

1. Create a Jira API token

Go to id.atlassian.com → Security → API tokens.
Click Create API token, name it "IssueGrid", pick an expiry and copy the token.

IssueGrid only sees what your Jira account can see. The token is stored in your Google account's private storage for this add-on and is sent only to your *.atlassian.net site.

2. Connect

Open a spreadsheet, then Extensions → IssueGrid → Open. Enter your site (yourteam.atlassian.net), your Jira login email and the token.

3. Create an import

Pick a saved filter or write JQL. Click Check query to validate it and see roughly how many issues match. Choose fields and a tab name, then Import. Each import owns one tab and replaces its contents on every refresh, so put your own formulas and charts on other tabs that reference it.

Useful JQL

`project = WEB AND sprint in openSprints()`	Current sprint
`project = WEB AND statusCategory != Done ORDER BY priority DESC`	Open backlog by priority
`assignee = currentUser() AND resolution = Unresolved`	My open issues
`project = WEB AND resolved >= startOfMonth()`	Resolved this month
`issuetype = Bug AND created >= -30d`	Bugs from the last 30 days

Auto-refresh and history (Pro)

Set an import to Every hour or Daily in the sidebar. The refresh runs with your Jira connection even when the sheet is closed. Tick Keep a daily history of status counts to append counts per status to the IssueGrid History tab on every refresh, ideal for burndown and cumulative-flow charts. Deleting an import's tab stops its schedule.

Troubleshooting

The sidebar shows "PERMISSION_DENIED" or stays blank

This is a Google limitation when you are signed in to several Google accounts in the same browser. Open the spreadsheet in a browser window (or Chrome profile, or incognito window) where only the account that owns the sheet is signed in.

"Jira rejected the email or API token"

The token expired or was revoked, or the email doesn't match the Atlassian account. Create a new token and reconnect.

"Jira could not run this query"

The message after it is Jira's own JQL error. Test the query in Jira's issue search first.

Only 500 rows imported

That's the free plan limit (the note on cell A1 says so). Pro removes it.

A column disappeared

If a custom field is deleted in Jira, IssueGrid skips it and tells you which one.

Something else

Email ahustlega@gmail.com with the error message. Never send your API token.