What this does: paste raw call notes in a sheet and Claude writes a clean summary with next steps, logged straight to the contact in your CRM.
Time to set up: about 15 minutes once. After that your CRM notes write themselves from a quick paste.
What you need: a Make account (free tier is fine), a Claude API key, a Google Sheet, and a CRM (HubSpot here).
Skip if: you already dictate tidy CRM notes, or your calls are too sensitive to send to a model.
Want a working AI workflow in your inbox each morning? Join the free daily Beginners in AI newsletter.
A boat broker spends his days on sea trials and showings, scribbling notes on his phone between calls: who wants what, what put them off, when to follow up. Those notes rarely make it into the CRM in any usable shape, so the next time he opens a client record it is a graveyard of half-sentences.
This build turns the scribbles into records. He pastes the raw notes into a sheet, and Claude writes a clean summary with clear next steps, logged as a note on the right contact in the CRM. The messy thinking becomes a tidy history, without a second pass at the keyboard.
We wire it in Make, part of our Sales and CRM set. We log to HubSpot here, but the last step swaps for any CRM or a Google Sheet. Claude does the cleanup; the CRM keeps the record.
What does this workflow actually do?
In one line: raw notes become a clean CRM note. Make watches a sheet where you paste call notes. Claude turns the mess into a short summary with next steps, and Make logs it as a note on the contact in your CRM. Your scribbles become a record you can actually read later.
A few real cases, none of them the usual ones:
- The boat broker above, turning between-call scribbles into a real client history.
- A wedding planner logging venue-tour debriefs while they are fresh.
- A commercial real-estate broker capturing tour feedback against each listing.
- A custom-furniture maker logging design-consultation calls to each project.
Having the conversation is the work; you already do it. Writing it up in a form your future self can use is the chore that gets skipped. That cleanup is exactly what Claude is good at.
Why use Make if Claude can already read and write?
Worth asking. Claude is good at turning rough notes into a clean, structured summary. It is not built to watch a sheet, find the contact, and write a note in the right place. That is plumbing, and Make does plumbing.
Make handles the no-judgment steps: catching the pasted notes, logging the result to the CRM, running on its own. Claude handles the one step that needs language, the cleanup. Make is the filing clerk; Claude is the one who rewrites your shorthand into something readable. Splitting it keeps the records consistent.
What do you need before you start?
- A Make account. The free 1,000 operations a month covers a busy week of calls.
- A Claude API key from the console, not the chat app. See how to use Claude.
- A Google Sheet with a Notes column and a way to identify the contact (an email or name).
- A CRM that accepts a note. We use HubSpot; others work the same way, or log to a Sheet.
Two Make words. A scenario is the whole notes-to-CRM automation. A module is one box. Three boxes, one scenario.
How does the workflow work, step by step?
Three modules, left to right:
| Module | App | What it does |
|---|---|---|
| 1. Trigger | Google Sheets | Fires when you paste a row of call notes |
| 2. Brain | Claude | Writes a clean summary with next steps |
| 3. Output | HubSpot (CRM) | Logs it as a note on the contact |
Step 1: Watch your notes sheet
Create a scenario and add Google Sheets, Watch New Rows, connect your account, and point it at a sheet with a Contact (email) column and a Notes column. This trigger fires whenever you paste a new set of notes.
Step 2: Let Claude clean it up
Add a Claude module, Create a Prompt, paste your key, pick Sonnet:
Turn these raw sales-call notes into a clean CRM note.
Notes: {{Notes from Step 1}}
Give a two-sentence summary, then a short "Next steps:" list, then a
suggested follow-up date if one is implied. Keep the customer’s
facts exact. Do not invent anything that is not in the notes.Telling Claude not to invent anything keeps the record true to what was actually said on the call.
Step 3: Log it to the CRM
Add HubSpot CRM, Create a Note, map the contact from Step 1 and Claude’s cleaned text. The note attaches to the right record. To use a different CRM, swap this module; to keep it simplest, log to a Sheet instead.
How do you run it and check the result?
Click Run once after pasting a test set of notes. When I tested this, the summary and next-steps list came out clean, and the one rule that mattered was telling Claude to keep the customer facts exact and invent nothing, so the record stayed true to the call. Tune the format, then turn the scenario on so notes file themselves as you paste them.
After that, a client record stops being a wall of shorthand and becomes a readable history. The next call starts with a glance instead of a guess, which is what a CRM is supposed to give you.
What does this cost to run?
| Piece | Free tier | If you outgrow it |
|---|---|---|
| Make | 1,000 operations/month free | Core plan from about $9/month |
| Claude API | Pay per use | Cleaning up one note on Sonnet costs a fraction of a cent |
| Google Sheets | Free | Free |
| HubSpot | Free CRM tier works | Paid tiers as you grow |
Each note is three Make operations and a sliver of Claude. A full week of calls sits inside the free plan. More on tiers in our Make guide.
What can go wrong, and how do you avoid it?
- It adds facts that were not said. Tell Claude to invent nothing and keep customer facts exact, as the prompt does.
- It logs to the wrong contact. Map the contact from Step 1 carefully, ideally by email rather than name.
- Notes are too thin to summarize. Garbage in, garbage out; jot a few real details, not one word.
- Calls can be sensitive. Mind what you paste, and keep the sheet and CRM access locked down.
The same clean-then-file pattern runs many builds. See Make AI scenarios.
How do you build this in Zapier or n8n instead?
Same three jobs, different names.
| Job | Make | Zapier | n8n |
|---|---|---|---|
| Catch the notes | Watch New Rows | New Spreadsheet Row trigger | Google Sheets Trigger node |
| Clean them up | Claude module | Claude (Anthropic) action | Anthropic node |
| Log to the CRM | Create a Note | HubSpot Create Engagement | HubSpot node |
Make and Zapier are easiest to start. Zapier vs Make vs n8n compares all three.
Want the ready-made template?
The steps above build it from scratch. If you would rather skip the setup, the importable Make blueprint is yours free: subscribe to the daily newsletter and the download is waiting on the thank-you page, next to our Special Reports. Import it, connect your own accounts, and you are running in minutes.
Want it set up with you, live?
Book a 1-on-1 Live Claude AI Crash Course and we build your first automation together, screen to screen.
Want better prompts for it?
The AI Prompt Library includes note-cleanup and summary prompts you can paste into Step 2.
Never lose what was said on a call
Free daily newsletter. Built for people who want to use AI well, not chase every model.
Free forever. Unsubscribe anytime.
Frequently asked questions
Can it log to a Sheet instead of a CRM?
Yes, and that is the simplest start. Swap the last module for Add a Row, and your notes pile into a tidy log. Move to a CRM note when you are ready.
Will it change what the customer said?
Not if you keep the prompt rule to invent nothing and hold facts exact. It tidies the wording, it does not add claims.
Can I feed it a call transcript?
Yes. Paste the transcript into the Notes cell, and Claude summarizes it the same way. Long transcripts may need trimming.
Which CRMs work?
Any with a Make note or engagement action, including HubSpot, Pipedrive, and Salesforce. The Claude step is identical across them.
Is the chat app the same as the API?
Same models, different door. Make needs an API key from the console, not the chat login.
References and sources
- Creating a scenario (Make Help)
- Claude API overview (Anthropic)
- Google Sheets basics (Google)
- Claude on Make (integrations)
- CRM — Grokipedia
Last reviewed: May 2026. Make, Claude, Google, and HubSpot update their interfaces; check the official pages for exact button names.