The Scenario
The reorg announcement went out on Wednesday. By Friday, you need to know who has access to what.
You're the operations director. The agency is restructuring two departments, which means Magnetic roles are going to need to be reassigned, some accounts deactivated, and at least a few users added. Before any of that can happen, leadership needs to see the current state: every user, their role, their email.
You don't have a current list. The last time anyone exported the user list from Magnetic was eight months ago, and three people have joined since then. Two more left. The spreadsheet sitting in the shared drive is worse than useless.
The bad version:
- Open Magnetic's user management screen and start writing down names, emails, and roles into the sheet
- Get interrupted by a Slack message from the CEO about the restructure, lose your place, start over from the top
- Finish 27 users, realize you can't tell which role maps to which permission level, and schedule a meeting to ask the account that nobody wants to have right now
Everyone is waiting on this list. The restructure can't move until you have it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that runs inside your Google Sheet. It reads the sheet and talks to Magnetic through its built-in integration — it can pull the full user list, map the fields you need, and write everything into the sheet in one pass.
Open the SheetXAI sidebar in your audit sheet and ask:
List all users in Magnetic and write to sheet 'Team Roster' with columns: user_id, full_name, email, role
What You Get
- Every Magnetic user written as a row in 'Team Roster' with their user ID, full name, email address, and role
- No users missed — the pull goes to the API, not the pagination-limited UI view
- The list ready to send to leadership as the source of truth for the restructure
What If the Data Is Not Quite Ready
You need to cross-reference against an HR system export
List all Magnetic users and write to sheet 'Team Roster' with user_id, full_name, email, and role — then compare email column against column A of sheet 'HR Export', flag any Magnetic users not in HR as "OFFBOARDING?" in column E, and any HR employees not in Magnetic as "MISSING?" in column F
Leadership wants to see the list grouped by role
List all Magnetic users and write to sheet 'Team Roster' with user_id, full_name, email, and role — sort rows by role alphabetically, then by full_name within each role
You also need the date each user was created to spot recently added accounts
List all Magnetic users and write to sheet 'User Audit' with user_id, full_name, email, role, and created_date — highlight any created_date within the last 90 days in column F with the label "RECENT"
Full access audit — pull, cross-reference, flag, summarize
List all Magnetic users, write to sheet 'User Audit' with user_id, full_name, email, role, created_date — compare email against sheet 'HR Export' column A, flag discrepancies in column F, then write a summary in cell A1: total Magnetic users, count by role, count flagged
The audit and the data pull happen in the same prompt. You're not exporting first and then manually matching — the whole thing runs together.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to pull your complete Magnetic user list into an auditable roster before the next restructure decision needs to be made. Related: exporting client companies from Magnetic, or back to the Magnetic integration overview.