⚒️ Generate Google Sheets test script from Pega Agile Studio user stories with AI
⚡ 39 views · ⚒️ Engineering
Description
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. This improves speed and efficiency while working in sprints on new functionalities.
Who’s it for
- If you are working as a software tester using the Pega Platform including Pega Agile Studio.
How it works
- When the user chats an userstory in the format “US-1234”, a HTTP Request will be made to Pega Agile Studio to retrieve the Userstory and commence creating a Google Spreadsheet.
- It will add the acceptance criteria on a seperate sheet for traceability.
- Next the AI will create testscases based on the Userstory provided.
- In the end, a small cleanup will be performed to remove duplicate rows/data created by the AI.
- You will have a Google Spreadsheet file in your My Drive containing your testcases!
How to set up
- In the Chat, provide the userstory where you want to create a testscript for, in the format “US-1234”.
- Add you OAuth2 Api for Agile Studio, so you can access the Pega Agile Studio through API calls.
Requirements
- Access to Pega Agile Studio OAuth2 Api.
- AI API.
- Access to Google Cloud for the Google API’s
🔗 Nodes Used
Google Sheets, HTTP Request, AI Agent, Chat Trigger, Google Gemini Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File