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

Hoog complexiteit⚡ Trigger42 knooppunten🏷️ Project Management👁 704 weergavendoor Willemijn

Overzicht

👤 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

Gebruikte knooppunten

Google SheetsGoogle DriveGoogle CalendarGmailCodeAI AgentOpenAI Chat Model

Workflow-voorvertoning

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

Hoe het werkt

  1. 1

    Trigger

    De workflow start met een trigger-trigger.

  2. 2

    Verwerking

    Gegevens stromen door 42 knooppunten, connecting agent, aggregate, code.

  3. 3

    Uitvoer

    De workflow voltooit zijn automatisering en levert het resultaat aan de geconfigureerde bestemming.

Knooppuntdetails (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

Hoe deze workflow te importeren

  1. 1Klik op de knop JSON downloaden rechts om het workflowbestand op te slaan.
  2. 2Open uw n8n-instantie. Ga naar Workflows → Nieuw → Importeren uit bestand.
  3. 3Selecteer het gedownloade bestand automate-sprint-planning-with-openai-google-calendar-and-gmail-for-agile-teams en klik op Importeren.
  4. 4Stel inloggegevens in voor elk serviceknooppunt (API-sleutels, OAuth, enz.).
  5. 5Klik op Workflow testen om te controleren of alles werkt, activeer het vervolgens.

Of plak rechtstreeks in n8n → Importeren uit JSON:

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

Integraties

agentaggregatecodeerrortriggerfiltergmailgooglecalendargoogledrivegooglesheetsiflmchatopenaimanualtriggermergescheduletriggersetsplitinbatchessplitoutwait

Haal deze workflow op

Download en importeer met één klik

JSON downloadenBekijken op n8n.io
Knooppunten42
Complexiteithigh
Triggertrigger
Weergaven704
CategorieProject Management

Gemaakt door

Willemijn

Willemijn

@willemijn

Tags

agentaggregatecodeerrortriggerfiltergmailgooglecalendargoogledrivegooglesheetsif
⚡

Nieuw bij n8n?

n8n is een gratis open-source workflow-automatiseringstool. Host het zelf of gebruik de cloudversie.

n8n gratis ophalen →