Back to Templates

Generate Google Sheets test script from Pega Agile Studio user stories with Gemini AI

Created by

Created by: Richard Nijsten || rnijsten

Richard Nijsten

Last update

Last update a day ago

Share


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