The Scenario
A security review flagged your email infrastructure. Specifically, the auditor wants a list of every account with sending access to your SMTP2GO instance — username, enabled or disabled status, and any sender domain restrictions — submitted in a spreadsheet by end of week.
You are the IT manager. You did not build the SMTP2GO account. You inherited it two years ago from someone who left. You have a rough idea of how many SMTP users there are. You do not have a clean list anywhere.
The bad version:
- Log into SMTP2GO and navigate to SMTP Users.
- Note that the UI shows 20 users across three pages, with no export button.
- Copy each username, status, and restriction field into an Excel workbook row by hand, one page at a time.
- Submit the workbook, then realize you missed the users on page two because the pagination reset when you navigated away.
The auditor does not want an approximate list. The auditor wants the actual list.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to the SMTP2GO SMTP users endpoint and writes every user record into your workbook directly — no pagination to manage, no manual copying.
Fetch all SMTP2GO SMTP user accounts and put their usernames and enabled status into this Excel sheet.
What You Get
- Column A: SMTP username
- Column B: enabled or disabled status
That is your complete access inventory. Sort by column B to surface all enabled accounts and submit it to the auditor.
What If the Data Is Not Quite Ready
You need sender restrictions in a third column
List all SMTP2GO SMTP users and write username, status, and sender restrictions into columns A through C.
You need to flag any unrestricted accounts for the auditor
List all SMTP2GO SMTP users and write username, status, and sender restrictions into columns A through C. In column D, write "review required" for any user with no sender domain restriction.
You need to join the SMTP user list to an existing employee directory in a separate worksheet
List all SMTP2GO SMTP users into columns A through C with username, status, and sender restrictions. In column D, look up each username against the employee directory in the Directory worksheet column A, and write the matching employee name if found, or "no match" if not.
Full kill chain: pull, flag, join, and summarize in one prompt
List all SMTP2GO SMTP users. Write username, status, and sender restrictions into columns A through C. In column D, write "review required" for any enabled user with no sender restriction. Look up each username against column A of the Directory worksheet and write the employee name in column E, or "no match" if not found. At the bottom of column D, write a count of accounts flagged for review.
Security audits go faster when the flagging and the directory join happen in the same operation rather than across three separate steps.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook designated for your access audit, then ask it to pull your complete SMTP2GO SMTP user list. For the billing side of the same infrastructure review, see the spoke on exporting subaccount usage statistics.