Summarize IT ticket backlog in Google Sheets
Task · Backlog review
Time saved · 30 min per week (estimate, not measured)
Steps
- Open the Google Workspace app (Gmail, Docs, Sheets or Meet)
- Open the Gemini side panel or 'Help me write'
- Enter the prompt
- Verify the result before sending or sharing
Prompt / template
Summarize open tickets by category and age, and list tickets older than 14 days.
Source · https://support.google.com/docs/answer/14218565
Last checked · 2026-10-16