Create sprint goals from Google Sheets with Pega Agile Studio and Google Gemini — n8n Workflow

Hoog complexiteit⚡ Trigger30 knooppunten🏷️ Project Managementdoor Richard Nijsten

Overzicht

Create sprint goals using Pega Agile Studio with AI Based on the Google Sheet data, the AI will retrieve the userstories ID's, retrieves the userstory data and the corresponding attachments and creates sprint goals according to the defined system prompt.

Who's it for Product owners/Scrum masters that use Pega Agile Studio

How it works It retrieves the data from each userstory using the Agile Studio api, and the Google API to gather the attachments in the corresponding documents/sheets/slides

Gebruikte knooppunten

Google SheetsHTTP RequestGoogle DriveGmailCodeAI AgentCall n8n Workflow ToolGoogle Gemini Chat Model

Workflow-voorvertoning

Create sprint goals using Pega Agile Studio w
Based on the Google Sheet data, the AI will retrieve th
Native Sheets or .xlsx
If the attachment is a native Google Sheet, directly pe
If the file is a .xlsx file, download and extract the d
Subworkflow :
* Retrieving Google Sheet attachments
This Sheets API call will retrieve all attachments that
The Google API cannot process .xlsx files so a d
modeltooltool
Google Gemini Chat Model
Retrieve_Data_From_Sheet
R
Retrieve Agile Studio US
A
Aggregate
Send a message
Sprint Goal Generator
⚡
W
When clicking ‘Execute w…
⚡
W
When Executed by Another…
S
Switch
Download file
E
Extract from File
M
Merge the results
Convert to sheet data to…
Convert the xlsx data to…
K
Keep only the attachment…
K
Keep only the attachment…
O
Only select specific spr…
O
Only select specific doc…
O
Only select specific pre…
Get the Userstory data
I
Iterate over the attachm…
K
Keep only the attachment…
K
Keep only the attachment…
Perform the API request …
Perform the API request …
Convert the presentation…
Convert the document to …
Perform the API request …
M
Merge
Call 'Get Attachments - …
30 nodes31 edges

Hoe het werkt

  1. 1

    Trigger

    De workflow start met een trigger-trigger.

  2. 2

    Verwerking

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

  3. 3

    Uitvoer

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

Knooppuntdetails (30)

GO

Google Sheets

googleSheets

#1
HT

HTTP Request

httpRequest

#2
GO

Google Drive

googleDrive

#3
GM

Gmail

gmail

#4
CO

Code

code

#5
AI

AI Agent

n8n-nodes-langchain.agent

#6
CA

Call n8n Workflow Tool

n8n-nodes-langchain.toolWorkflow

#7
GO

Google Gemini Chat Model

n8n-nodes-langchain.lmChatGoogleGemini

#8

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 create-sprint-goals-from-google-sheets-with-pega-agile-studio-and-google-gemini 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": "Create sprint goals from Google Sheets with Pega Agile Studio and Google Gemini", "nodes": [...], ...}

Integraties

agentaggregatecodeexecuteworkflowtriggerextractfromfilefiltergmailgoogledrivegooglesheetshttprequesthttprequesttoollmchatgooglegeminimanualtriggermergesetsplitoutswitchtoolworkflow

Haal deze workflow op

Download en importeer met één klik

JSON downloadenBekijken op n8n.io
Knooppunten30
Complexiteithigh
Triggertrigger
CategorieProject Management

Gemaakt door

Richard Nijsten

Richard Nijsten

@rnijsten

Tags

agentaggregatecodeexecuteworkflowtriggerextractfromfilefiltergmailgoogledrivegooglesheetshttprequest
⚡

Nieuw bij n8n?

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

n8n gratis ophalen →