The Scenario
It is the end of Q1. You are a support administrator doing the quarterly cleanup. A SQL query against your data warehouse generated a list of 200 resolved ticket IDs — cases that have been closed for more than 90 days and are cluttering the SupportBee active view. All 200 are in column A of a Google Sheet. They all need to be archived.
Your manager asked for this on Thursday. It is now Friday afternoon and you have a hard stop at 5 PM.
The bad version:
- Open SupportBee, paste the first ticket ID into search, open the ticket, find the Archive action, click it, confirm
- Paste the next ID, repeat
- You are a fast worker. At your current pace — about 3 minutes per ticket once you account for load times and the occasional SupportBee search lag — you will finish at roughly 11 PM
200 tickets. Archiving each one manually is not a workflow, it is a punishment.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that archives every ticket ID in your list through the SupportBee API without you clicking a single ticket.
Archive every ticket ID listed in column A of this sheet in SupportBee and write "archived" into column B when each one succeeds
What You Get
- Every ticket ID in column A archived in SupportBee
- "archived" written into column B as each ticket is processed — a completion log that fills in as the prompt runs
- Any row where archiving fails — invalid ID, ticket already archived, API error — gets a specific error note in column B rather than "archived"
- When the prompt finishes, column B gives you a complete audit record: 200 rows, each with its outcome
What If the Data Is Not Quite Ready
Some ticket IDs in column A are already archived
Archive each ticket ID in column A in SupportBee; if the ticket is already archived write "already archived" in column B and continue; if successful write "archived"
The sheet has a mix of ticket IDs to archive and IDs to keep — flagged in column B
Archive only the rows where column B says "archive"; write "archived" or an error into column C when done; skip all other rows
Some IDs are invalid because the SQL query pulled records from a different system
Archive each ticket ID in column A; if a ticket is not found in SupportBee write "not found" into column B and continue; do not stop the run for not-found IDs
Kill chain: deduplicate IDs, skip already-archived ones, archive remaining, log all outcomes
Remove duplicate ticket IDs from column A; for each remaining ID check whether the ticket is already archived — if yes write "already archived" in column B; if not archive it and write "archived" or an error into column B
One prompt — deduplication, status check, archiving, and logging in a single pass before your 5 PM cutoff.
Try It
Get the 7-day free trial of SheetXAI and open your resolved ticket ID list, then ask it to archive all 200 records in SupportBee before your quarterly cleanup deadline. Also worth reading: bulk ticket status updates from a sheet, and the hub overview for all SupportBee workflows.