The Scenario
You are a marketing ops analyst. It is the first Monday of the new quarter and the quarterly budget review is in three days.
You need the last 30 days of eSputnik spend broken down by channel, email, SMS, Viber, and push, written into an Excel workbook so the finance team can compare actual spend against channel budget allocations.
The slow version of this week:
- You log into eSputnik and look for a billing export in the UI
- The billing page shows a summary total, not a per-channel daily breakdown
- You find an API endpoint in the docs that returns per-channel billing
- You generate a personal API token, write a curl command, get a JSON response
- You paste the JSON into a converter tool, get a CSV, open it in Excel, and realize the structure does not match the budget tracker columns
- You manually reshape it, copy it into the tracker workbook
- It is Wednesday afternoon and the finance team has been waiting since Monday.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your intent and calls eSputnik's billing API with the date range and channel breakdown you need.
Open the SheetXAI sidebar and type:
Pull the eSputnik organisation billing breakdown for May and June into my Excel 'Budget Report' sheet — one row per day per channel — and add a total row at the bottom per channel.
SheetXAI calls eSputnik, retrieves the billing data at the right granularity, writes one row per day per channel, and adds the per-channel total rows. The workbook is ready for the finance team.
What You Get
A structured billing breakdown in the workbook, ready for quarterly review:
- One row per day per channel — the granularity the finance team needs to see daily spend movement
- Columns: date, channel, messages sent, cost — the four fields that drive the reconciliation
- Per-channel total rows at the bottom — so the finance team can compare actual spend against quarterly allocation in one view
- No JSON parsing, no column remapping — SheetXAI writes directly to the workbook in the structure you described
The per-channel daily breakdown is what distinguishes this from a summary export. A total spend number for the month does not tell the finance team whether SMS was over budget while email was under. The row-level structure does.
What If the Data Is Not Quite Ready
Budget reconciliation workbooks always have existing structure that needs to be matched. SheetXAI adapts to it.
When the workbook already has budget targets per channel in column F
The finance team set quarterly targets in the tracker. You want to add actuals next to targets, not in a separate tab.
Get eSputnik billing history for the last 30 days. Sum the cost by channel and write each channel total into a new column G next to the budget values in column F. In column H, calculate the variance (actual minus budget) per channel. Flag any channel with a positive variance in column I with "OVER BUDGET."
When the quarterly review requires two months compared side by side
Your head of marketing wants April and May compared, not just the last 30 days.
Get eSputnik billing history for April 2026 and May 2026. Write April daily rows to the 'April' tab and May daily rows to the 'May' tab, both with date in A, channel in B, messages in C, cost in D. Then in the 'MoM' tab, write a channel-by-channel comparison of total spend for April versus May.
When the workbook needs a cost-per-message column for each channel
The ops team uses cost per message as the efficiency benchmark, not raw spend.
Get eSputnik billing history for the last 30 days. Write date, channel, messages sent, and cost into columns A through D. In column E, calculate cost per message for each row (cost divided by messages sent). At the bottom, add a per-channel average cost per message row.
When you want the raw data, the analysis, and a written summary for the ops email
Your head of marketing asked for the billing data and a paragraph they can paste into the ops update.
Get eSputnik billing history for the last 30 days. Write the daily breakdown by channel into the 'Billing Data' tab with date in A, channel in B, messages in C, cost in D. In cell A1 of the 'Summary' tab, write a 3-sentence paragraph covering: total spend by channel, which channel had the highest cost per message, and whether total spend exceeded 25% of the quarterly budget shown in the 'Budget Targets' tab.
The pattern: instead of pulling the data and then writing the analysis as two separate tasks, you ask for both in one prompt and have the workbook ready for the review.
Try It
Get the 7-day free trial of SheetXAI and open your budget tracker workbook, then ask it to pull eSputnik billing history directly into the workbook. The eSputnik integration is included in every SheetXAI plan. See also how to export an eSputnik segment into Excel or the eSputnik in Excel overview.