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 a Google Sheet row by hand, one page at a time.
- Submit the sheet, 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 Google Sheet. It connects to the SMTP2GO SMTP users endpoint and writes every user record into your sheet directly — no pagination to manage, no manual copying.
List all SMTP users from my SMTP2GO account and write username, status (enabled/disabled), and sender restrictions into columns A, B, and C.
What You Get
- Column A: SMTP username
- Column B: enabled or disabled status
- Column C: sender restriction (allowed sender domains or "unrestricted")
That is your complete access inventory. Sort by column B to surface all enabled accounts, filter column C to find unrestricted senders, and submit it to the auditor.
What If the Data Is Not Quite Ready
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.
The auditor wants only enabled accounts in the report
List all SMTP2GO SMTP users, filter to enabled accounts only, and write username and sender restrictions into columns A and B.
You need to join the SMTP user list to an existing employee directory in a separate tab
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 tab 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 tab 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 Google Sheet 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.