Compare terminated users against active system access
Task · User access reviews
Time saved · 1-2 hrs per quarter (estimate, not measured)
⚠️ AI output is a draft only. It must be reviewed and signed off by a qualified reviewer before it is relied on or included in audit documentation.
Steps
- Open the sheet in Google Sheets
- Open the Gemini side panel
- Enter the prompt
- Verify results against a pivot table or manual check
Prompt / template
Find users in the HR terminations sheet who still appear as active in the System Users sheet, with termination date and last login.
Source · https://support.google.com/docs/answer/14218565
Last checked · 2026-10-16