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

Go to Workflow
0 views
Built by Richard Nijsten Richard Nijsten
Created on June 12, 2026

Description

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.
Then the AI processes it according to the system prompt and generates a mail.


How to set up
Create a Google Sheet and add the userstories you want in the Google Sheet in column named "Userstory".
Set the GoogleSheet ID in the node "Retrieve_Data_From_Sheet"
Setup other credentials.
Publish the subworkflow for attachment handling.
Execute the workflow.

Requirements
Access to Pega Agile Studio OAuth2 Api.
AI API.
Access to Google Cloud for the Google API's

Nodes Used (8)

AI Agent
@n8n/n8n-nodes-langchain.agent
Call n8n Workflow Tool
@n8n/n8n-nodes-langchain.toolWorkflow
Code
n8n-nodes-base.code
Gmail
n8n-nodes-base.gmail
Google Drive
n8n-nodes-base.googleDrive
Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
Google Sheets
n8n-nodes-base.googleSheets
HTTP Request
n8n-nodes-base.httpRequest