Build a contact follow-up dashboard from a local spreadsheet
At a glance
A real estate marketer used Claude to build and test a spreadsheet-based personal CRM with follow-up cadences. This workflow is listed under Sales and Marketing, Contacts, Productivity.
- Agents / tools
- Claude, Microsoft Excel, Gmail, iMessage
SourceBuilding a tool for these workflows? See weekly rates.
What they did
1) Connect Claude to a folder on a Mac and describe an Excel workbook with Contacts, Companies, Interactions, Followups and a hidden allowed-values tab. Write down field formats, duplicate rules and the updates required when a record changes. Give each contact a desired contact frequency and a last-contact date. 2) Ask Claude to scan email and messages for people to add. Store a Gmail thread ID, calendar event ID or a text's date-and-phone key with each interaction; check the source ID before writing to skip duplicates. For a new interaction, find the contact, check history, write the row, update last contact, recalculate the next due date and stamp the record. 3) Ask Claude for a browser dashboard that reads the workbook, sorts overdue contacts and opens their interaction histories.
How it went
The author's test contained 35 contacts and 521 interactions. Reading and processing email or texts took over a minute, sometimes close to two; writing one update took 30 to 45 seconds.
Worth knowing
The author stopped using it for live logging because of the wait, though batch work was more practical. The local spreadsheet required that Mac to be online and did not provide phone access.