Automate Sprint Planning with OpenAI, Google Calendar, and Gmail for Agile Teams โ€” n8n ์›Œํฌํ”Œ๋กœ

๋†’์Œ ๋ณต์žก๋„โšก ํŠธ๋ฆฌ๊ฑฐ42๊ฐœ์˜ ๋…ธ๋“œ๐Ÿท๏ธ Project Management๐Ÿ‘ 704ํšŒ ์กฐํšŒ์ž‘์„ฑ์ž: Willemijn

๊ฐœ์š”

๐Ÿ‘ค 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

์‚ฌ์šฉ๋œ ๋…ธ๋“œ

Google SheetsGoogle DriveGoogle CalendarGmailCodeAI AgentOpenAI Chat Model

์›Œํฌํ”Œ๋กœ ๋ฏธ๋ฆฌ๋ณด๊ธฐ

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

์ž‘๋™ ์›๋ฆฌ

  1. 1

    ํŠธ๋ฆฌ๊ฑฐ

    ์›Œํฌํ”Œ๋กœ๋Š” ํŠธ๋ฆฌ๊ฑฐ ํŠธ๋ฆฌ๊ฑฐ๋กœ ์‹œ์ž‘ํ•ฉ๋‹ˆ๋‹ค.

  2. 2

    ์ฒ˜๋ฆฌ

    ๋ฐ์ดํ„ฐ๊ฐ€ 42๊ฐœ์˜ ๋…ธ๋“œ๋ฅผ ํ†ตํ•ด ํ๋ฆ…๋‹ˆ๋‹ค, connecting agent, aggregate, code.

  3. 3

    ์ถœ๋ ฅ

    ์›Œํฌํ”Œ๋กœ๊ฐ€ ์ž๋™ํ™”๋ฅผ ์™„๋ฃŒํ•˜๊ณ  ๊ตฌ์„ฑ๋œ ๋Œ€์ƒ์— ๊ฒฐ๊ณผ๋ฅผ ์ „๋‹ฌํ•ฉ๋‹ˆ๋‹ค.

๋…ธ๋“œ ์„ธ๋ถ€ ์ •๋ณด (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

์ด ์›Œํฌํ”Œ๋กœ ๊ฐ€์ ธ์˜ค๋Š” ๋ฐฉ๋ฒ•

  1. 1์˜ค๋ฅธ์ชฝ์˜ JSON ๋‹ค์šด๋กœ๋“œ ๋ฒ„ํŠผ์„ ํด๋ฆญํ•˜์—ฌ ์›Œํฌํ”Œ๋กœ ํŒŒ์ผ์„ ์ €์žฅํ•ฉ๋‹ˆ๋‹ค.
  2. 2n8n ์ธ์Šคํ„ด์Šค๋ฅผ ์—ด๊ณ  ์›Œํฌํ”Œ๋กœ โ†’ ์ƒˆ๋กœ ๋งŒ๋“ค๊ธฐ โ†’ ํŒŒ์ผ์—์„œ ๊ฐ€์ ธ์˜ค๊ธฐ๋กœ ์ด๋™ํ•ฉ๋‹ˆ๋‹ค.
  3. 3๋‹ค์šด๋กœ๋“œ๋œ automate-sprint-planning-with-openai-google-calendar-and-gmail-for-agile-teams ํŒŒ์ผ์„ ์„ ํƒํ•˜๊ณ  ๊ฐ€์ ธ์˜ค๊ธฐ๋ฅผ ํด๋ฆญํ•ฉ๋‹ˆ๋‹ค.
  4. 4๊ฐ ์„œ๋น„์Šค ๋…ธ๋“œ์— ๋Œ€ํ•œ ์ž๊ฒฉ ์ฆ๋ช…๏ผˆAPI ํ‚ค, OAuth ๋“ฑ๏ผ‰์„ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.
  5. 5์›Œํฌํ”Œ๋กœ ํ…Œ์ŠคํŠธ๋ฅผ ํด๋ฆญํ•˜์—ฌ ๋ชจ๋“  ๊ฒƒ์ด ์ž‘๋™ํ•˜๋Š”์ง€ ํ™•์ธํ•œ ํ›„ ํ™œ์„ฑํ™”ํ•ฉ๋‹ˆ๋‹ค.

๋˜๋Š” n8n โ†’ JSON์—์„œ ๊ฐ€์ ธ์˜ค๊ธฐ์— ์ง์ ‘ ๋ถ™์—ฌ๋„ฃ๊ธฐ:

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

ํ†ตํ•ฉ

agentaggregatecodeerrortriggerfiltergmailgooglecalendargoogledrivegooglesheetsiflmchatopenaimanualtriggermergescheduletriggersetsplitinbatchessplitoutwait

์ด ์›Œํฌํ”Œ๋กœ ๊ฐ€์ ธ์˜ค๊ธฐ

ํ•œ ๋ฒˆ์˜ ํด๋ฆญ์œผ๋กœ ๋‹ค์šด๋กœ๋“œ ๋ฐ ๊ฐ€์ ธ์˜ค๊ธฐ

JSON ๋‹ค์šด๋กœ๋“œn8n.io์—์„œ ๋ณด๊ธฐ
๋…ธ๋“œ42
๋ณต์žก๋„high
ํŠธ๋ฆฌ๊ฑฐtrigger
์กฐํšŒ์ˆ˜704
์นดํ…Œ๊ณ ๋ฆฌProject Management

์ œ์ž‘์ž

Willemijn

Willemijn

@willemijn

ํƒœ๊ทธ

agentaggregatecodeerrortriggerfiltergmailgooglecalendargoogledrivegooglesheetsif
โšก

n8n์„ ์ฒ˜์Œ ์‚ฌ์šฉํ•˜์‹œ๋‚˜์š”?

n8n์€ ๋ฌด๋ฃŒ ์˜คํ”ˆ์†Œ์Šค ์›Œํฌํ”Œ๋กœ ์ž๋™ํ™” ๋„๊ตฌ์ž…๋‹ˆ๋‹ค. ์ž์ฒด ํ˜ธ์ŠคํŒ…ํ•˜๊ฑฐ๋‚˜ ํด๋ผ์šฐ๋“œ ๋ฒ„์ „์„ ์‚ฌ์šฉํ•˜์„ธ์š”.

n8n ๋ฌด๋ฃŒ๋กœ ์‹œ์ž‘ํ•˜๊ธฐ โ†’