The Scenario
You are an ecommerce operations lead. Last week your team ran three large batch imports — contacts, products, and orders — as part of a platform migration. Each job touched hundreds or thousands of records.
You need a Google Sheet showing each batch job's status, total item count, success count, and failure count before your Monday morning meeting with the CTO. She wants to know whether the migration data is clean before the new platform goes live.
The bad version of this weekend:
- You log into Omnisend and look for a batch job history view
- Find a jobs section but it shows limited details and has no export option
- Open each batch job one at a time, read the numbers, copy them manually to the sheet
- Get three jobs done, realize you also need to check the sub-job errors for each one
- Walk into Monday's meeting with a half-filled spreadsheet and "I still need to check the error details."
The fast version is one prompt and the audit table is in the sheet before Sunday night.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the Omnisend batch jobs API and writes the status data directly into the sheet, so you do not have to open job records one at a time.
Open the SheetXAI sidebar and type:
List all Omnisend batch jobs and write batch ID, type, status, total item count, completed count, and error count into this sheet for all batches from the past 7 days.
SheetXAI calls the Omnisend batch jobs endpoint, extracts the fields you named, and writes the audit table into the sheet. All three batch jobs, one row each.
What You Get
An audit table with one row per batch job from the past week:
- Batch ID — for reference if you need to dig into specific job details
- Type — contacts, products, or orders so you can see which import had issues
- Status — completed, processing, or failed
- Total item count — how many records were in the job
- Completed count — how many succeeded
- Error count — how many failed
The error count is the number the CTO is asking about. If it is zero across all three jobs, the migration is clean. If it is not, you know which job type to investigate.
For any job with errors, ask SheetXAI to pull the error details and write them into a separate tab with the specific record and the reason it failed.
What If the Data Is Not Quite Ready
Batch job audits get complicated when there are many jobs or partial failures. SheetXAI handles the nuance.
When you need error details for failed items
The high-level counts show failures but you need to know which specific records failed and why.
For each batch job in this sheet where the error count is greater than zero, fetch the error details from Omnisend and write them into a new tab called "Errors" with batch ID, item reference, and error message.
When you need to look up specific batch job IDs
You know the batch IDs from when you ran the imports last week. You want the current status for each.
Fetch details for each batch ID listed in column A of this sheet and write job status, total items, success count, and failed count into columns B through E.
When you want to calculate the success rate for each job
The CTO wants a percentage, not just raw counts.
After writing the batch job table, add a column G with success rate calculated as (completed count / total item count) × 100, formatted as a percentage. Highlight any row where the success rate is below 95 percent.
When you want the full audit including error detail in one shot
You want the job summary table and the error detail for every failed record, all in one pass.
List all Omnisend batch jobs from the past 7 days and write the summary (batch ID, type, status, total, completed, errors, success rate) into the Audit Summary tab. For every job with errors, fetch the error detail records from Omnisend and write them into a tab named after the batch type (Contacts Errors, Products Errors, Orders Errors). Write the total cross-job error count into cell H1 of the Audit Summary tab.
The pattern: summary and detail in one pass. You walk into Monday's meeting with the full picture.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to pull your Omnisend batch job history for an audit. The Omnisend integration is included in every SheetXAI plan. For related workflows, see how to backfill historical orders into Omnisend or the Omnisend in Google Sheets overview.