The Scenario
You are a CTO. Security's quarterly access review lands on your calendar for Friday. The question: who has Sentry access, at what permission level, and are there any pending invitations from six months ago that nobody accepted?
You need this in an Excel workbook before the call.
The slow version:
- Open Sentry Settings, navigate to Members
- Read names, emails, roles, statuses
- Click into each member for team assignments
- Copy into Excel by hand across forty-seven members
- You go into the call with a half-finished workbook and spend fifteen minutes explaining what is missing.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Sentry member list and writes the full access record into the workbook.
Open the SheetXAI sidebar and type:
List all members of Sentry organization 'my-org' and write each person's name, email, role, status, and team memberships into this workbook, one row per member. Add a header row. Sort by role descending so admins appear first.
SheetXAI pulls every member with role and status and writes the full list into the workbook.
What You Get
Name, email, role, status, and team memberships. Filter on status = 'invited' and you have the list of stale pending invitations — the first cleanup finding for the access review.
What If the Data Is Not Quite Ready
When team memberships come back as slugs
List all Sentry members of 'my-org' with name, email, role, status, and team slugs in column E. Fetch display names for each unique team slug and write human-readable names in column F, comma-separated.
When security wants privileged accounts highlighted
List all Sentry members of 'my-org'. Write name, email, role, status into columns A through D. In column E, write 'privileged' if role is owner or admin, otherwise 'standard'. Sort privileged rows to the top.
When you need to cross-reference against the HR employee list
List all Sentry members of 'my-org' with email and status. Compare each email against the HR tab column A. In column C, write 'match' or 'no HR record'. Sort 'no HR record' rows to the top.
When the full audit needs a summary plus member detail plus pending invite flag
List all Sentry members of 'my-org'. Write name, email, role, status, team memberships into rows 3 and below. In rows 1 and 2, write: total count, count by role, count with status 'invited', count active. In column F, write 'PENDING — review' if status is invited and more than 30 days old.
The pattern: the access audit is one prompt. Security findings come from the same data, filtered and flagged inline.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull your Sentry member list before your next access review. The Sentry integration is included in every plan. See also how to bulk-invite new members from an Excel workbook or the Sentry in Excel overview.