The Scenario
Your team lead sent a message at 8am: "Security review in two weeks — we need a list of every SMTP credential in MailerSend before Friday."
You are a DevOps engineer at a company that runs 4 sending domains through MailerSend. Over 18 months, multiple engineers have created SMTP users for local dev, for a staging environment, for a third-party integration that was deprecated last year. Nobody cleaned up after themselves. Before Friday, you need a complete list of every SMTP user across every domain — username, creation date, and domain association — so the security team can identify stale credentials.
The bad version:
- Open MailerSend, navigate to the first domain, go to SMTP Users, note the usernames and creation dates into a workbook, click back.
- Repeat for each of the remaining 3 domains, discovering that domain 3 has 6 SMTP users — more than any of the others — and two of them have identical usernames with slightly different creation dates.
- Build a consolidated workbook from your notes and immediately start second-guessing whether you got every user from domain 2 or accidentally skipped the second page.
Four domains. Approximately 15 SMTP users total. More time than this should take.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to MailerSend and can pull the complete SMTP user list across all domains into the workbook in one pass, with no UI navigation required.
Export every MailerSend SMTP user into this worksheet — include domain name, user ID, username, and the date each credential was created
What You Get
- One row per SMTP user across all domains
- Domain name, user ID, and username in the first three columns
- Creation date formatted as a readable date string
- The full list across all domains without navigating into any individual domain settings page
What If the Data Is Not Quite Ready
You want a simpler inventory without user ID
List all SMTP users in my MailerSend account in this worksheet with their associated domain, username, and creation date in columns A through C
You want to flag users created more than 12 months ago
Pull all MailerSend SMTP users with domain, username, and creation date into columns A through C, then in column D write REVIEW for any user where the creation date in column C is more than 365 days before today
You want to identify duplicate usernames across domains
List all MailerSend SMTP users with domain, username, and creation date in columns A through C, then in column D write DUPLICATE USERNAME for any row where the username in column B appears more than once in that column
Full kill chain: pull SMTP users, flag stale and duplicate credentials, and summarize
List all MailerSend SMTP users with domain, username, and creation date in columns A through C, flag in column D any user that was created more than 365 days ago or has a username that appears more than once in column B, count the flagged rows and write the total in cell F1 with the label Credentials to Review, and copy the flagged usernames into column F starting at F2
The credential pull and the risk flagging are a single ask — no second pass needed.
Try It
Open the Excel workbook you are using for the security credential review, then Get the 7-day free trial of SheetXAI and ask it to pull your full MailerSend SMTP user inventory. For a complete access audit, you can pair this with pulling API tokens and scopes or webhook configurations from the same workbook.