Analyze Jira data in ChatGPT with Windsor.ai

To analyze live Jira data in ChatGPT, connect Jira to Windsor.ai once and add the Windsor.ai plugin in ChatGPT. Then ask in plain English, for example “summarize the blockers in the current sprint” or “who has the most overdue work items”.

Windsor.ai reads your projects, sprints, worklogs and change history, and can put Jira next to GitHub, Zendesk or Salesforce in the same chat. It is read-only, so nothing changes in Jira.

Setting it up for the first time, or need ChatGPT to create tickets? The step-by-step guide to connect Jira to ChatGPT covers every route, including Atlassian’s own connector.

Try It Free

Free forever plan

No credit card needed

Windsor.ai is your proven Jira to ChatGPT connector

What teams report on from Jira in ChatGPT

Windsor.ai gives ChatGPT the Jira fields these reports need, including each work item’s change log, sprint dates and worklogs.

Find where work waits longest

Windsor.ai includes each work item’s change log, so ChatGPT can work out how long items stay in each status, such as Code Review or QA. Use it to decide where to add reviewers or remove an approval step.

Track work added mid-sprint

List the work items added to an active sprint after its start date and how much they added to the team’s load. Use it to plan the next sprint with a capacity the team can meet.

Forecast project completion dates

Estimate a delivery date from the remaining backlog and the number of work items completed per sprint so far. Share a best-case and a worst-case date with stakeholders.

Monitor overdue work items

Ask ChatGPT for work items past their due date, grouped by assignee, with the latest comment on each, to see why they are late.

Report on Jira next to your other tools

Supported fields: 11 metrics460 dimensions

Windsor.ai connects 350+ sources, so one ChatGPT question can cover Jira and the tools around it: support tickets from Zendesk per released version, GitHub pull requests per sprint, or Salesforce deals waiting on open feature requests.

Jira alone fits the free forever plan. Jira plus other sources starts at $19/month for 3 sources.

Jira analytics prompts to try in ChatGPT:

Summarize all tasks completed in the last 24 hours and list what is currently ‘In Progress.’ Highlight any tasks that haven’t moved status since yesterday so we can discuss potential blockers.
Compare our current progress against our sprint goals. Based on the number of remaining tasks and our current pace, are we on track to finish everything by the sprint end date?
Provide a breakdown of active tasks assigned to each team member. Identify if anyone is over-capacity compared to the rest of the team and suggest tasks that could be reassigned to balance the load.
List all tasks that have passed their target completion or due date. Group them by project lead and summarize the most recent comment on each to see why they are delayed.

Join over 19,000+ businesses that trust Windsor.ai to streamline Jira to ChatGPT integration

Set up Jira in ChatGPT with Windsor.ai

Three steps with screenshots below, plus a video of the Windsor.ai ChatGPT app. For every route, including Atlassian’s own connector, see the full guide to connecting Jira to ChatGPT.

Select your data source

Choose Jira as your data source and enter your Jira domain, email and API token.

Install the Windsor.ai plugin

Click Install plugin, then sign in to Windsor.ai.

Query your Jira data in ChatGPT

Open a new chat and start asking questions about your connected Jira data using natural language.

Make sure that the Windsor.ai connector is enabled (click the + sign → More → Windsor.ai.)

Jira data available in ChatGPT

Windsor.ai’s Jira connector returns 471 fields. These are the ones teams ask about most. The Jira field reference has the full list.

Field	What it shows
Project name	Which product or team a work item belongs to, so you can split delivery data by project.
Work item type	Story, Bug, Task or Epic, the basis for your bug rate and the mix of work.
Workflow status	The status label in your workflow, such as In Review, QA or Blocked.
Status category	To Do, In Progress or Done, which groups custom statuses into simple stages.
Priority	The severity assigned to a work item, from Blocker to Minor.
Resolution	How a work item was closed, such as Fixed, Won’t Fix or Duplicate.
Sprint name	Which sprint a work item was planned in, for comparing delivery across sprints.
Sprint state	Active, closed or future, so you know which sprints have final numbers.
Sprint start and end date	The sprint’s date range, for sprint length and on-time delivery.
Time spent (worklogs)	Time logged on a work item, by person and date, for planned versus actual effort.
Change log	Every status change with its date, the basis for cycle time and time in status.
Component	The part of the product a work item belongs to, such as Checkout or API, and how many items each component has.

FAQs

What can I do with Jira data in ChatGPT?

Summarize sprint progress, find blockers, check workload per person and forecast delivery dates by asking in plain English. Windsor.ai gives ChatGPT access to 471 Jira fields across projects, work items, sprints, worklogs, components and versions.

Should I use Windsor.ai or Atlassian's Rovo connector?

Use Atlassian’s Atlassian Rovo connector to create and update Jira work items from ChatGPT. Use Windsor.ai for reporting: history across sprints, time logged per person, and Jira next to tools outside Atlassian, such as GitHub, Zendesk or Salesforce. Many teams add both. The Jira to ChatGPT setup guide covers each route.

Can Windsor.ai change anything in Jira?

No. The Jira connection is read-only. ChatGPT can analyze your work items, sprints and worklogs through Windsor.ai, but it cannot create, update or delete anything in Jira. To act on tickets from ChatGPT, use Atlassian’s Atlassian Rovo connector.

Can ChatGPT help me identify current project blockers?

Yes. ChatGPT can list work items that have not changed status for several days, are past their due date or are marked as blocked, so you can see what is holding up the sprint.

Can I monitor individual team member workloads in ChatGPT?

Yes. Ask for the open work items assigned to each team member to check that work is spread evenly and that no one is over capacity.

Can I track time spent on specific projects?

Yes. Windsor.ai includes Jira worklogs, so ChatGPT can add up the hours logged per project, epic or person for any period.

What prompts can I use to analyze Jira data in ChatGPT?

These go further than a status summary:

Calculate the average cycle time for work items, from the moment they move to 'In Progress' to when they are 'Done'. Which status (for example Code Review or QA) do items spend the most time in?

Compare the velocity and completion rates across [Project A] and [Project B]. Which project is moving faster, and what is different about how its work is set up?

Based on our average velocity over the last three months and the size of the remaining backlog, what is the most likely completion date for [Project Name]? Give a best-case and worst-case date.

Compare the number of Bug work items created with Feature work items over the last 90 days. Do reported bugs go up after releases, and which components are linked to the most bugs?

How much does it cost to analyze Jira data in ChatGPT with Windsor.ai?

Jira on its own fits Windsor.ai’s free forever plan, with no credit card. To report on Jira next to other tools, paid plans start at $19/month for 3 sources and $99/month for 7. See the pricing page.

Can I see the impact of bug fixes on feature development?

Yes. Ask for a comparison of time logged on bugs and maintenance against new features, to check the balance between fixing and building.

Can I compare this quarter's productivity to the last?

Yes. Ask for a quarter-over-quarter comparison of completed work and velocity to see whether delivery is speeding up or slowing down.

Analyze Jira data in ChatGPT without exports

Free forever plan, no credit card.

Start for Free Book a Demo