The free monday.com Sales CRM template for SME service businesses
Most small service businesses run their sales pipeline on a spreadsheet, a notebook, or pure memory. This is the free, done-for-you monday.com Sales CRM template we use to fix that — copy it column-for-column and you will have a working pipeline in under 45 minutes.
The problem: your pipeline lives in your head
If you run a growing service business, the pattern is familiar. Deals are tracked across a spreadsheet, your inbox, a couple of sticky notes, and whatever the person who owns the relationship happens to remember. It works — until it doesn't.
The cracks show up in predictable ways:
- Follow-ups slip because nobody set a reminder, and warm prospects go cold.
- Nobody can answer "what's our realistic revenue forecast for the next 30 days?" without an hour of manual maths.
- Two people chase the same lead, or worse, everyone assumes someone else is handling it.
- Your weekly sales review takes two hours because the data is scattered and out of date.
None of this is a discipline problem. It is a system problem — and you can solve it in an afternoon.
The solution: a complete CRM template, free to copy
Below is the entire build. It is not a teaser or a gated download — it is the full board structure, the exact column types, copy-paste dropdown values, four ready-made views, the automations that do the chasing for you, and the integrations that connect it to the tools you already use. Copy it as-is and you will get:
- A sales pipeline board that shows exactly where every deal stands.
- Automated follow-ups so nothing falls through the cracks.
- Instant alerts when a deal moves to "Won".
- Dashboards that show a weighted revenue forecast at a glance.
- Roughly 3–5 hours per week back, per team, on admin.
If you would rather describe your sales process and have a tailored structure generated for you, our free monday.com Build Generator does exactly that. And if you already have a CRM board that has grown messy, the free Health Check Generator will tell you what to fix first. Both are covered again at the end — for now, here is the template.
Part 1: Board structure
Your entire sales operation lives on one board called "Sales Pipeline". Think of it like a spreadsheet, but smarter — the automations handle the boring parts.
Column configuration (copy-paste ready)
Create these columns in this order:
| Column | Type | Configuration | Why it matters |
|---|---|---|---|
| Deal Name | Text | Required | Name of the prospect or project, e.g. "Acme Corp Website Redesign". |
| Company | Text | Recommended | Client company name. Makes filtering and reporting easier. |
| Contact Name | Text | Optional | Primary point of contact at the company. |
| Contact Email | Optional | Use the native Email type so it links to email integrations. | |
| Contact Phone | Phone | Optional | Use monday.com's native Phone type. |
| Status | Status | See values below | Where the deal sits in your pipeline. Controls everything. |
| Deal Value (£) | Numbers | Currency, GBP £ | Total deal size. Must be a Numbers column, not Text, or formulas break. |
| Close Date | Date | Target close | When you expect to win it. Drives your forecast. |
| Probability (%) | Numbers | 0–100 | Confidence level. 100% = signed, 50% = mid-negotiation. |
| Weighted Value (£) | Formula | {Deal Value} * {Probability} / 100 | Deal Value × Probability — your real revenue forecast. |
| Owner | Person | One person | Who owns the deal. Critical for accountability. |
| Industry | Status | See values below | Category for analysis: which industries bring the most revenue. |
| Next Follow-Up | Date | Recommended | When you need to contact them next. Automations update this. |
| Source | Status | See values below | Where the lead came from. Tracks your best channels. |
| Notes | Long Text | Large box | Conversations, objections, and a timeline of communication. |
Status values
Copy these exactly into the Status column dropdown:
Lead
Contacted
Qualified
Proposal Sent
Negotiating
Won
Lost
Stalled
- Lead — new prospect, no contact yet.
- Contacted — you've reached out, awaiting a response.
- Qualified — real fit, budget exists, timeline is clear.
- Proposal Sent — quote or proposal delivered.
- Negotiating — they like it, you're discussing terms.
- Won — closed and signed.
- Lost — didn't happen; record why in Notes.
- Stalled — stuck, waiting on the client (auto-flag if over the threshold you set).
Industry values
Professional Services
SaaS
E-commerce
Manufacturing
Retail
Healthcare
Financial Services
Hospitality
Other
Adjust these to match the industries you actually sell to.
Source values
Referral
Inbound (Website)
Cold Outreach
LinkedIn
Previous Client
Event / Networking
Partnership
Organic Search
Other
This is how you learn that referrals convert at 40% while cold outreach converts at 8% — so you know where to spend your time.
Part 2: Views to create
Once your columns are set up, create these four views. Each takes 3–5 minutes.
View 1 — "Sales Pipeline" (your daily view)
Every active deal, grouped by stage and colour-coded. Add a Board view, Group By → Status, Color By → Status, then Filter → Status is not Lost. Drag cards left to right as deals progress. A simple colour convention: Lead = grey, Contacted = blue, Qualified = yellow, Proposal Sent = orange, Negotiating = purple, Won = green, Lost = red (filtered out here).
View 2 — "Revenue Forecast" (weekly check-in)
Pipeline sorted by close date with your realistic, weighted forecast. Add a Board view, Sort By → Close Date (earliest first), Group By → Status, Filter → Status is not Lost, Stalled. Show Deal Name, Deal Value, Probability, Weighted Value, and Close Date in the card preview. Every Friday, sum the Weighted Value column for a realistic 30-day forecast.
View 3 — "Team Performance" (who's closing?)
Cards grouped by Owner so you see each person's pipeline. Add a Board view, Group By → Owner, Sort By → Probability (highest first), Filter → Status is Qualified, Proposal Sent, Negotiating, Won. Use it to run weekly 1:1s based on real activity.
View 4 — "Follow-Ups Due" (don't drop balls)
Sorted by Next Follow-Up so you see what needs attention today. Add a Board view, Sort By → Next Follow-Up (earliest first), Filter → Next Follow-Up is not empty AND Status is not Won, Lost. Open this first thing Monday morning — your task list is built for you.
Part 3: Automations
These run on their own. Set them up once and forget them — they save 5–10 hours a week of manual admin.
Automation 1 — auto-update follow-up on status change
When a deal moves stage, automatically set the next follow-up date. In Automations → Create Automation, set the trigger "When Status changes to Qualified" and the action "Set Next Follow-Up to today + 3 days". Repeat for: Contacted → +2 days, Proposal Sent → +5 days, Negotiating → +3 days. You never forget to schedule a follow-up again.
Automation 2 — Slack notification when a deal is won
The moment a deal is marked "Won", post a celebration to your sales channel. Trigger "When Status changes to Won", action "Post to Slack" to #sales with a template like:
🎉 Deal Won!
Deal Name: {Deal Name}
Value: {Deal Value}
Owner: {Owner}
Let's celebrate!
It keeps energy high and makes wins visible across the team.
Automation 3 — flag stalled deals
If a deal hasn't been updated in 14 days and is still in "Negotiating" or "Proposal Sent", change its status to "Stalled" (or post a Slack alert to your sales manager instead). Trigger on "last updated 14 days ago" with the status condition. Dying deals get flagged before you forget them.
Automation 4 — auto-fill probability on status change
Keep forecasts realistic by defaulting Probability from Status. Create one automation per stage: Lead → 10%, Contacted → 15%, Qualified → 50%, Proposal Sent → 70%, Negotiating → 80%. People can still override manually — this is just the smart default.
Part 4: Integrations
Connect monday.com to the tools you already use. No code required.
- Email → monday.com (Zapier). Label an email "Sales Follow-Up" in Gmail and Zapier creates or updates a deal, mapping subject → Deal Name, sender → Contact Email, body → Notes. No manual data entry.
- Google Calendar → monday.com. Meetings tagged "CLIENT MEETING" update the deal's Next Follow-Up date, so your calendar and your pipeline stay in sync.
- Won deal → invoice (Stripe / Wave). When Status changes to "Won", create an invoice automatically, mapping Deal Value → amount and Contact Email → customer.
- Monday Slack reminders. Every Monday at 9am, post the "Follow-Ups Due" list to Slack so the week starts organised.
Part 5: The 45-minute setup
- 0–5 min — create the board. Add a blank board named "Sales Pipeline".
- 5–20 min — add columns. Add the 15 columns above in order (don't worry about perfect ordering — you can drag to reorder). Paste the Status, Industry, and Source values.
- 20–30 min — create the four views. Sales Pipeline, Revenue Forecast, Team Performance, Follow-Ups Due (~2–3 minutes each).
- 30–40 min — add sample data. Drop in 5–10 test deals so you can watch it work. Don't perfect the data.
- 40–45 min — set up one automation. Build Automation 1, change a deal to "Qualified", and watch Next Follow-Up populate itself.
Common mistakes to avoid
- Using Text instead of Numbers for Deal Value — formulas silently break. Use the Numbers type with GBP currency.
- Not filtering out Lost deals in the daily view — your pipeline looks bigger than it is. Filter "Status is not Lost".
- Forgetting to update Probability — forecasts drift optimistic. Let Automation 4 set it.
- Too many custom fields — the board gets overwhelming and the team stops using it. Start with these 15 columns.
- Not assigning an Owner — accountability disappears. One person per deal, always.
- Setting automations but never testing them — trigger each one once to confirm it fires.
Where to go from here
This template comfortably handles up to ~500 active deals before you'd split it into multiple boards. When you're ready to scale, add a separate "Prospects" board for raw leads, a "Projects" board for won work, and automations to move deals between them. Add your real data via Board → Settings → Integrations → Import (Excel, Google Sheets, or CSV), then run a 20-minute Monday-morning review off the "Follow-Ups Due" and "Revenue Forecast" views.
Want it done for you?
The template above is genuinely all you need to run a tidy pipeline. But plenty of teams would rather not spend the afternoon — or want it adapted to a sales process that doesn't fit a generic template. That's where we come in, and there are two ways we help:
- CRM setup. We build this Sales CRM — tailored columns, views, automations, and the integrations that matter to you — configured around how your team actually sells. See our setup & configuration service.
- Full setup. If sales is just one piece, we'll build out your wider monday.com workspace — delivery, onboarding, operations — and keep it running with ongoing support. See our managed services.
Not sure where to start? Describe your sales process and get a tailored monday.com build plan in minutes.
Try the free Build Generator →Already have a CRM board that's grown messy? Get free, AI-powered fixes prioritised for you.
Run a free Health Check →Want us to build your CRM — or your whole workspace? Tell us what you sell and we'll take it from there. No lengthy calls.
Get in touch →