Skip to content
UsecaseBoard
← All use cases
The Paperless AgentSales and Marketing

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.

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.

Save ideas in this browser. Upvotes count across the board.

Prompt excerpt

No prompt excerpt was provided by the source.

Sponsored

CodeBuddy

Tencent Cloud AI coding assistant for IDE and CLI.

Try CodeBuddy ↗
Explore all →