How to Use ClickUp as a CRM for a Small Agency

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for How to Use ClickUp as a CRM for a Small Agency.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for How to Use ClickUp as a CRM for a Small Agency.

A small agency can run a simple CRM in ClickUp with one CRM Space, Lists for Leads, Clients and Deals joined by Relationship fields, custom statuses on each List, and AI Fields or Brain to draft client status updates. Core is the practical plan, because Custom Fields and automations are what make the pipeline work.

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

The build takes an afternoon, and the habit takes a month. A ClickUp CRM fails when it is built beautifully and nobody updates it, so every design choice below leans towards fewer fields, fewer statuses and rules that nudge people instead of relying on memory. The agency in the examples is illustrative: five people, about 40 new leads a month, and retainers as the main product.

What structure should a small agency's ClickUp CRM have?

A small agency's ClickUp CRM needs one dedicated sales Space with three Lists in it: Leads, Clients and Deals. Each record is a task, and Relationship Custom Fields connect them so you can move between a client and its deals.

ClickUp's own CRM help page recommends one Space (or a Folder inside an existing Space) containing Lists for Leads, Contacts, Accounts and Deals. A very small agency can fold Contacts into Clients, as the build below does. Add a separate Contacts List later if you work with several decision-makers per client.

ListEach task isWhy it is separate
LeadsOne enquiry, until it is qualified or droppedHigh volume, short life, its own statuses
ClientsOne company you work with or want toLong life; holds the status of the whole relationship
DealsOne proposal or retainerMoney and dates; one client can have several

Keep the sales Space apart from your delivery Spaces. Sales data then has its own permissions, and you can hide it from freelancers or guests. The safest way to share client information with someone outside the team is through permissions and guests set up carefully, not by giving them access to the whole Space.

The glue is a Relationship Custom Field. When you create a Custom Field, choose the Relationship type, then pick either any task in your Workspace or tasks from a specific List. On Deals, create a field called Client that points to the Clients List; on Leads, one that points to Clients too, for when a lead belongs to an existing client. You can enable Create rollup fields to show data from the related tasks, for example the client's industry on each deal. ClickUp says Relationship fields can't be moved, merged or converted afterwards, so name them with care.

Which statuses should each List use?

Each CRM List in ClickUp should have its own short set of statuses that describe where the record is, not what you plan to do next. Statuses can be set per List, so Leads, Clients and Deals can each have different ones.

ClickUp recommends the following, or a variation of them, in its "Create statuses for CRM" article:

ListClickUp's suggested statuses
LeadsNew lead, Attempt to engage, Engaged, Qualified, Qualified - archive, Unqualified - follow up, Unqualified - archived
Accounts (Clients here)Prospect, Active, At risk, Lost deal, Former client, Closed
DealsOpen, Need approval, Blocked, At risk, Scheduled, On track, On hold, Closed

For a five-person agency, those lists are longer than people will keep up with. Here is a trimmed version to start from, which you can lengthen once the habit sticks:

  • Leads: New, Contacted, Call booked, Qualified, Not a fit.
  • Clients: Prospect, Active, At risk, Former.
  • Deals: Proposal drafting, Proposal sent, Negotiating, Won, Lost.

Every status should answer the question "what is the next action, and whose is it?" If two statuses lead to the same next action, merge them. To create them, hover over the List in the Spaces section of your sidebar, click its ... menu (or right-click it), choose List statuses, and add or rename statuses for that List. Put each one in the right group (Active, Done or Closed) so reports and automations treat them correctly.

One limit shapes the Deals List in particular. ClickUp gives each workflow a single Closed status: you can rename it, but you cannot add a second one. So Won and Lost cannot both be Closed. A workable split is Won in the Done group, which ClickUp never counts as overdue, and the Closed status renamed to Lost, so lost deals drop out of the default List view while won ones stay visible until delivery starts.

Which custom fields does an agency CRM really need?

An agency CRM in ClickUp needs eight to twelve custom fields in total, most of them dropdowns. Every field is something someone must fill in, so each one has to earn its place by feeding a filter, a report or an automation.

ClickUp's help centre lists the field types it recommends for CRM Lists: dropdowns such as Lead source, Company size, Industry, Type of service, Account tier and Billing cycle, Money fields for Deal amount and Contract amount, a Number field for discount or probability percentage, People fields for an account manager who is not the main assignee, plus Email, Phone and Text fields for contact details. Here is how an agency might split them:

ListFieldTypeUsed for
LeadsLead sourceDropdownWhich channels bring work
LeadsType of serviceDropdownRouting and proposal templates
LeadsExisting or new clientCheckboxTriggers the move to Clients
ClientsIndustry, Company sizeDropdownsSegmenting and case studies
ClientsAccount managerPeopleWho owns the relationship
ClientsContact name, Email, PhoneText, Email, PhoneMain contact
DealsDeal amountMoneyPipeline value
DealsProbabilityNumberWeighted forecast
DealsClientRelationshipLink to the Clients List
DealsExpected closeDateForecast month

On plans, ClickUp's pricing page lists Custom Fields as a trial-only feature on Free and included on Core and above, although a help-centre article mentions 60 Custom Field uses on Free. Plan on Core, which is $9 per user per month on yearly billing, so $45 a month for five people.

How do you build the CRM, step by step?

Build a ClickUp CRM in order: the Space, the Lists, the statuses and the fields, then the views and rules, testing with ten real leads before migrating the rest.

  1. Try the template first. ClickUp offers a Quick Start: Sales & CRM template that creates a CRM Space with its recommended Hierarchy, statuses and fields. Use it as a starting point and delete what you do not need; deleting is quicker than building.
  2. Or build it by hand. Create a Space called Sales, then add the three Lists.
  3. Set the statuses on each List as above.
  4. Add the Custom Fields from the table, creating the Relationship fields last, because they need the target List to exist.
  5. Create views. A Board view on Deals, grouped by status, gives you the pipeline picture. A Table view on Leads with columns for source, service and last updated gives you the working list. Save a filtered view of leads not updated in 14 days.
  6. Import ten live leads by hand, with real values, and run through them for a week. Change what annoys people.
  7. Add automations once the manual flow is stable (next section), then migrate the rest.

When enquiries arrive through your website, a ClickUp form can create the lead task directly in the Leads List, with the Lead source and Type of service fields filled from dropdowns. ClickUp also notes that Email in ClickUp can be used to communicate with leads without leaving the app.

Which automations keep the pipeline moving?

Five small ClickUp automations keep an agency pipeline moving: remind at Qualified, move the lead to Clients, link the client to a deal, create the deal, and chase stale leads. ClickUp's own CRM help describes the first four.

  • Qualified reminder. Trigger: Status changes to Qualified in Leads. Action: Add a comment that mentions the assignee, asking them to tick Existing or New client.
  • Move to Clients. Trigger: Custom Field changes on the Existing or New client checkbox. Action: Move to List, Clients. ClickUp's example uses two rules, one for each checkbox.
  • Link and activate. In Clients, trigger Task or subtask linked, then two actions: Add a comment reminding the owner to fill in the company name and tick Create deal, and Change status to Active.
  • Create the deal. Trigger: Custom Field changes on a Create deal checkbox. Action: Create a task in the Deals List.
  • Stale lead chase (my addition). Use the lead's due date as its next follow-up date. Trigger: Date is Before/After, set to 1 day after the due date (the trigger starts on the start date by default, so switch that dropdown). Action: comment mentioning the assignee, asking for a new date or a move to Not a fit.

Automations are included on all plans but capped: 100 actions a month on Free, 1,000 on Core and 10,000 on Business, shared across the Workspace. At about 40 leads a month and two actions for each of four rules, the CRM would use roughly 320 actions, comfortably inside Core. The first five ClickUp automations for a small team explains how actions are counted and how to test a rule safely.

How do AI-written client status updates work in ClickUp?

ClickUp offers two routes: an AI Field that writes a summary or progress update on each task, and Brain, which generates a project update for a chosen List and time period. Either gives you a draft to edit before it goes to the client.

Route 1: AI Fields on each client or deal

AI Fields work inside Long Text and Dropdown Custom Fields. The Long Text types include Summary, Progress Updates, Translation, Action Items and Custom Text. A Summary field can be formatted as a bulleted list, short or traditional, and a Progress Updates field covers a period such as the last 7 days or the last 30 days. You can click the column header to bulk-generate for every task in a List.

Two cautions from ClickUp's own pages. AI Fields use AI credits, and the Autofill when tasks are created option is activated by default, so new tasks generate content (and spend credits) automatically unless you switch it off. Second, Free Forever guests, view-only guests and view-only limited members cannot generate them.

The two routes are paid for differently, and that matters on Core. AI Fields draw on the pooled AI credits and do not count towards Brain usage. Brain itself is only an "extended trial" on Core, according to ClickUp's Brain limits page, with unlimited standard-model use starting on Business. So on Core, let AI Fields carry the routine weekly drafts and keep Brain for the occasional project update.

Route 2: Brain generates a project update

From a Space, Folder or List, open Brain, choose to generate a project update, then pick the location and the time period. Brain summarises changes in priority and due dates and the comments on the tasks in that location. After it responds you can Copy, Create task, Create Doc or Retry. The Executive Summary option in the location header's Ask menu does a similar job with advanced filters, such as task type and status.

To make the draft client-ready, put the client's work in a List of its own, keep comments factual, and give Brain a prompt like this one:

Write a client status update for the last 7 days for this List.
Audience: the client's marketing manager. Tone: plain, confident, no jargon.
Structure: 1) What we finished, 2) What we are working on next week, 3) What we need from you, with a date.
Only use facts from the task comments and statuses. If something is unclear, list it under "To confirm" instead of guessing.
Keep it under 150 words.

An illustrative result: "This week we finished the three landing-page drafts and sent the ad copy for review. Next week we are building the email sequence and setting up tracking. We need your approval on the pricing-page headline by Wednesday. To confirm: whether the webinar date has moved." What you fix in it: confirm the webinar date, make sure nothing in it was promised in a private comment, and check that the "needed by" date matches the task.

If you would like help fitting an AI-drafted update routine into how your agency already reports to clients, I offer one-to-one AI consultations for small businesses.

A worked example: five people, 40 leads a month

Take an illustrative five-person agency, with a founder, two account managers, a designer and a developer. It receives about 40 enquiries a month, qualifies 16, books proposals for 10 and wins 4 retainers at an average $2,500 a month. All figures are invented to show the arithmetic.

The Board view on Deals shows 10 proposals at $2,500, a $25,000 monthly pipeline. With a Probability number on each, the weighted forecast is the sum of amount multiplied by probability. If four proposals are at 70 percent and six at 30 percent, that is 4 x $2,500 x 0.7 + 6 x $2,500 x 0.3 = $7,000 + $4,500 = $11,500 a month. That figure, not $25,000, is the one to plan hiring around.

The Monday sales meeting then takes ten minutes. The founder opens the saved view of leads not updated in 14 days, each account manager says what happens to theirs, and anything stuck is moved to Not a fit. After the meeting, a Progress Updates AI Field (or Brain, within its allowance) drafts the client updates from the week's comments and each account manager edits the two or three they own.

Costs: $45 a month for Core seats, plus AI credits drawn from a pooled 5,000 a month (1,000 per seat on Core). ClickUp says credit use varies by feature, model, context and reasoning level, so test your own flows on a handful of tasks before switching on bulk generation.

If the forecast sheet is where you spend your time, try The Complete Excel Course with AI Integration on Coding Liquids. Copy the Deals table into a sheet to build a monthly forecast with weighted amounts.

What should a lead record look like once it is filled in?

A good ClickUp lead record is short enough to read in ten seconds and complete enough that a colleague could pick it up. Illustrative example of a lead after its first call:

FieldValue
Task nameDental practice: website refresh enquiry
StatusCall booked
AssigneeAccount manager 1
Lead sourceReferral
Type of serviceWebsite and monthly SEO
Existing or new clientUnticked
DescriptionOwner wants a new site before January. Budget not yet shared. Next step: discovery call Thursday; send two relevant examples first.

The description is the part people skip. Put the next step and its date in the first line of the description, or in a Date field, so that the saved "not updated in 14 days" view and the stale-lead rule have something to act on. The record is an illustration, not a real client.

Which views does the Monday sales meeting need?

A Monday sales meeting needs four saved ClickUp views: the pipeline board, the stale list, the new-this-week list and the at-risk clients list. Each is a filtered view of one List, saved so nobody rebuilds it.

  1. Pipeline board (Deals). A Board view grouped by status, with the Deal amount and Probability on each card.
  2. Stale leads (Leads). A Table view filtered to statuses before Qualified and Date updated older than 14 days, sorted oldest first.
  3. New this week (Leads). A List view filtered to Date created in the last 7 days, to check that every enquiry has an owner.
  4. At-risk clients (Clients). A List view filtered to the At risk status, with the Account manager column shown.

Run the meeting in that order: new, stale, pipeline, at risk. Ten minutes is enough if everyone updates their tasks beforehand, and the meeting gives the update habit a reason to exist.

What happens when a deal is won?

A won deal should start delivery without anyone retyping the brief. ClickUp's automation actions include Create list, which lets you name a List, choose where it goes and use a template, and Create a task, which can place a task in another List and relate it to the trigger task.

  1. Trigger: Status changes to Won on the Deals List.
  2. Action 1: Create list in your Delivery Space, using your onboarding template, then rename the new List after the client.
  3. Action 2: Add a comment asking the account manager to set the linked client's status to Active. The Change status action only changes the task that fired the rule, so it cannot update the client record from the deal.
  4. Action 3: Add a comment on the deal that mentions the delivery lead and the account manager.

The onboarding template holds the standard tasks: kick-off call, access requests, brand assets, first deliverable. Because these are actions that can be used from a trigger, the Won status becomes the single event that starts a project.

Which update prompts suit different client moments?

Three saved prompts cover most client moments beyond the weekly update: a renewal check-in, an at-risk summary and a proposal follow-up. Write them once and reuse them. ClickUp lets you save, share and reuse Brain prompts (type / in Brain, then Add new prompt), but only on Business and above; on Core, keep the same wording in a pinned Doc and paste it in. Illustrative prompts for the three situations:

Renewal check-in: Using the activity on this client's tasks over the last 90 days, write a short note for the account manager listing what we delivered, results mentioned in comments, and any open complaints. Do not invent numbers.

At-risk summary: Summarise why this client is marked At risk using the comments from the last 30 days. List facts first, then possible causes, and mark anything you are inferring.

Proposal follow-up: Draft a three-sentence follow-up to a client who received a proposal 5 days ago, referring to the services in the Type of service field. Friendly, no pressure, one question.

In each case, the draft is only as good as the comments underneath it. If your team logs calls as "spoke to client" with nothing else, Brain has nothing to summarise, so the fix is a habit of one specific sentence after each call, not a better prompt.

What does a "good" week of CRM data look like?

A good week of CRM data lets you read five numbers in two minutes: new leads, leads moved, proposals sent, proposals won and the weighted pipeline. Track them for the first six weeks, as these figures show the conversion between each stage in your own agency, and no template can tell you that.

Use a simple conversion check. If 40 leads become 16 qualified, the first stage converts at 40 percent; if 16 become 10 proposals, the second at 62.5 percent; if 10 become 4 wins, the third at 40 percent. The weak stage tells you where to spend effort, whether on enquiry quality, the qualifying call or the proposal. These are illustrative numbers for the example agency, and your own will differ.

Where does ClickUp fall short of a dedicated CRM?

ClickUp is a project tool with CRM building blocks, so it suits teams with a few dozen live records and simple stages. It is weaker where a CRM does the work for you: email tracking, sequences, call logging and lead scoring.

ClickUp's CRM help pages describe the hierarchy, views, fields, statuses, automations, ClickApps and dashboards. They do not describe built-in lead scoring or email sequences, so confirm in a trial that your must-haves exist before you commit. A drip-campaign checkbox plus an automation can send emails, as ClickUp's CRM fields page suggests, but that is a workaround and not a sequencing tool. Here is a decision table:

Your situationBetter fit
Under about 50 live leads, projects and sales in one placeClickUp CRM
Need email sequences, call recording or lead scoring out of the boxA dedicated CRM, with ClickUp for delivery
Many contacts per client and a long sales cycleClickUp with a separate Contacts List, or a dedicated CRM
Sales team of one or two who will not log activityFix the habit first; a tool will not

If you are weighing a move, whether a better CRM is worth it for AI features alone is a useful companion.

What breaks a homemade CRM in the first three months?

Four people problems break a homemade ClickUp CRM in its first three months: too many fields, overlapping statuses, two homes for one client and AI summaries nobody checks. Design for them from the start.

  • Too many fields. By week three, half are blank. Delete any field you have not filtered or reported on in a month.
  • Statuses that overlap. "Contacted" and "In discussion" mean the same thing to two people. Write one line of definition for each status in the List description.
  • Two homes for a client. A client appears as a lead and in Clients. Use the checkbox rule to move the task rather than copying it, and search before creating.
  • AI summaries nobody reads critically. A draft that sounds confident can carry a wrong date. Make the account manager the named editor, and never auto-send.

Also check that the credits last. With Autofill on, every new lead can trigger an AI Field, so decide which fields really need it. To see how the numbers add up, read what Brain costs for a team of ten, and when you are ready to bill won deals, invoicing from tracked time in ClickUp picks up where the Deals List stops.

Questions about running a CRM in ClickUp

Is ClickUp good enough to replace a dedicated CRM?

For a small agency with a few dozen live leads, yes, if you accept manual steps. ClickUp's CRM help pages cover Lists, statuses, fields, views and automations. Check that your must-haves, such as email sequences, call logging or lead scoring, are covered in a trial before you move your pipeline over.

Which ClickUp plan do I need for a CRM?

Core is the practical starting point. ClickUp's pricing page shows Custom Fields as a trial-only feature on Free and included from Core, and statuses, relationships and automations are what make a pipeline work. Business adds automation conditions, more monthly actions, saved Brain prompts and unlimited standard-model Brain use, where Core has only a trial allowance.

Can ClickUp's AI write the client status updates for me?

It can draft them. AI Fields can fill a summary or progress-update field on each task, and Brain can generate a project update for a List over a chosen period. Treat the output as a first draft: check names, dates and anything promised before it reaches a client.

How do I stop lead data going stale in ClickUp?

Use an automation and a view. A rule can comment on a lead the day after its follow-up date passes, and a saved view filtered to leads with no update in 14 days gives the owner a Monday list. ClickUp cannot make people log calls, so make updating the task part of the meeting agenda.

Should leads and clients live in the same List?

No. Keeping Leads, Clients and Deals in separate Lists stops fields and statuses from overlapping, because each List has its own statuses. Link them with a Relationship Custom Field so a deal shows its client, and a client shows its deals.

Further reads

Sources: ClickUp help-centre articles on ClickUp for CRM (hierarchy, custom fields, statuses, automations), Relationship Custom Fields, AI Fields, Brain project updates and AI credits, and the ClickUp pricing page (read on 22 November 2026).

Ready to put AI on the jobs that eat your week?

No data team or big budget needed. In a 1:1 consultation I show small and medium-sized businesses and self-employed people which AI tools they can use, one workflow at a time.

Book a 1:1 call with me