The Scenario
Monday standup is at 9 AM and the CTO wants a single-sheet view of every P1 and P2 issue currently open across four projects — WEB, API, MOBILE, INFRA — with assignee, status, and how long each has been open. He sends this ask on Friday afternoon. The data is scattered across four Jira project boards that each require a separate search.
The bad version:
- Open Jira, run a JQL query for P1/P2 bugs in WEB, copy the result table.
- Paste into a sheet. Reformat the columns.
- Run the same query for API, copy, paste below the WEB results. Fix the column headers so they align.
- Repeat for MOBILE and INFRA.
- Manually calculate the age of each issue by subtracting the created date from today.
Four separate exports, four separate reformatting passes, one calculated column. You get it done by 7 PM Friday. The CTO will have new comments on it by 8 AM Monday that require pulling fresh data — and you'll do the whole thing again.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the sheet and through the Jira integration queries all four projects simultaneously and assembles the combined output.
Search Jira for all open issues with priority P1 or P2 across projects WEB, API, MOBILE, and INFRA, and write the issue key, summary, project, assignee, priority, status, and days open into my Executive Report sheet.
What You Get
- One row per qualifying issue across all four projects.
- Issue key, summary, project key, assignee, priority, status, and days-open (calculated from the created date) in separate columns.
- The combined view is ready for the leadership standup without a single copy-paste or column-header fix.
- Unassigned issues show 'Unassigned' in the assignee column rather than a blank.
What If the Data Is Not Quite Ready
You need critical and high priority issues, not P1/P2, because your team uses different labels
Your projects use "Critical" and "High" instead of Jira's default P1/P2 priority scheme.
Fetch all critical and high priority open Jira issues across all projects and paste them into my sheet with columns: key, project, summary, assignee, priority, status, created date.
The CTO wants the issues sorted by days open descending so the stalest ones are at the top
Search Jira for all open issues with priority P1 or P2 across projects WEB, API, MOBILE, and INFRA. Write the issue key, summary, project, assignee, priority, status, and days open into my Executive Report sheet, sorted by days open descending.
You want a project-level summary row at the top before the individual issues
The sheet should open with a count per project so the CTO can see at a glance where the pressure is.
Search Jira for all open P1 and P2 issues across projects WEB, API, MOBILE, and INFRA. First, write a summary block at the top of my sheet: one row per project with the project key and total open P1+P2 count. Then below, write the full issue list with columns: key, summary, project, assignee, priority, status, days open.
Kill chain: fetch issues, flag any unassigned P1s, sort by severity then age, and add project subtotals
Search Jira for all open issues with priority P1 or P2 across projects WEB, API, MOBILE, and INFRA. Write issue key, summary, project, assignee, priority, status, and days open into my Executive Report sheet. Flag any unassigned P1 issue with 'Escalate' in a separate column. Sort by priority (P1 first) then by days open descending within each priority group. Below the issue list, add a subtotal block: one row per project with its count of P1 and P2 open issues.
The priority sort, the escalation flags, and the subtotals all land in one pass — ready to share before you close your laptop Friday evening.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet before the next leadership sync, then ask it to pull all critical open issues across your Jira projects into a single sorted view. See also: how to export team workload by assignee and how to export open bugs for triage.