Build an Airtable CRM Client Portal

The Problem: Clients Cannot See Their Own Account Data

You run your business on an Airtable CRM — tracking companies, contacts, deals, sites, activity logs, and more. But your clients have no visibility into their own data:

• Add them as Airtable collaborators — they see every company's data, your pipeline, internal notes, and margin figures. Each seat also costs $20/month on Team plans.
• Send periodic email updates — stale the moment you send them. Clients reply asking about information that has already changed.
• Export to PDF or spreadsheet — manual effort every time, and clients have no way to update their own details.
• Build a custom portal — weeks of development to create a basic CRUD interface for your CRM data, plus ongoing maintenance.
• Use a heavy CRM platform (Salesforce, HubSpot) — your team is already in Airtable, and migrating is not worth the cost or disruption.

What you need is a way to let clients log in and see their account data — their deals, their contacts, their activity — without seeing other clients' data or your internal fields.

How CollabPortals Works for CRM Portals

CollabPortals connects to your Airtable CRM base and creates a branded portal that clients access via a shared link. They log in with their email, see only their own data, and can update fields you choose. Your sales and account management team continues working in Airtable.

Example: Account Management Portal

A B2B services company gives clients a portal to view their account data and update their details.

Table	Client Access	Purpose
Company	View, edit	Clients view and update their company details
Contacts	View only	Clients see who is listed as their contacts
Deals	View only	Clients see their active and past deals
Sites / Locations	View only	Clients see their registered locations
Activity Log	View only	Clients see a history of interactions
Pipeline Stage	Hidden	Internal sales process tracking
Revenue Targets	Hidden	Internal financial goals
Internal Notes	Hidden	Account manager observations and strategy

Clients see: their company profile, deal history, registered sites, and activity log. Your team sees: the full CRM with pipeline stages, revenue targets, and internal notes.

Use Cases for CRM Client Portals

B2B Account Portals

Service companies give clients a window into their account data — contracts, sites, contacts, activity history.

• Company (view, edit) — name, address, phone, email, website
• Deals / Contracts (read-only) — deal value, status, start/end dates, package
• Sites / Locations (read-only) — registered sites linked to the account
• Activity Log (read-only) — calls, meetings, emails, notes
• Hidden: credit score, financial data, internal priority, account tier, revenue targets

Agency Client Portals

Agencies give clients visibility into their campaigns, deliverables, and billing.

• Campaigns (view, edit) — campaign name, status, client feedback field
• Deliverables (read-only) — asset name, type, status, delivery date
• Invoices (read-only) — amount, date, payment status
• Contacts (view, edit) — client team members and their roles
• Hidden: internal costs, team hours, profit margin, vendor fees

Vendor and Partner Portals

Companies give vendors or partners access to their shared data — orders, inventory, performance metrics.

• Orders (view, create) — order details, quantities, delivery dates
• Products / Inventory (read-only) — stock levels, pricing, product specs
• Performance (read-only) — delivery metrics, quality scores
• Hidden: internal cost data, alternative vendor comparisons, sourcing strategy

What Makes This Better Than Airtable Interfaces

Capability	CollabPortals	Airtable Interfaces	Custom Portal
External client access	Yes — email verification, no Airtable account	No — requires Airtable seat ($20/month)	Yes (custom dev)
Per-user cost	None — unlimited users for $12/month	$20/month per client on Team plan	Varies
Per-client data isolation	Automatic (email-based matching)	Manual (complex filter setup)	Custom logic
Field-level permissions	Per-portal granular control	Tied to Airtable's permission system	Custom logic
Setup time	Minutes	Minutes (but internal only)	Weeks to months
Maintenance	None — changes in Airtable reflected instantly	Minimal	Ongoing
Custom branding	Portal name and slug	Limited to Airtable UI	Full control

The key difference: Airtable Interfaces is for your team. CollabPortals is for your clients. For a deeper look, see our full comparisons of CollabPortals vs Airtable Interfaces and CollabPortals vs Airtable Portals.

Field-Level Permissions for CRM Data

CRM tables contain sensitive fields that clients should never see:

• Show to clients: Company name, address, phone, deal status, deal value, contract dates, activity log entries, site addresses
• Hide from clients: Credit score, financial data (EBITDA, turnover, liabilities), internal priority, account tier, revenue targets, profit margins, internal notes
• Editable by clients: Company details (address, phone, email, website), contact info
• Read-only for clients: Deal status, deal value, activity history, site details

This lets clients keep their own details current while your team retains control over commercial and operational data.

Getting Started

Setting up a CRM client portal takes about five minutes:

1. Connect your Airtable account — CollabPortals uses OAuth, so your credentials stay secure
2. Choose your CRM base and set up a Users table — this is how CollabPortals matches clients to their company data
3. Configure table and field permissions — expose account data while hiding internal CRM fields
4. Share the portal link — clients visit the URL, verify their email, and see their account data

No code. No deployment. No ongoing maintenance beyond managing your Airtable CRM as you already do.

Frequently Asked Questions

Can clients only see their own company data?

Yes. Each client is matched to their record in your Airtable Users table via email. They see only deals, contacts, sites, and activity linked to their company. One client cannot see another client's data.

Can clients update their own company details?

Yes, if you enable edit permissions on the Company table and make specific fields editable. Clients can update their address, phone number, or other details directly, and the changes appear in your Airtable CRM immediately.

Will clients see our financial data or internal notes?

No. You choose exactly which fields are visible at the portal level. Fields like credit score, profit margin, internal priority, and account manager notes can be hidden while the same table shows client-facing fields like company name and address.

How much does this cost compared to adding Airtable seats?

CollabPortals costs $12/month for unlimited users and portals. Adding clients as Airtable collaborators costs $20/month per user on Team plans. For 20 clients, that is $12/month vs $400/month.

Does data stay in Airtable?

Yes. CollabPortals reads and writes directly to your Airtable base using the Airtable API. Your CRM data stays in Airtable — CollabPortals is just a controlled window into it.

Can I show different data to different client types?

You can create multiple portals with different table and field permissions, all connected to the same Airtable base. For example, one portal for enterprise clients showing detailed data, and another for smaller clients with a simplified view.