The Scenario
You are an engineering manager at a 20-person startup. The weekly team sync is at 10 AM on Thursday. It is 9:20 and you need a snapshot of all open pull requests across the company's eight Bitbucket repos — who owns them, how old they are, which branch they are targeting — in an Excel workbook on OneDrive so you can share it during the meeting.
Nobody tracks this centrally. The data is in Bitbucket, spread across eight separate PR queues.
The bad version of this morning:
- You open Bitbucket and navigate to the first repo's pull requests tab
- You copy titles, authors, and dates into the Excel workbook manually
- You move to the second repo, paste, and the columns land in the wrong places
- By repo five your paste is misaligned and you are fixing column headers mid-paste
- By repo seven you have a half-built table and six minutes to go
- You walk into the sync with three repos still uncovered and a workbook with inconsistent headers.
The fast version is one prompt and the table is done before you refill your coffee.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that calls the Bitbucket API, handles all eight repos in one pass, and writes the results with consistent column headers.
Open the SheetXAI sidebar and type:
List all open pull requests in Bitbucket workspace 'acme-corp' across every repo. Write repo name, PR title, author, source branch, target branch, and days open into columns A through F of the PRs tab. Sort by days open descending so the oldest PRs are at the top.
SheetXAI queries every repo, merges the results, applies the sort, and writes the full table into the PRs tab. No copy-paste, no column mismatches.
What You Get
A single flat table with one row per open PR:
- Repo name — which repository the PR belongs to
- PR title — the description as written by the author
- Author — who opened it
- Source and target branch — where it is going
- Days open — calculated from creation date to today, sorted descending
The oldest PRs are at the top. The one sitting untouched for nineteen days is row one. The one opened this morning is the last row.
Want to filter it down before the sync? Tell SheetXAI to show only PRs targeting the main branch, or only PRs older than seven days. It re-queries with the filter applied.
What If the Data Is Not Quite Ready
Real Bitbucket workspaces have messier PR queues than the scenario above. SheetXAI handles filtering, flagging, and summaries in the same prompt.
When PR titles are inconsistently formatted
Some engineers prefix titles with Jira ticket numbers, others write free-form. You want a clean title column without the ticket prefixes.
List all open PRs in Bitbucket workspace 'acme-corp'. In column A write the repo name. In column B write the PR title with any leading ticket prefix (like PROJ-1234) stripped. In column C write the author, in column D the days open. Write results into the PRs tab.
When you only want PRs targeting a specific branch
The workbook should show only PRs targeting main, not feature branches.
List all open pull requests in Bitbucket workspace 'acme-corp' where the target branch is 'main'. Write repo name, PR title, author, and days open into columns A through D of the PRs tab.
When you want to flag PRs with no reviewer assigned
Some PRs have been open for days because nobody claimed them. You want those flagged.
List all open PRs in Bitbucket workspace 'acme-corp'. Write repo, title, author, and days open in columns A through D of the PRs tab. In column E, write "Unreviewed" if the PR has no reviewer assigned, and "Assigned" if it does. Sort so unreviewed PRs appear first.
When you want a summary count by repo alongside the raw list
Your manager wants to see which repos have the most open PRs at a glance.
List all open PRs in Bitbucket workspace 'acme-corp' — repo, title, author, and days open in columns A through D on the Raw tab. On the Summary tab, write each repo name and the count of open PRs for that repo, sorted descending by count.
The pattern: the detail view and the rollup land in separate tabs in one prompt. The sync starts on time.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to list all open pull requests from your Bitbucket workspace. The Bitbucket integration is included in every SheetXAI plan. For related workflows, see how to measure PR review velocity in Excel or the Bitbucket in Excel overview.