Generate Sprint Review Summaries from Transcripts with OpenAI and Google Sheets — n8n Workflow

Medium complexity⚡ Trigger6 nodes🏷️ Project Managementby Arkadiusz

Overview

What this workflow does

This template automates the entire process of documenting Sprint Reviews in Scrum:
Input Collection – Through a friendly form, users upload the transcript file (meeting notes, sprint review transcript, or VTT captions) and specify the sprint name and domain.
Transcript Parsing – A Code node formats the transcript into clean [HH:MM:SS] Speaker: text lines, supporting VTT, Zoom, or custom timestamp formats used in Scrum events.
AI-Driven Summary – The AI Agent (LangC

Nodes used

Google SheetsCodeAI AgentOpenAI Chat Model

Workflow Preview

Overview
Sprint Review Transcript → AI Markdown Summary → Google
Inputs: File (VTT/text), Sprint name, Domain.
Outputs: Preview in UI + archived row in Sheet.
Input Form
Collects transcript file + sprint + domain.
Transcript Parser
Normalizes to `[HH:MM:SS] Speaker: text`.
Supports VTT and simple speaker/timestamp lines.
AI Summary
Creates executive bullets, recap table, and action item
Preview
Shows the generated Markdown with custom CSS.
Archive to Sheets
Saves summary + transcript + metadata (date/domain/spri
LLM Backend
OpenAI Chat Model used by AI Agent.
model
⚡
C
Collect Sprint Review In…
Parse Transcript
Generate Summary
P
Preview Summary
OpenAI LLM
Save to Google Sheets
6 nodes5 edges

How it Works

  1. 1

    Trigger

    The workflow starts with a trigger trigger.

  2. 2

    Process

    Data flows through 6 nodes, connecting agent, code, form.

  3. 3

    Output

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

Node Details (6)

GO

Google Sheets

googleSheets

#1
CO

Code

code

#2
AI

AI Agent

n8n-nodes-langchain.agent

#3
OP

OpenAI Chat Model

n8n-nodes-langchain.lmChatOpenAi

#4

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 generate-sprint-review-summaries-from-transcripts-with-openai-and-google-sheets 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": "Generate Sprint Review Summaries from Transcripts with OpenAI and Google Sheets", "nodes": [...], ...}

Integrations

agentcodeformformtriggergooglesheetslmchatopenai

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes6
Complexitymedium
Triggertrigger
CategoryProject Management

Created by

Arkadiusz

Arkadiusz

@akadiusz

Tags

agentcodeformformtriggergooglesheetslmchatopenai
⚡

New to n8n?

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

Get n8n Free →