Automate Sprint Planning with OpenAI, Google Calendar, and Gmail for Agile Teams — n8n Workflow

High complexity⚡ Trigger42 nodes🏷️ Project Management👁 704 viewsby Willemijn

Overview

👤 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 time-consuming task of collecting, validating, and preparing backlog items for sprint planning—especially when coordinating with distributed teams or large product backlogs.

⚙️ What this workflow does Every week, the workflow:

Detects if a Sprint

Nodes used

Google SheetsGoogle DriveGoogle CalendarGmailCodeAI AgentOpenAI Chat Model

Workflow Preview

modelmodelmodelmodel
⚡
W
When clicking ‘Test work…
⚡
S
Schedule Trigger
N
No Operation, do nothing
Load Calendar of Scrum M…
Read DoR criteria
L
Loop Over Items for DoR …
Compare User Story to Do…
I
If no event do nothing
Take backlog link for fu…
Update Scrum feedback in…
OpenAI Scrum Master Emai…
OpenAI Scrum Master Stor…
OpenAI Scrum Master DoR …
A
Aggregate DoR check to U…
A
Add DoR feedback to User…
Provide Scrum Master Fee…
C
Combine stories into one…
⚡
E
Error Trigger
Ask Approval to Scrum Ma…
Send Email to Attendees
Create Draft in Scrum Ma…
Make aware the draft is …
I
If Email content is Appr…
S
Start Here: Set Environm…
Take DoR link for furthe…
Send Error Email
C
Check for Upcoming Sprin…
Select Stories Ready for…
Check Open Stories in Cu…
Draft Email for Sprint P…
A
Aggregate Stories for Fo…
Create Dynamic Form
Ask Scrum Master for Cur…
P
Process Feedback on Index
A
Append Feedback to Story
Draft Email for Sprint G…
K
Keep stories that were n…
C
Combine Sprint Spill ove…
A
Append Stories with DoR …
OpenAI Sprint Goal Email…
Send Email to PO
W
Wait until X days before…
42 nodes45 edges

How it Works

  1. 1

    Trigger

    The workflow starts with a trigger trigger.

  2. 2

    Process

    Data flows through 42 nodes, connecting agent, aggregate, code.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (42)

GO

Google Sheets

googleSheets

#1
GO

Google Drive

googleDrive

#2
GO

Google Calendar

googleCalendar

#3
GM

Gmail

gmail

#4
CO

Code

code

#5
AI

AI Agent

n8n-nodes-langchain.agent

#6
OP

OpenAI Chat Model

n8n-nodes-langchain.lmChatOpenAi

#7

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows → New → Import from file.
  3. 3Select the downloaded automate-sprint-planning-with-openai-google-calendar-and-gmail-for-agile-teams file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n → Import from JSON:

{ "name": "Automate Sprint Planning with OpenAI, Google Calendar, and Gmail for Agile Teams", "nodes": [...], ...}

Integrations

agentaggregatecodeerrortriggerfiltergmailgooglecalendargoogledrivegooglesheetsiflmchatopenaimanualtriggermergescheduletriggersetsplitinbatchessplitoutwait

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes42
Complexityhigh
Triggertrigger
Views704
CategoryProject Management

Created by

Willemijn

Willemijn

@willemijn

Tags

agentaggregatecodeerrortriggerfiltergmailgooglecalendargoogledrivegooglesheetsif
⚡

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free →