The Scenario
You are a CRM specialist. Your marketing director ran a segment in Benchmark Email last week, pulled 500 high-value contacts based on engagement score, and dropped their contact IDs into a Google Sheet. The goal: move all 500 into a new VIP list before the holiday campaign goes out on Thursday.
It is Tuesday morning. You have two days.
The slow version:
- Open Benchmark Email
- Search for contact ID 1 in the UI
- Find the contact, click "Copy to list," select the VIP list, confirm
- Back out, search for contact ID 2
- Repeat 499 more times
- You are on row 47 and it is already noon.
There is a bulk import option in Benchmark Email, but it wants a CSV of email addresses, not contact IDs. And the sheet you have is IDs.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the contact IDs and runs the copy operation in bulk, so you never have to touch the Benchmark Email contact UI.
Open the SheetXAI sidebar and type:
Copy all contact IDs in column A of my sheet from Benchmark Email list ID 11223344 to list ID 55667788 — process all 500 rows and write "copied" or "failed" to column B for each row.
SheetXAI iterates through every contact ID in column A, calls the Benchmark Email API for each one, copies the contact to the VIP list, and logs the result in column B. You watch the status column fill up. Done before lunch.
What You Get
A completed batch operation with a per-row audit trail:
- Column B — "copied" or "failed" for each contact ID
- Failure rows visible — any contact ID that did not exist or was already in the destination list is flagged, not silently dropped
- No duplicates in the destination list — Benchmark Email's API handles the deduplication if a contact is already in the VIP list
The audit trail in column B is what makes this repeatable. Next week when the marketing director asks whether all 500 made it, you filter column B for "failed" and you have the answer in three seconds.
What If the Data Is Not Quite Ready
Contact ID sheets from CRM exports are rarely clean.
When some contact IDs in column A are formatted as text with leading zeros
A SQL export preserved the leading zeros. The Benchmark Email API wants plain integers.
Before processing, convert all values in column A to plain integers by stripping any leading zeros. Then copy each contact ID from list ID 11223344 to list ID 55667788 and write the result to column B.
When the source and destination list IDs vary by row
You are moving contacts across five different source lists into three destination lists, and the mapping is in columns B and C.
For each row in my sheet, copy the contact ID in column A from the Benchmark Email list ID in column B to the list ID in column C. Write "copied" or "failed" to column D. Process all rows.
When you only want to copy contacts who are currently active
The segment pulled all 500 contact IDs but some may have since unsubscribed. You do not want to bring bounces or unsubscribes into the VIP list.
For each contact ID in column A, check the contact status in Benchmark Email before copying. Only copy contacts whose status is "active" from list ID 11223344 to list ID 55667788. Write the contact status and result to columns B and C respectively.
When you want to move contacts rather than copy them
The contacts should leave the source list after arriving in the destination, not exist in both.
For each contact ID in column A, copy the contact from Benchmark Email list ID 11223344 to list ID 55667788, then remove them from the source list. Write "moved," "copy-failed," or "removal-failed" to column B for each row. Process all 500 rows.
The pattern: describe what success looks like per row, and let SheetXAI handle the API calls, branching logic, and status logging in one pass.
Try It
Get the 7-day free trial of SheetXAI and open a sheet with Benchmark Email contact IDs in column A, then ask SheetXAI to copy them to a destination list. The Benchmark Email integration is included in every SheetXAI plan. See also how to create a segment from a sheet of contact IDs or the Benchmark Email in Google Sheets overview.