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.
The list goes into a Google Sheet so the team can flag accounts that should be removed. You have never exported this list before.
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 start copying names and emails by hand into the sheet
- You get to user thirty and realize you cannot see the role column without clicking into each user's profile
- You spend an hour clicking through each profile to get the role
- You finish with a sheet that has name and email but the roles are mostly guesses
- 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 spreadsheet that calls Contentful's space membership API and writes the full user list into the sheet.
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 sheet. Use the space ID in cell A1.
SheetXAI calls the Contentful API, pulls all members and their roles, and writes every row into the sheet. The full list, not just the first page.
What You Get
A complete space membership export in the sheet:
- Column A — user display name
- Column B — email address
- Column C — assigned role (e.g., Author, Editor, Admin)
- Column D — admin flag (true/false)
All members included, not just the ones visible in the first page of the UI.
Once the data is in the sheet, your security team can sort by admin flag to find all admins, filter to a specific role to see who has Editor access, or add a column E for "Action Needed" where reviewers flag accounts for removal.
What If the Data Is Not Quite Ready
Access review sheets need to be clean before they go to the security team.
When you need members across multiple spaces
Your organization has three Contentful spaces—production, staging, and content-sandbox—and the review covers all three.
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 sheet with an added column showing which space each row came from.
When you need to flag accounts that have not logged in recently
The security policy requires flagging 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 sheet. In a new column, 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
HR sends a weekly list of employees who have left the company. You want to know which of those have active Contentful access.
Pull all space memberships for this Contentful space and write name, email, and role to a tab called CMS Members. Then compare the email column against the emails in the Offboarding tab. For any email that appears in both lists, write the row to a tab called Access to Remove.
When you need the audit to cover both space memberships and organization memberships in one pass
The security team wants the full picture: space-level access and organization-level admin status.
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 sheet, 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 sheet 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 Google Sheets overview.