Rovo or Chat GPT prompts to help automate qualitative status reporting

[Sheila Connolly]

I'm a program manager who is responsible for updating a google slide deck weekly for executive team members. This slide deck primarily is used to show whether an initiative is on track or at risk, while showcasing any progress made towards that initiative during the week.

Not all the recipients have Atlassian licenses, so we have to manually update a presentation to be emailed out. Has anyone had any success leveraging Rovo or other AI tools to help pull relevant updates out of Jira and make them 'human readable' to an executive audience? Looking to get more comfortable with my use of AI in general, so any advice is greatly appreciated!

Our current Jira structure is as follows:

1. Initiatives exist for cross functional work

2. Epics are under those initiatives, and the epics are scheduled within a quarter

3. Epics are broken down into Stories and Tasks that are scheduled in Sprints to be executed by development teams 

[Gunjan Kumar · Accepted solution]

Hi Sheila,

Yes, Rovo can help summarize Jira work and produce qualitative status updates.

• Use Jira filters to capture Initiatives → Epics → Stories.
• Export results (CSV/Excel/Google Sheets) and provide them to Rovo or ChatGPT with a prompt like:
  “Summarize progress, risks, and overall status (On-Track / At-Risk).”
  

References:

• https://support.atlassian.com/jira-software-cloud/docs/export-search-results
• https://support.atlassian.com/organization-administration/docs/best-practices-for-atlassian-intelligence

[Dr Valeri Colon _Connect Centric_]

Hi @Sheila Connolly Yes—this is a great use case for Rovo, and people are doing something similar today. Rovo can pull Jira context and generate executive-friendly summaries, but it won’t automatically push to Google Slides.

A common pattern is:

• Use Rovo to summarize Initiatives/Epics → status, risks, progress
• Then paste into your deck (or use Automation/export + another tool)

Prompt example: “Summarize progress, risks, and next steps for Initiative X this week in executive-friendly language.”

For full automation, you’d need Rovo + API/Automation + a doc tool.