Quick answer
Start with a blank Coda doc, then use the /table command to build core tables for Leads, Customers, Deals, and Tasks. Add custom columns for contact details, pipeline stages, and priorities, then use Relation columns to link records across tables. This creates a connected CRM system tailored to your sales workflow.
Steps at a glance
- Create a blank Coda doc and name it
- Build a Leads table with contact fields
- Add a Customers table for account details
- Set up a Sales Pipeline table with deal stages
- Add a Task Management table with deadlines and priorities
- Link tables together using Relation columns
- Set sharing permissions and automate status updates
Summary
A Coda CRM system uses linked tables to store leads, customer accounts, deal stages, and follow-up tasks in one connected workspace. Because every table can reference the others through Relation columns, updates to a deal or contact instantly reflect across your entire pipeline view.
Step-by-step guide
Step 1
Start a New Coda Doc
Open Coda and click '+ Blank doc' from the home screen to start with a clean workspace. Give your doc a clear name like 'Sales CRM' by clicking the title field at the top of the page so your team can find it easily later.
Step 2
Build Your Leads Table
Type /table anywhere on the page and press enter to insert a new table for tracking leads. Add custom fields such as Name, Company, Email, Lead Source, and Status — for guidance on adding and configuring fields, see how to add columns to a table.
Step 3
Create a Customers Table
Insert a second table using /table to store details for accounts that have converted from leads into paying customers. Include columns for account name, primary contact, industry, and account owner so your team has full context on every relationship.
Step 4
Set Up the Sales Pipeline Table
Add a third table to manage active deals and add a Deal Stage column that mirrors your actual sales process, such as Prospecting, Proposal, Negotiation, and Closed Won. Format the deal value column as Currency for accurate financial reporting, and customize the pipeline stages as dropdown options so reps can update deals with a single click.
Step 5
Add a Task Management Table
Create a final table to track follow-ups, calls, and sales activities tied to each deal. Set a due date column for deadlines and add a Priority column with levels like High, Medium, and Low — you can review how to assign tasks to specific team members for accountability.
Step 6
Connect Tables with Relation Columns
Click the add icon at the right edge of any table header and select 'Relation' as the column type. Choose the table you want to link — for example, connect Deals to Customers and Tasks to Deals — so records reference each other and updates stay consistent across your CRM.
Step 7
Automate Updates and Share Access
Set up buttons to automatically change a deal's stage or mark a task complete without manual edits. Once your CRM structure is working, click Share in the top-right corner to control who can view or edit the doc, and choose whether to publish it as a reusable template for future projects.
Why this matters
You're juggling spreadsheets, email threads, and sticky notes to track leads and deals, and nothing stays updated. Building a CRM in Coda gives your sales team one connected workspace where contacts, pipeline stages, and tasks stay in sync, so nothing falls through the cracks and everyone sees the same real-time data.
Frequently asked questions
Can I build a CRM in Coda without a paid plan?
Yes. Core features like tables, Relation columns, formulas, and buttons are available on Coda's free plan, making it possible to build a complete working CRM before considering an upgrade.
Can multiple people collaborate on the same CRM doc?
Yes. Coda docs support real-time collaboration, so team members can view or edit leads, deals, and tasks simultaneously, with changes syncing instantly for everyone with access.
Does Coda integrate with other tools for CRM data?
Coda supports pack integrations that connect to external tools like email, calendars, and spreadsheets, letting you pull in or sync data such as contact records or scheduled meetings directly into your CRM tables.
Can I turn my CRM into a reusable template?
Yes. Once your tables and automations are set up, you can save the doc as a template from the Share or Doc settings menu so you can duplicate the same CRM structure for future teams or projects.
Related guides
Continue with more step-by-step guides for getting work done.
How to Add Columns to a Coda TableLearn how to add, rename, and configure new columns in a Coda table using the built-in plus button and column type menu.
How to Assign Tasks in CodaLearn how to assign tasks in Coda using Person-type columns, filters, and sharing settings so every team member sees exactly what they own.
How to Automate Tasks with Buttons in CodaLearn how to create Coda buttons that automatically add, update, or assign tasks with pre-filled data to speed up your workflow.
Create interactive demos like this one — free, no coding required.
Start for free →