Automate Agile Refinement Prep with Gmail, OpenAI & Google Sheets โ€” n8n ์›Œํฌํ”Œ๋กœ

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

๊ฐœ์š”

๐Ÿ‘ค Who is this for?
This workflow is designed for Scrum Masters, Agile Coaches, and Product Owners who want to automate backlog refinement preparation using Google Sheets, Gmail, and OpenAI. Itโ€™s ideal for teams seeking consistent, high-quality refinement sessions with minimal manual effort.

๐Ÿงฉ What problem is this workflow solving?
Many Agile teams struggle with unprepared refinement sessions, unclear user stories, and inconsistent feedback. This workflow solves that by automating the select

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

Google SheetsGoogle DriveGoogle CalendarGmailAI AgentOpenAI Chat Model

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

modelmodelmodelmodelmodel
โšก
W
When clicking โ€˜Test workโ€ฆ
โšก
S
Schedule Trigger
N
No Operation, do nothing
Load Calendar of Scrum Mโ€ฆ
C
Check for Refinement Proโ€ฆ
Read DoR criteria
L
Loop Over Items for DoR โ€ฆ
Compare User Story to Doโ€ฆ
Draft Email for Refinement
Business Validation
I
If no event do nothing
Update Business Validatiโ€ฆ
Take backlog link for fuโ€ฆ
Update Technical Validatโ€ฆ
Update Scrum feedback inโ€ฆ
OpenAI Business Analyst
OpenAI Technical Analyst
Select Stories Ready forโ€ฆ
Select Stories High Prioโ€ฆ
OpenAI Scrum Master Emaiโ€ฆ
OpenAI Scrum Master Storโ€ฆ
OpenAI Scrum Master DoR โ€ฆ
Development Team Validatโ€ฆ
J
Join Potential Stories fโ€ฆ
A
Add Scrum Feedback to Stโ€ฆ
A
Add Business feedback toโ€ฆ
L
Loop Over Items Businessโ€ฆ
A
Add Technical feedback tโ€ฆ
A
Aggregate DoR check to Uโ€ฆ
A
Add DoR feedback to Userโ€ฆ
Provide Scrum Master Feeโ€ฆ
L
Loop Over Items Technicaโ€ฆ
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
42 nodes48 edges

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

  1. 1

    ํŠธ๋ฆฌ๊ฑฐ

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

  2. 2

    ์ฒ˜๋ฆฌ

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

  3. 3

    ์ถœ๋ ฅ

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

๋…ธ๋“œ ์„ธ๋ถ€ ์ •๋ณด (42)

GO

Google Sheets

googleSheets

#1
GO

Google Drive

googleDrive

#2
GO

Google Calendar

googleCalendar

#3
GM

Gmail

gmail

#4
AI

AI Agent

n8n-nodes-langchain.agent

#5
OP

OpenAI Chat Model

n8n-nodes-langchain.lmChatOpenAi

#6

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

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

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

{ "name": "Automate Agile Refinement Prep with Gmail, OpenAI & Google Sheets", "nodes": [...], ...}

ํ†ตํ•ฉ

agentaggregateerrortriggerfiltergmailgooglecalendargoogledrivegooglesheetsiflmchatopenaimanualtriggermergescheduletriggersetsplitinbatches

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

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

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

์ œ์ž‘์ž

Willemijn

Willemijn

@willemijn

ํƒœ๊ทธ

agentaggregateerrortriggerfiltergmailgooglecalendargoogledrivegooglesheetsiflmchatopenai
โšก

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

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

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