You can build a CRM with AI using the spreadsheets and diaries your sales team already keeps, and I did exactly that for a field sales team this week.
We built this in Claude, the AI assistant we use most day to day. We’ll set you up with whichever AI tool suits your business.
How to Build a CRM With AI From What You Already Have
Most small sales teams don’t need a new system. They need the three they’ve already got to talk to each other.
Ours had a pipeline tracker in Excel, a weekly activity sheet per rep and four Outlook diaries. Every meeting was recorded somewhere. Nobody could see them in one place, and follow-ups lived in people’s heads.
So I asked Claude to read all three and build one page from them. The first load pulled in 41 customer meetings. For each one it records:
- The business, the person and their job title
- Address, phone and email
- Sector, and whether they’re a new or existing customer
- Meeting length, the objective and the outcome
- The pipeline value and stage, where there is one
It also shows the meetings on a map. You pick a centre, either head office or a rep’s patch, and drag a radius from 10 to 250 miles. Seeing who’s travelling where tells you more than any activity report.
If your sales activity is spread across Excel files and Outlook like this, we can map out what a first version would look like on a 30-minute call. It’s usually quicker than people expect.
Build the Follow-Up In, Not On Top
A meeting without a follow-up is a nice coffee. I wanted the CRM to nag, politely.
Every meeting gets two dates. The follow-up email is due by close of business on the Friday of the meeting week. The chaser is due the Friday after. Claude sends each rep a calendar invite for both, so the reminder sits in the diary they already live in.
Each meeting also carries a short list of prompts the rep ticks off:
- Add or update the pipeline tracker
- Connect with the contact on LinkedIn
- Ask them to follow our company page
- Ask for a review (existing customers only)
That last rule matters. Asking a new prospect to rate you after one meeting is a quick way to stay a prospect.
Keep the AI CRM One-Way
This was the first real decision, and I’d make it the same way again.
The obvious question was whether a rep could change a pipeline value in the CRM and have it flow back into Excel. It could be built. I said no.
Excel and Outlook stay the master copy. Claude refreshes the CRM every weekday morning. If a number’s wrong, it gets fixed in the tracker, and the next morning’s refresh picks it up. One source of truth beats two that argue.
The refresh also showed me problems I hadn’t spotted. Deals had weighted values against a £0 total. One rep’s activity tab was weeks out of date. Another’s sheet had the wrong month in the heading. None of it was hidden, it just wasn’t anyone’s job to look.
What Tripped Us Up
Most of the time didn’t go on building. It went on access.
Claude could read two of the four diaries straight away. The other two needed sharing at the “Can view all details” calendar permission in Outlook. Seeing a colleague’s diary yourself isn’t the same as an AI tool being allowed to read it.
Claude also can’t write into someone else’s diary, even with editor access. The workaround is invites from mine, which land in theirs automatically.
When I shared the page, the reps couldn’t save anything at first. The usual causes are a public link being switched on, or someone opening it while signed in with the wrong account. Check both before you blame the tool.
Customer contact details need care too. If reps will email people from it, the ICO’s guide to business-to-business marketing rules is short and worth reading.
Where It Goes Next
Activity is half the picture. The other half is sales, the same numbers behind a weekly sales report.
The next step is a daily export of invoiced sales and margin by customer from our reporting tool into SharePoint. Power Automate’s Power BI connector can run that query on a schedule, and the CRM reads the file each morning.
That gives two views. A management dashboard shows each rep’s sales, margin and meetings against their monthly target. Each rep gets a private page with only their own customers. League tables are for managers, not the shared screen.
Andrew’s Final Thoughts
An AI CRM won’t replace Salesforce for a 50-person sales floor. For a team of four with good spreadsheets and no time, it’s the fastest way I’ve found to see who met whom, what was promised and what’s overdue. Start with one-way data and the follow-up dates. Not sure your data is ready? The free AI Readiness Check takes a few minutes. If you’d like it built for you, have a look at our fixed-price setups.
Build a CRM With AI FAQs
Can you build a CRM with AI without a developer?
Yes. Claude can read your spreadsheets, diaries and email through connectors and build a working CRM page. You need to know what fields you want and where the data lives. A developer helps for heavy customisation, but a small team can get started without one.
Is a homemade AI CRM a replacement for Salesforce or HubSpot?
Not for large teams. It suits smaller teams who already keep tidy sheets and want one view of meetings, follow-ups and pipeline. If you need marketing automation, complex permissions or hundreds of users, a dedicated CRM is still the better choice.
Should an AI-built CRM sync both ways with Excel?
I’d start one-way. Keep the spreadsheet as the master and update the CRM from it each day. Two-way sync means two places a number can change, and you’ll spend time working out which one is right. Add write-back later, if the team actually needs it.
What data does a small sales team CRM need?
The business, contact name and job title, address, phone, email, sector, customer type, meeting objective, outcome and pipeline value. Add follow-up dates and a few prompts, such as updating the pipeline or requesting a review, and you’ve covered most of what matters.
How do I get sales reps to actually use the CRM?
Make it come to them. Follow-up reminders go into their own diary, the CRM fills itself from sheets they already complete, and they only tick boxes or add a missed meeting. For more ideas on getting a team using AI, see our workshops.
If you would rather have a simple client tracker built for you, see our fixed-price Client Tracker Setup.
Growing pains like this are normal in a business that has grown quickly, and they’re fixable. Take the free Growing Pains Check to see where your business stands in three minutes, or book a free call about a Growing Pains Diagnostic: half a day with you and your business, then a written 90-day plan with the three changes that matter most.
Leave a Reply