The Scenario
You are an SDR team lead. You have 60 contacts in a Google Sheet who were marked 'not_interested' in Reply.io six months ago after an outreach campaign for a product line that did not land with them. The company launched a completely different product last month, and your manager wants these contacts re-enrolled in a fresh campaign.
The problem: Reply.io will not let you re-enroll contacts who have an existing status set. You need to clear the status first. Sixty contacts, one by one, through the UI, with each one requiring a search, a click, and a save.
The bad version:
- Open Reply.io, search for the first email address
- Find the contact, click into their record
- Clear the status field, save
- Go back, search the next email
- Repeat 59 more times
- Lose your place around contact 35
- Take three hours to finish what should have been a five-minute task
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the reactivation list and clears every contact's status in Reply.io in a single pass.
Open the SheetXAI sidebar and type:
Clear the contact status for every email in column A of the ReactivationList sheet in Reply.io and write 'cleared' or the error message in column B.
SheetXAI iterates through every email in column A, calls Reply.io to clear each contact's status, and writes 'cleared' or the specific error into column B. Sixty rows. One prompt.
What You Get
A completed status clear with column B showing the outcome per row:
- 'cleared' — status successfully cleared in Reply.io
- 'not found' — email address did not match any Reply.io contact record
- Error message — for any API-level issues
Once the statuses are cleared, you can run the re-enrollment prompt immediately. The same sheet, a follow-up prompt: create contacts and enroll them in the new sequence. Two prompts, done.
What If the Data Is Not Quite Ready
Reactivation lists often need filtering before you clear statuses wholesale. SheetXAI handles it in the same prompt.
When you only want to clear contacts marked as a specific status
You want to clear 'not_interested' contacts but leave 'do_not_contact' contacts untouched.
For each email in column A of the ReactivationList sheet, fetch the current Reply.io status and write it in column B. Then clear the status only for contacts where column B is 'not_interested'. Write 'cleared' or 'skipped — do_not_contact' in column C.
When the list includes contacts who were never enrolled
Some rows in the sheet are contacts that were added to Reply.io but never enrolled in a sequence and have no status to clear.
For each email in column A of the ReactivationList sheet, check if the Reply.io contact has a status set. If yes, clear it and write 'cleared' in column B. If no status is set, write 'no status — skipped' in column B.
When you want to clear and immediately re-enroll in one pass
You do not want to do this in two separate prompts. You want the clear and the enrollment to happen in the same operation.
For each email in column A of the ReactivationList sheet, clear the Reply.io contact's current status. Then enroll the contact in the sequence named 'New Product Outreach' starting at step 1. Write the result — 'cleared and enrolled' or the error — in column B.
When the reactivation list needs deduplication first
The sheet was assembled from three different sources and some contacts appear more than once.
Deduplicate column A of the ReactivationList sheet, keeping the first occurrence of each email. Then clear the Reply.io contact status for each unique email and write 'cleared' or the error in column B.
The pattern: clearing statuses is the unlock. Once it is done in one prompt, the re-enrollment prompt runs the same way.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with a reactivation list, then ask it to clear the statuses in Reply.io. The Reply.io integration is included in every SheetXAI plan. For the next step, see how to bulk-enroll contacts in a Reply.io sequence or the Reply.io in Google Sheets overview.