Automation library · Data collection

Create sprint goals from Google Sheets with Pega Agile Studio

Started by an event in a connected app, and works across Gmail, Google Drive and Google Sheets. It hands the judgement calls to Gemini. 30 steps, 1 branch: large, and worth reading before you trust it with anything live.

LargeCalls a model: Gemini

Download free
30 stepsLarge: read it before trusting it with anything live
1Branch: places the flow splits
0Loops or waits
3Services it connects to

The flow

Starts it 2Model 3Logic 16Service 9

The steps in the order they run, from what starts it.

  1. 1Google Gemini Chat ModelLm Chat Google GeminiModel
  2. 2Retrieve Agile Studio USHttp Request ToolService
  3. 3When clicking ‘Execute workflow’Manual triggerStarts it
  4. 4When Executed by Another WorkflowExecute Workflow triggerStarts it
  5. 5Call 'Get Attachments - Agile Studio US'Tool WorkflowModel
  6. 6Sprint Goal GeneratorAgentModel
  7. 7Retrieve_Data_From_SheetGoogle SheetsService
  8. 8Get the Userstory dataHttp RequestService
  9. 9Send a messageGmailService
  10. 10AggregateAggregateLogic
  11. 11Iterate over the attachmentsSplit OutLogic
  12. 12Only select specific documentFilterLogic
  13. 13Only select specific spreadsheetsFilterLogic
  14. 14Only select specific presentationFilterLogic
  15. 15Keep only the attachment ID of documentSetLogic
  16. 16SwitchSwitchLogic
  17. 17Keep only the attachment ID of presentationSetLogic
  18. 18Perform the API request with the ID of documentHttp RequestService
  19. 19Keep only the attachment ID of the SheetSetLogic
  20. 20Keep only the attachment ID of .xlsxSetLogic
  21. 21Perform the API request with the ID of presentationHttp RequestService
  22. 22Convert the document to more readable formatCodeLogic
  23. 23Perform the API request with the ID of sheetHttp RequestService
  24. 24Download fileGoogle DriveService
  25. 25Convert the presentation to more readable formatCodeLogic
  26. 26MergeMergeLogic
  27. 27Convert to sheet data to readable formatCodeLogic
  28. 28Extract from FileExtract From FileService
  29. 29Merge the resultsMergeLogic
  30. 30Convert the xlsx data to more readable formatCodeLogic

How it's built

Starts on
An event in a connected app
Steps
30, with 1 branch
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Drive, Google Sheets
Model
Gemini

Questions

What does it need to run?

An n8n account, plus your own Gmail, Google Drive and Google Sheets accounts, and a key for Gemini. You connect your own accounts after importing it; none are included.

What starts it?

It starts on an event in a connected app.

Does it use AI?

Yes. It calls Gemini. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 30 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 30 steps before you point it at anything that matters.