The Scenario
You run a digital agency. Twenty clients, twenty SMTP2GO subaccounts. Every billing cycle you need to know how many emails each client sent so you can generate their invoices and reconcile against your SMTP2GO plan usage.
Last month you logged into each subaccount, noted the emails-sent count, and built the invoice table by hand in Excel. It took an hour and a half.
The bad version:
- Open SMTP2GO, navigate to Subaccounts, click into client 1.
- Note the current-cycle usage, switch back to your Excel workbook, find the right row, type the number.
- Repeat for 19 more subaccounts, watching the usage figures shift slightly between the time you opened SMTP2GO and the time you finish entering row 20 because the cycle is still active.
An hour and a half of data entry produces a table that someone could pull from an API in under a minute. The time cost is the entire problem.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your workbook and calls the SMTP2GO subaccounts endpoint, collecting usage stats for every account and writing them into the columns you specify.
Search all SMTP2GO subaccounts and pull name, email, status, and current-cycle usage into this Excel file.
What You Get
- Column A: subaccount name
- Column B: subaccount email
- Column C: account status
- Column D: emails sent in the current billing cycle
That is your invoice source data. Multiply column D by your per-email rate in column E and the billing table is done.
What If the Data Is Not Quite Ready
Some subaccounts have sent zero emails this cycle and you want to flag them
Fetch SMTP2GO subaccount usage for all accounts. Write subaccount name and emails sent into columns A and B. In column C, write "no activity" for any account with zero emails sent.
You need to match the subaccount names to client names in a lookup worksheet before building the invoice table
Fetch SMTP2GO subaccount usage for all accounts. Write subaccount name and emails sent into columns A and B. In column C, look up each subaccount name against column A of the ClientMap worksheet and write the matching client name. If no match is found, write "unmapped."
You only want subaccounts with more than 1000 emails sent this cycle
Fetch SMTP2GO subaccount usage for all accounts. Filter to accounts with more than 1000 emails sent. Write subaccount name and emails sent into columns A and B.
Full kill chain: pull, match, flag, and total in one prompt
Fetch SMTP2GO subaccount usage for all accounts. Write subaccount name and emails sent into columns A and B. Look up each name against the ClientMap worksheet and write the client name in column C. In column D, write the invoice amount by multiplying column B by the rate in column E. Flag any unmapped subaccounts in column F. At the bottom of column D, write the total invoice amount.
The billing table practically builds itself when the mapping and the arithmetic are part of the same prompt.
Try It
Get the 7-day free trial of SheetXAI and open your invoice tracking Excel workbook, then ask it to pull current-cycle email usage for all your SMTP2GO subaccounts. For the access audit side of the same account review, the spoke on listing SMTP2GO SMTP users covers who has sending permissions in each account.