Automated Lessons Learned Reporting from Jira to Google Docs using AI - n8n Workflow

Project Managers needing standardized, automated retrospective documentation.
Agile Teams and Scrum Masters looking to instantly capture knowledge when an Epic concludes.
Technical Leaders who want to leverage n8n templates for complex AI automation tasks.
Users seeking robust integration between Jira, OpenAI, and Google Docs within a single n8n environment.

Manual retrospective documentation is often inconsistent and time-consuming. This powerful n8n workflow solves this issue by creating a seamless, automated process. When an Epic status changes to 'Done' in Jira, the system triggers, collecting all related issue data and comments. This raw data is fed into an intelligent AI Agent n8n node, which uses a highly detailed prompt to generate a professional, structured Lessons Learned report in Markdown format. This specific n8n workflow ensures high quality, consistent output, dramatically reducing administrative overhead and ensuring knowledge transfer is immediate. Integrating these services via this specialized n8n template demonstrates the power and flexibility of n8n automation.

This highly efficient n8n workflow begins the moment a critical condition is met in your project management system.

1. Jira Trigger Setup: The process initializes with the Jira n8n trigger, listening for real-time updates to issues.


2. Completion Gate: An If n8n node immediately filters the payload, ensuring the n8n workflow only proceeds if the Epic's status has explicitly been updated to 'Done', based on the changelog data.


3. Data Extraction: The workflow uses Jira n8n nodes to fetch all associated issue details and, crucially, all comments posted under that Epic. This detailed information forms the basis of the report.


4. Preparation and Aggregation: The Edit Fields n8n node structures the retrieved data (Epic Name, Description, Title). The critical Summarize n8n node then combines all disparate comments into one clean, concatenated input field, optimizing the data for the AI.


5. AI Synthesis: The consolidated data is passed to the AI Agent n8n node, configured with the OpenAI Chat Model (using gpt-4o-mini). The agent follows a strict system message to analyze the context, synthesize key findings, and generate a comprehensive Lessons Learned report structured in Markdown, ready for publishing.


6. Final Documentation: The final step uses the Google Docs n8n node to take the AI-generated report ($json.output) and insert it into a designated Google Document, finalizing the entire n8n workflow automation.

To deploy this expert n8n workflow and start generating automated reports, follow these steps:

1. Import the JSON: Copy the provided n8n workflow JSON and paste it into your n8n instance via the 'New' menu -> 'Import from JSON'.


2. Jira Credentials: You must provide credentials for the Jira Software Cloud API for the Jira Trigger, Jira Get All Issues, and Jira Get All Comments n8n nodes. Ensure the API key and permissions allow reading issue details and webhooks.


3. OpenAI Credentials: Set up your API key credential for the OpenAI Chat Model n8n node. This powers the AI Agent in this n8n template.


4. Google Docs Setup: Configure the Google Docs OAuth2Api credential. Crucially, update the Google Docs n8n node with the specific Document URL (documentURL) where you want the final reports inserted.


5. Activate Webhook: Ensure the Jira Trigger webhook is successfully registered in your Jira environment (n8n usually guides this process when the n8n workflow is activated).


6. Testing: Mark a test Epic as 'Done' in Jira to ensure the n8n trigger fires and the full n8n workflow executes correctly.

Jira Trigger n8n node: Initiates the automation. It is configured to listen specifically for the jira:issueupdated event, providing a real-time n8n trigger.
If n8n node: Acts as a crucial flow control mechanism. It checks if the updated status in the changelog equals 'Done', ensuring the automation only runs at the correct completion point.
Jira Get All Issues / Jira Get All Comments n8n node: These nodes are responsible for data retrieval, pulling in core issue metadata and aggregating all team comments related to the Epic for detailed analysis.
Summarize n8n node: A key data manipulation n8n node. It groups the necessary metadata and concatenates the potentially large list of individual comments into a single field (concatenatedComment), making the input clean and ready for the LLM.
OpenAI Chat Model n8n node: Provides the underlying language model (gpt-4o-mini) used by the AI Agent.
AI Agent n8n node: The core intelligence of this n8n workflow. It uses a custom prompt structure to generate a highly detailed, professional Lessons Learned report in Markdown based on the Jira inputs. This is the central piece of this n8n template.

• Google Docs n8n node: The final destination. It takes the AI-generated Markdown output and inserts it into a specified Google document, completing the automated documentation task.