Generate daily Jira summaries & weekly reports with Azure OpenAI and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 15 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Azure OpenAI Chat Model, Jira Software, Google Sheets and Gmail.
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Get ALL issues (Jira Software): get many
- Get all stored data (Google Sheets): uses Google Sheets
- Flatten Input (Code): runs custom JavaScript code
- Flatten the input (Code): runs custom JavaScript code
- Create Summary (AI Agent): runs an AI agent, with model: Azure OpenAI Chat Model; output parser: Structured Output Parser
- Create Weekly Summary (AI Agent): runs an AI agent, with model: Azure OpenAI Chat Model; output parser: Structured Output Parser
- Append Summary (Google Sheets): append
- Create Email (Code): runs custom JavaScript code
- Email to Stakeholders (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Jira Software
n8n-nodes-base.jira - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Gmail
n8n-nodes-base.gmail
From the author
Description Automates daily EOD summaries from Jira issues into an Excel sheet, then compiles a weekly summary using Azure OpenAI (GPT-4o-mini) and delivers it to stakeholders via email. Gain consistent reporting, clear insights, and hands-free delivery. ✨📧…