The Scenario
You are a Contentful space admin. Quarterly access review is due Friday. Your security team needs a list of every user with access to the production Contentful space—name, email, role, and whether they have admin rights—in an Excel workbook.
The bad version of this week:
- You open Contentful, navigate to Settings > Space membership
- The interface shows users in a paginated list with no export button
- You copy names and emails by hand into the workbook
- You get to user thirty and realize you cannot see roles without clicking into each profile
- You spend an hour clicking through each profile
- You submit an incomplete access review and the security audit flags it.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that calls Contentful's space membership API and writes the full user list into the workbook.
Open the SheetXAI sidebar and type:
Get all space memberships for the Contentful space and write the user name, email, role, and admin status into this workbook. Use the space ID in cell A1.
SheetXAI calls the Contentful API, pulls all members and their roles, and writes every row into the workbook. The full list, not just the first page.
What You Get
A complete space membership export in the workbook:
- Column A — user display name
- Column B — email address
- Column C — assigned role (Author, Editor, Admin)
- Column D — admin flag (true/false)
All members included. Sort by admin flag to find all admins, filter to a specific role, or add a column E for "Action Needed."
What If the Data Is Not Quite Ready
Access review workbooks need to be clean before they go to the security team.
When you need members across multiple spaces
Get all space memberships for the production space ID in cell A1, the staging space ID in cell B1, and the content-sandbox space ID in cell C1. Write all members to a single workbook tab with an added column showing which space each row came from.
When you need to flag accounts inactive for more than 90 days
Get all space memberships for this Contentful space and write the user name, email, role, and last-active date to this workbook. Mark any account where the last-active date is more than 90 days ago as "Inactive."
When you need to cross-reference against an HR offboarding list
Pull all space memberships for this Contentful space and write name, email, and role to a tab called CMS Members. Compare the email column against the emails in the Offboarding tab. For any email that appears in both, write the row to a tab called Access to Remove.
When you need the audit to cover both space and organization memberships in one pass
Get all space memberships for this Contentful space with user name, email, and role. Also get the organization membership list and note which users have organization admin rights. Merge the two into one tab, with a column for space role and a column for org admin status. Flag anyone who is an org admin but not listed in the space membership.
The pattern: you describe the scope of the audit and SheetXAI does the API calls, the merges, and the flagging in one pass.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook with your Contentful space ID in cell A1, then ask it to pull the full membership list. The Contentful integration is included in every SheetXAI plan. For related workflows, see how to export your content type schema or the Contentful in Excel overview.