Generate Google Sheets test script from Pega Agile Studio user stories with AI
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.
What this workflow does
This AI workflow has 19 nodes and runs when a chat message arrives. Along the way it connects Google Gemini Chat Model and Google Sheets.
How it runs
Trigger: When a chat message arrives.
- Retrieve the US from Pega Agile Studio (HTTP Request): calls an HTTP API
- IterateOverAccCrit (Split Out): splits a list into separate items
- AI: Create testcases (AI Agent): runs an AI agent, with model: Google Gemini Chat Model
- Create spreadsheet for the testscript (Google Sheets): work with spreadsheet
- AddNumbersToAccCrit (Code): runs custom JavaScript code
- Code: runs custom JavaScript code
- Add column headers for the first sheet (HTTP Request): calls an HTTP API (PUT)
- Add column headers for the second sheet (HTTP Request): calls an HTTP API (PUT)
- Merge: merges the data from its input branches
- Merge: merges the data from its input branches
…plus 7 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Code
n8n-nodes-base.code - Split Out
n8n-nodes-base.splitOut - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - AI Agent
@n8n/n8n-nodes-langchain.agent
From the author
Generate Google Spreadsheets Testscript with AI using Pega Agile Studio When working as a functional Pega Software tester, this workflow will create a Google Spreadsheet with acceptance criteria and testcases based on the Pega Agile Studio userstory provided.…