The Scenario
It's Tuesday afternoon. You have 12 email campaign drafts stored as HTML snippets in column B of an Excel workbook — one per row, labeled by campaign name in column A. The send schedule kicks off Thursday morning. Before anything leaves your ESP, every draft needs a deliverability score and a spam flag from Campaign Cleaner.
You know how to do this manually. You've done it before.
The bad version:
- Open the workbook, copy the HTML from B2, switch to Campaign Cleaner, create a new submission, paste the content, submit, wait for analysis, copy the campaign ID, switch back to the workbook, type it into C2.
- Repeat for B3. Then B4. Then B5. Lose track of which browser tab is which somewhere around row 7.
- Come back the next day to fetch scores, discover two submissions are still "processing," re-check manually, eventually get all 12 scores across 40 minutes of tab-switching.
The send window is 36 hours out. Twelve round trips is twelve opportunities for a transposed row, a pasted score in the wrong cell, or a submission that silently failed because you hit the character limit on a draft with a lot of preheader text.
That's not a workflow problem you have space to troubleshoot right now.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, understands the structure, and talks to Campaign Cleaner directly — submitting each campaign and writing the returned IDs back to the right cells without you touching the UI.
Here's the prompt for this task:
Submit each HTML snippet in column B (rows 2–13) to Campaign Cleaner as a separate campaign using the campaign name from column A as the label, and write the returned campaign ID to column C
What You Get
- Column C fills in with Campaign Cleaner campaign IDs, one per row, matching the submission order.
- Each submission uses the campaign name from column A as the label, so the IDs are identifiable when you come back to fetch scores.
- Any rows where column B is empty are skipped automatically.
- The agent surfaces any submission errors inline — a row that returned a 422 gets a note in column C rather than silently missing.
What If the Data Is Not Quite Ready
Some HTML snippets have inline styles stripped
If your drafts came through a content pipeline that removed inline styles, Campaign Cleaner will still accept them but the deliverability grade may not reflect your actual send format.
Before submitting, check column B (rows 2–13) for HTML snippets that are missing inline style attributes on the body or table elements — flag those rows in column F with "missing styles" and skip them in the Campaign Cleaner submission
Campaign names in column A have inconsistent formatting
Campaign Cleaner labels are how you'll identify submissions when fetching scores later. If column A has mixed casing, trailing spaces, or duplicated names, the audit becomes confusing fast.
Normalize campaign names in column A (rows 2–13): trim whitespace, convert to title case, and append the row number to any duplicates — then submit the HTML in column B to Campaign Cleaner using the cleaned names as labels and write IDs to column C
The HTML column has entries from multiple worksheets that need to be merged first
If your drafts live across a "Q2 Campaigns" worksheet and an "Evergreen" worksheet and you need to submit from both, pulling them together manually before submitting adds another step.
Combine the HTML snippets from column B on the "Q2 Campaigns" sheet (rows 2–8) and column B on the "Evergreen" sheet (rows 2–6) into a single submission batch — use column A from each sheet as the campaign label — submit to Campaign Cleaner and write all returned IDs to column C on the "Audit" sheet
Run the full batch: normalize, check credits, submit, capture IDs
Check my Campaign Cleaner credit balance — if it covers all 13 rows in column B (rows 2–13), normalize the campaign names in column A (trim whitespace, title case), submit each HTML snippet to Campaign Cleaner with the cleaned name as label, write returned IDs to column C, and write any submission errors to column D
Running cleanup and submission in one prompt means the IDs in column C are already matched to clean, readable names before you come back to fetch scores.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook with your campaign HTML in a column, then ask SheetXAI to submit the batch to Campaign Cleaner and capture the IDs. For the next step, see Fetch analysis results and write spam scores back or return to the Campaign Cleaner integration overview.