Sales Pipeline with Automatic Client Onboarding

Overview

The handoff between sales and onboarding is where deals go to die. A rep closes a deal, sends a Slack message to the onboarding team, and hopes someone picks it up. Meanwhile, the new client waits. Details get lost. Follow-ups fall through the cracks.

This template eliminates the handoff gap entirely. When a deal moves to "Closed Won" on your sales board, the linked item on your onboarding board automatically updates to "Ready to Start". Mirror columns pull the client's details across so the onboarding team has everything they need without asking. And a formula-based quota tracker alerts sales managers when a rep's cumulative deals fall below target.

Who This Template Is For

• Sales teams who hand off closed deals to a separate onboarding or account management team
• Sales managers who need real-time visibility into quota attainment
• Operations leads responsible for ensuring smooth client transitions
• Agencies and service businesses where every new client needs a structured onboarding process

Board Structure

Board 1: Sales Pipeline

Groups

• New Leads — freshly qualified leads entering the pipeline
• Discovery — initial conversations and needs assessment
• Proposal — proposals sent, awaiting decision
• Negotiation — terms being finalised
• Closed Won — deals closed and handed off
• Closed Lost — deals that did not convert (review monthly for patterns)

Columns

Board 2: Client Onboarding

Groups

• Ready to Start — newly closed deals awaiting onboarding kick-off
• In Progress — actively being onboarded
• Completed — fully onboarded clients
• On Hold — paused onboarding (awaiting client action)

Columns

Setting Up the Automations

Automation 1: Auto-Start Onboarding on Close

This uses the Update Status in Connected Board recipe.

What it does: When a deal's status changes to "Closed Won" on the Sales Pipeline board, the connected item on the Client Onboarding board automatically updates to "Ready to Start". The onboarding team sees it immediately without anyone manually triggering the handoff.

How to set it up:

1. Make sure both boards are connected via a Connect Boards column
2. On the Sales Pipeline board, open the Automations Centre
3. Search for Community Cookbook recipes
4. Select: When a status changes here, update the matching item in a connected board
5. Set the trigger status to Closed Won
6. Set the target status on the onboarding board to Ready to Start
7. Activate

The onboarding team can set up their own native monday.com automation to notify the account manager when an item enters the "Ready to Start" group.

Automation 2: Copy Client Details to Editable Columns

This uses the Copy Mirror Column Value to Editable Column recipe.

What it does: Mirror columns on the Onboarding board are read-only — you cannot use them in formulas, automations, or filters. This recipe copies the mirrored client details (company name, contact name, email) into local editable columns so the onboarding team can use them freely.

How to set it up:

1. On the Client Onboarding board, open the Automations Centre
2. Search for Community Cookbook recipes
3. Select: Read a mirror column and write its value to a real column
4. Map each mirror column to its local counterpart:
   • Client Company (Mirror) to Client Company (Local)
   • Contact Name (Mirror) to Contact Name (Local)
   • Contact Email (Mirror) to Contact Email (Local)
5. Activate

Now the onboarding team has editable client data they can use in email automations, filters, and formulas — without breaking the connection to the sales board.

Automation 3: Quota Tracking Alerts

This uses the Formula Column Threshold Trigger.

What it does: The Quota Attainment % formula calculates each rep's progress toward their quarterly target. When it drops below a threshold (e.g., if a rep is below 50% attainment at the mid-quarter mark), the trigger fires to alert the sales manager.

How to set it up:

1. On the Sales Pipeline board, open the Automations Centre
2. Search for Community Cookbook recipes
3. Select: When a numeric formula column goes above or below a number
4. Choose the Quota Attainment % column
5. Set the threshold: "below 50" at mid-quarter, or "below 75" at the three-quarter mark
6. Set the action to notify the sales manager

Adjust the threshold based on your sales cycle length. For short cycles (weekly close), check weekly. For longer enterprise sales, monthly checks work better.

Tips and Variations

• Deal value tiers: Create different onboarding workflows based on deal size. High-value clients might get a white-glove onboarding with subitems for each step, while smaller deals get a streamlined process.
• Lost deal follow-up: Add a native automation that schedules a follow-up task 90 days after a deal moves to "Closed Lost" — many lost deals can be revived later.
• Pipeline velocity: Add a formula column calculating days in each stage. Use the Formula Column Change Trigger to alert reps when a deal has been stalled too long.
• Client health score: On the onboarding board, add a formula combining onboarding progress, response time, and engagement metrics. Use the threshold trigger to flag at-risk clients early.
• Multi-product sales: If you sell multiple products, add a Dropdown column for product type and create filtered views per product. Each product can have its own onboarding template.

What You Will Need

• A monday.com account (Standard plan or above)
• Community Cookbook installed from the monday.com marketplace
• Two boards: one for sales pipeline, one for client onboarding
• A Connect Boards column linking them
• About 25 minutes for initial setup across both boards

Frequently Asked Questions

Can I connect more than two boards?+

What if the sales rep needs to update client details after closing?+

How do I calculate the quarterly running total per rep?+

Can I use this with an existing CRM?+

What happens if I accidentally move a deal back from Closed Won?+