A sprint goal assembled from your tickets and their attachments

The scenario pulls the sprint's tickets, reads all their attached files, formulates the sprint goal, and emails you the result.

  • The attachments are read for you — sheets, docs, decks
  • The goal comes from the full context, not from memory
  • Planning starts with a draft goal already on the table
  • The result arrives by email, ready to edit and discuss
Agile

How it works

To pass leads from Microsoft Excel 365 to Microsoft Outlook automatically, use a ready-made scenario — no manual copying, no lost leads.

  1. Starts when: When clicking ‘Execute workflow’
  2. Then: Retrieve_Data_From_Sheet
  3. Then: Aggregate
  4. Then: Sprint Goal Generator
  5. Then: Send a message
  6. Then: Google Gemini Chat Model
  7. Then: Retrieve Agile Studio US
  8. Starts when: When Executed by Another Workflow
  9. Then: Get the Userstory data
  10. Then: Iterate over the attachments
  11. Check: Only select specific document
  12. Then: Keep only the attachment ID of document
  13. Then: Perform the API request with the ID of document
  14. Then: Convert the document to more readable format
  15. Check: Merge
  16. Check: Only select specific spreadsheets
  17. Check: Switch
  18. If yes: Keep only the attachment ID of the Sheet
  19. Then: Perform the API request with the ID of sheet
  20. Then: Convert to sheet data to readable format
  21. Check: Merge the results
  22. If no: Keep only the attachment ID of .xlsx
  23. Then: Download file
  24. Then: Extract from File
  25. Then: Convert the xlsx data to more readable format
  26. Check: Only select specific presentation
  27. Then: Keep only the attachment ID of presentation
  28. Then: Perform the API request with the ID of presentation
  29. Then: Convert the presentation to more readable format
  30. Then: Call 'Get Attachments - Agile Studio US'

You can launch this Microsoft Excel 365 + Microsoft Outlook integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.