The 'Revival Mission' for 6-Month-Old Contact Data
We had a task to organize a buyer contact list sitting in Google Sheets. These were contacts with absolutely no interaction for the past 6 months. We could have deleted them outright, but the thought "What if some of them could be reactivated?" led us to build a bot using Claude Code.
What the Bot Did
We fed the bot buyer information stored in Google Sheets (names, emails, last contact date, interaction history). Claude Code's assignment was straightforward.
**Bot's Decision Criteria:**
- Response within last 30 days: "Active Contact"
- Between 31 and 90 days: "Needs Attention"
- 91+ days of silence: "Needs Reactivation"
We translated this logic into code and hit the execute button.
Result: 500 Contacts Classified in 3 Minutes
Before: 500 chaotic contacts
After:
• Active contacts: 127
• Needs attention: 203
• Needs reactivation: 170
The bot also auto-generated "Recommended Actions" beside each group. The active group received "Continue regular updates", while the reactivation group got suggestions like "Send re-introduction email template".
What We Did
Once the bot finished, our work became surprisingly simple.
1. Separate each group's data into individual sheets
2. Send customized outreach emails to the 170 contacts needing reactivation
3. Send thank you messages to the active group
Using the old manual method, just the classification work would have taken 3 to 4 days.
A Small Lesson Learned
Initially, we told the bot "completely exclude contacts that are too old". But when we actually ran it, we discovered that some of those 6-month-dormant contacts responded to a single re-introduction email. We learned that "neglected data isn't data to delete, it's data to awaken".
As a non-developer, here's what I think. Claude Code isn't just a "tool for processing work faster". It's more like a "partner that helps you find hidden opportunities in your data".