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. 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 Google Sheet, 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 Google Sheet. It reads your sheet and calls the SMTP2GO subaccounts endpoint, collecting usage stats for every account and writing them into the columns you specify.
Fetch SMTP2GO usage statistics for all subaccounts and write subaccount name and total emails sent into columns A and B of this sheet.
What You Get
- Column A: subaccount name
- Column B: emails sent in the current billing cycle
That is your invoice source data. Multiply column B by your per-email rate in column C and the billing table is done.
What If the Data Is Not Quite Ready
You need more fields — account email, status, and plan — for your internal records
Fetch all SMTP2GO subaccounts and write subaccount name, email, status, and current-cycle emails sent into columns A through D.
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 tab 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 tab and write the matching client name. If no match is found, write "unmapped."
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 tab 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 Google Sheet, 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.