Automate sprint planning with OpenAI, Google Calendar, and Gmail for agile teams
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 42 nodes and runs when another workflow fails (error workflow) (plus 2 other triggers). Along the way it connects Google Calendar, Google Sheets, Google Drive and OpenAI Chat Model and 1 more.
How it runs
Trigger: When another workflow fails (error workflow) (plus 2 other triggers).
- Send Error Email (Gmail): uses Gmail
- Start Here: Set Environment Variables (Edit Fields (Set)): sets or maps fields
- Load Calendar of Scrum Master (Google Calendar): uses Google Calendar
- Check for Upcoming Sprint Planning Project A (Filter): keeps only the items that match a condition
- Take DoR link for further referral (Google Drive): uses Google Drive
- Take backlog link for further referral (Google Drive): uses Google Drive
- Check Open Stories in Current Sprint (Google Sheets): uses Google Sheets
- Aggregate: combines items into one
- Append Feedback to Story (Merge): merges the data from its input branches
- Create Dynamic Form (Code): runs custom JavaScript code
…plus 23 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Compare User Story to DoR Criterium (v1.9), Provide Scrum Master Feedback on the story (v1.9), Draft Email for Sprint Planning (v1.8)…: replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Compare User Story to DoR Criterium (v1.9), Provide Scrum Master Feedback on the story (v1.9), Draft Email for Sprint Planning (v1.8), Draft Email for Sprint Goal Suggestions (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (19)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - No Operation, do nothing
n8n-nodes-base.noOp - Google Calendar
n8n-nodes-base.googleCalendar - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Drive
n8n-nodes-base.googleDrive - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Aggregate
n8n-nodes-base.aggregate - Merge
n8n-nodes-base.merge - Error Trigger
n8n-nodes-base.errorTrigger - Gmail
n8n-nodes-base.gmail - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - Split Out
n8n-nodes-base.splitOut - Wait
n8n-nodes-base.wait
From the author
👤 Who is this for? This workflow is designed for Scrum Masters and Agile Coaches who prepare and coordinate Sprint Planning sessions, using Google Calendar, Google Sheets, and OpenAI. 🧩 What problem is this workflow solving? It solves the manual and…