The Scenario
The campaign codes exist. The attribution model exists. The problem is that 150 sevdesk invoices from the Q1 marketing push still have no campaign tags attached — meaning the finance team cannot filter the revenue reports by campaign without doing a manual lookup against a separate spreadsheet. The retailer's head of growth handed off the tagging list three weeks ago: invoice IDs in column A, campaign codes in column B. It hasn't been touched since.
The bad version:
- Open sevdesk, search for invoice ID from row 1, open the record, find the tag field, type the campaign code, save. Navigate back, search for the next invoice ID.
- The tag field in sevdesk is not always visible at a glance — you have to scroll to the right section of the invoice detail page. By invoice 20 you're missing it about a third of the time and having to go back.
- The invoices from the last campaign also had tags applied manually, and several got the wrong code because the person doing it was working from a printed list that was one version behind.
Campaign attribution reporting is supposed to help you understand what worked. That analysis never gets done cleanly when the tagging backlog takes an entire afternoon to clear.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside Google Sheets that reads your tagging list and applies campaign codes to sevdesk invoices directly.
For each row in my Invoice Tags sheet, add the tag in column B to the sevdesk invoice whose ID is in column A — skip rows where column B is empty
What You Get
- The campaign tag from column B applied to the corresponding sevdesk invoice for each row.
- Rows with empty column B skipped automatically — no blank tags applied.
- Any row that fails (invoice not found, duplicate tag) surfaces an error in a status column rather than stopping the run.
- All 150 invoices tagged in one operation.
What If the Data Is Not Quite Ready
Some invoices already have a tag and you don't want to overwrite them — only add where missing
For each row in my Invoice Tags sheet, check whether the sevdesk invoice in column A already has any tag — if not, add the tag from column B; if it already has a tag, write ALREADY TAGGED in column C
The campaign codes in column B need to be standardized — some are lowercase, some have spaces
Normalize column B in my Invoice Tags sheet — uppercase all values and replace spaces with hyphens — then for each row, add the cleaned campaign tag to the sevdesk invoice in column A, skipping rows where column B is empty
Tags span two campaigns with separate tabs in the sheet — Spring Campaign and Summer Campaign
Apply sevdesk invoice tags from both the Spring Campaign tab (invoice ID in column A, tag in column B) and the Summer Campaign tab (same structure) — skip any rows where column B is empty — write 'tagged' in column C on each tab for successful rows
End-to-end tagging pipeline: deduplicate invoice IDs, standardize codes, apply tags, report results
In my Invoice Tags sheet: first flag any rows with duplicate invoice IDs in column A by writing DUPLICATE in column C — then for all non-duplicate rows where column B is not empty, normalize the tag in column B (uppercase, no spaces), apply it to the sevdesk invoice in column A, and write 'tagged' in column C — write the total number of invoices successfully tagged into cell A1 when done
Run the full pipeline in one prompt so you end up with a clean, annotated result rather than guessing which rows made it through.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your invoice tagging list, then ask it to apply all the campaign codes to sevdesk in one pass. When the tags are in place, you can pull a fiscal year invoice report and filter by campaign to start the attribution analysis.