Skip to content
FlowHub
FluxonLab
AI Agents & Chatbotsfree

Generate Google Spreadsheets Testscript with AI Using Pega Agile Studio

by Richard NijstenUpdated Aug 2026
RequiresGoogle GeminiGoogle SheetsGoogle Sheets
Share Post Share
ChWhen chat message receivedWhen chat messa…Google Gemini Chat ModelGoogle Gemini C…CoCodeSOSplit OutCoAddNumbersToAccCritAddNumbersToAcc…SOIterateOverAccCritIterateOverAccC…MeMergeMeMerge2Create spreadsheet for the testscriptCreate spreadsh…HRRetrieve the US from Pega Agile StudioRetrieve the US…Add acceptance criteria to the Google SpreadsheetAdd acceptance …HRAdd column headers for the first sheetAdd column head…HRAdd column headers for the second sheetAdd column head…AgAI: Create testcasesAI: Create test…MeMerge: Get SpreadsheetIDMerge: Get Spre…Add testcases to the correct columnsAdd testcases t…Clear Google SpreadsheetClear Google Sp…CoCode to remove redundant dataCode to remove …Add the cleaned testcases back in the Google SpreadsheetAdd the cleaned…123456789101112131415161718192021
1/5
STEPS · 21
Starts from a chat message

On a chat message, a Gemini agent generates test scripts from Pega Agile Studio data and writes them to Google Sheets.

Tags

webhookcomplexGoogle GeminiGoogle SheetsEngineeringMultimodal AIdiscoveredpending-review
Connects
Google GeminisheetsGoogle Sheets
CategoryAI Agents & Chatbots
Triggerwebhook
Complexitycomplex
Nodes19
AddedJun 27, 2026