Create sprint goals from Google Sheets with Pega Agile Studio and Google Gemini
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (18)
- Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Google Sheets
n8n-nodes-base.googleSheets - Http Request Tool
n8n-nodes-base.httpRequestTool - Aggregate
n8n-nodes-base.aggregate - Gmail
n8n-nodes-base.gmail - AI Agent
@n8n/n8n-nodes-langchain.agent - Manual Trigger
n8n-nodes-base.manualTrigger - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - Switch
n8n-nodes-base.switch - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Filter
n8n-nodes-base.filter - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Call n8n Workflow Tool
@n8n/n8n-nodes-langchain.toolWorkflow
What it does
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 "RetrieveDataFromSheet" 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