Share Airtable data with clients without giving access

Four ways to share Airtable data without giving access to your base, compared on what each costs, who can see what, and how current the data stays.

Title card for the post, showing an Airtable table panel connected by a downward arrow to a Google Sheets panel on a dark background

Your client emails on a Thursday asking where their project stands. The answer is sitting in Airtable, in a base that also holds your margins, a note about their last late invoice, and eleven other clients.

So you screenshot it, or retype the status list into an email. You have done both, and you will do it again next Thursday.

What you want is for the client to read their own numbers whenever they like, see nothing else, and not appear as a line on your Airtable bill. Four arrangements do that, and every one gives something up. This walks all four, with prices checked on 22 July 2026.

The short answer

If the client only needs to read and you are relaxed about the link travelling, a shared Airtable view link is free and takes a minute.

If you want access granted per person and revocable, without a second subscription, sync a filtered Airtable view into its own Google spreadsheet and share that spreadsheet the way you share every other document. Google's sharing permissions become the access control layer you were about to buy from someone.

If the client needs to submit or edit rather than read, none of the above. Use a form, or a real portal, and pay for it.

What Airtable actually bills you for

The belief that any outside person costs a seat is half right, and the wrong half matters.

Airtable's pricing page says you are charged for every user with edit permissions on at least one base in the workspace, and that no charge applies on Team or Business for read-only collaborators, form submissions, or share links. A client who only looks is free.

The billing line is what they can do, not who they are. Commenter permission is billable on Team and free on self-serve Business, where only Owner, Creator and Editor are charged. Team is $20 per user per month billed annually, Business is $45, both checked 22 July 2026. As one Airtable community post puts it: "The moment you need vendors, clients, or partners to log in and update anything, even a single field, Airtable treats them as paid seats."

Which leaves the harder half, described exactly by another poster: "Each product record has a lot of internal pricing information that we do not want to share with our clients." Free read-only access is no use if the boundary around what they read does not hold.

Option 1: A shared view link

Open a view in Airtable, use the share menu, generate a link, send it. The recipient needs no Airtable account. It is read-only. It takes about sixty seconds.

Paid plans add a password and a restriction to a specific email domain. Any plan lets you disable a link and regenerate it, and lets you turn off Allow viewers to copy data out of this view.

Two things to know before you rely on it.

A link is not a person. Anyone who receives the URL can open it, including whoever your contact forwards it to. Five clients means five views and five links, and no record of who opened which. You revoke by regenerating, which cuts off everyone at once.

Hidden fields are mostly hidden, and the exceptions are the ones that hurt. Fields you hid in a grid view stay hidden when a record is expanded. But a grouped grid view always shows the grouping field, a calendar view always shows its date field, kanban always shows the stacking field, and gallery and kanban always show the cover attachment field. There is also a share setting that reveals every field when a record is expanded. One person switching that on, or regrouping the view to be helpful, puts your cost column in front of the client.

Good for: a single read-only list you would not mind a stranger seeing.

Option 2: An interface, and then Portals

Interface Designer produces something far nicer to hand a client than a grid, and an interface-only viewer is free. So on paper this is the answer. Two conditions come with it.

Sharing an interface separately from the base is restricted to paid plans, and the recipient needs a verified Airtable account. Your client signs up for Airtable to read your status list. Some will. Some will not reply for a week.

And free means viewing only. An interface-only commenter is billable on Team and free on Business. An interface-only editor is billable on both. The moment the client ticks a box, approves a proof, or types a note, you are paying for them.

Airtable's own answer for people outside your company entirely is Portals, an add-on on Team, Business and Enterprise Scale. Portal guests need no existing Airtable account, and read-only guests are not individually billable. The add-on is. Airtable's documentation lists it starting at $120 per month for 15 portal seats on Team and $150 per month for 15 on Business, sold in packs from 15 up to 200, checked 22 July 2026.

Fair for a vendor network. A lot to show three clients a status list. Per-client scoping is also not automatic: you build filters matching records to the signed-in user, and you maintain them.

Option 3: A client portal tool

Softr, Noloco, Glide, Stacker and MiniExtensions sit on top of Airtable and turn it into a logged-in client-facing app. These are good products and this is the job they exist for.

Entry prices, all checked 22 July 2026: Softr's Basic plan is $49 per month billed annually with 20 app users, rising to $139 for Professional and $269 for Business. Noloco's Pro plan is $99 per month billed annually, or $149 month to month, with 10 team seats and 50 client seats. Glide's Business plan starts at $199 per month billed yearly with 30 users included.

If you are giving forty clients a branded login with per-client filtering, uploads and write-back, buy one of these. Nothing else does that job as well.

If you are giving three clients a table of numbers, you are buying a platform to avoid a spreadsheet.

Option 4: A synced Google Sheet

Here is the option no portal vendor will suggest, for reasons you can guess.

You already own an access control system with per-person permissions, instant revocation, viewer and commenter roles, named access you can audit, and an interface every client already knows. It is Google Drive sharing, and it comes with the account you use to invoice them.

The pattern: build an Airtable view holding only what this client may see, sync that view into a spreadsheet of its own, then share the spreadsheet with the client's email address as a Viewer.

What that gets you:

  • Access per person, not per link. You grant it to an address, you see who holds it, and you remove one person without disturbing anyone else.
  • Viewer or Commenter. Commenter lets the client ask "is this number right?" in the margin instead of by email, at no cost.
  • Optional lockdown. Google can stop viewers and commenters downloading, printing or copying the file. On eligible work and school accounts you can also set an expiry date on someone's access.
  • No new bill. No Airtable seat, no portal subscription, no per-client charge from Google.
  • The client opens a spreadsheet. They sort it, filter it, and paste it into whatever they report upward with. Nobody gets onboarded to anything.

Setting the sync up is a separate job, covered in how to sync Airtable to Google Sheets. Airtable to Sheets is the add-on we build for it, and it syncs a chosen view rather than a whole table, which is the part that matters here.

The four options compared

Four columns comparing a shared view link, an Airtable interface or Portal, a client portal tool and a synced Google Sheet, on whether the client needs a new account, what it adds to the bill, whether access is granted per person, and how current the data stays. Every column carries one drawback. The synced sheet is the only one giving per-person access with no new account and no new bill, and its drawback is that the data is only current as of the last sync.

Shared view link Interface or Portals Portal tool Synced Google Sheet
Client needs an account No Yes for interfaces, no for Portals Yes A Google account
Adds to your bill No Only above read-only, plus the Portals add-on Yes, a second subscription No
Access granted per person No, per link Yes Yes Yes
Revoke one person No, regenerate for all Yes Yes Yes
How current Live Live Live As of the last sync
Client can edit No Yes, and then they are billable Yes Only with two-way sync
Setup effort One minute An hour, then upkeep A weekend Ten minutes
Best for One list you do not mind travelling Clients already inside Airtable Many clients, real app A few clients who need numbers

Setting it up without leaking anything

The method rests on one idea people get wrong, so it goes first.

Scoping happens in the Airtable view, not in the spreadsheet. Hiding a column in Google Sheets hides nothing. Any viewer can right-click and unhide it, and a downloaded copy carries it regardless. Same for white text, narrow columns, and a tab you forgot to delete. If a number reaches the spreadsheet, treat it as visible to the client, permanently. The only boundary that holds is the one applied before the data leaves Airtable.

A four-stage chain running from the full Airtable base of 9 fields and 412 records, to a client-scoped view of 5 fields and 38 records, to a spreadsheet of its own, to the client as a Viewer. Cost and margin fields, the other eleven clients, and internal account notes are all shown being left behind at the view stage, not later.

  1. Build a view for this client. A grid view named after them. Hide every field they should not see: cost, margin, internal notes, the account owner. Then filter to their records only.
  2. Do not group that view. The grouping field is always visible in a share, and grouping is how a hidden field quietly becomes a visible one.
  3. Sync the view, not the table. Filtering logic then lives in Airtable, where your team already maintains it, instead of being rebuilt as spreadsheet formulas that drift.
  4. Give it its own spreadsheet. Not a tab in your internal workbook. Sharing a file shares every tab in it, and one day someone adds a tab.
  5. Share with the client's email address as Viewer. Not "anyone with the link". Commenter if they need to ask questions in place.
  6. Turn off download, print and copy in the sharing advanced settings if the numbers are sensitive.
  7. Put the sync on a schedule so their copy stays current without you remembering, covered in updating Google Sheets from Airtable automatically.

Ten minutes, once per client. After that the client stops emailing on Thursdays.

Where this is the wrong tool

Four limits, because a client-facing surface is the wrong place to be surprised.

It is a copy, not a window. The spreadsheet is accurate as of the last sync and no fresher. Google caps add-on scheduled triggers at roughly one run per hour as a platform ceiling, and our scheduled sync runs every 3 hours. If the client is watching a number that must be right to the minute, this is not the surface for it.

Anyone with access can keep the numbers. Turning off download and copy raises the effort. It does not defeat a screenshot. Share only what you would accept the client keeping forever.

It does not carry edits back by default. Two-way sync, where an edit in the sheet returns to Airtable, is a deliberate setup on our Business plan at $39 per month. One direction is the right default for a client file.

It is a reading surface, not an intake surface. If the client needs to submit a request, upload a file, or approve something, use an Airtable form or buy a portal. A spreadsheet shared with a client is a bad place to collect anything.

Also, do not build the client view around attachment columns. Airtable hands over file links it only guarantees for a couple of hours, so the client clicks a document link next week and gets an error. Full explanation in Airtable attachments in Google Sheets, and which columns survive the trip generally is in Airtable field types in Google Sheets.

Common questions

Does giving a client read-only Airtable access cost a seat?

No. Airtable charges for users with edit permissions on at least one base. Read-only collaborators, form submissions and share links are free on Team and Business. Commenter permission is billable on Team and free on self-serve Business. The bill starts when the client can change something, not when they can see it.

Can my Airtable share link be forwarded?

Yes. It is a URL, and anyone holding it can open it unless you add a password or an email-domain restriction, both paid-plan features. There is no per-person record of who used it, and revoking means regenerating the link, which cuts off every recipient at once.

Can a client see fields I hid in the shared view?

Usually not, with exceptions that catch people out. A grouped grid view always shows the grouping field, a calendar view its date field, kanban its stacking field, and gallery and kanban the cover attachment field. A share setting can also reveal all fields when a record is expanded. Open the link yourself in a private window before you send it.

How do I stop a client seeing my other clients?

Filter the Airtable view to that client's records before anything leaves Airtable. Do not filter in the spreadsheet and do not rely on hidden columns or hidden tabs, because a viewer can undo both. One view and one spreadsheet per client.

How current will the client's spreadsheet be?

As current as the last sync. Google caps add-on scheduled triggers at roughly one run per hour across the platform, and our scheduled sync runs every 3 hours on the Pro and Business plans. Fine for project status, deliverable lists and monthly numbers. Not fine for anything the client refreshes anxiously.

Can the client edit the sheet and have it reach Airtable?

Only if you set that up deliberately. Viewer or Commenter access means they cannot change the data at all, which is the right default for a client file. Two-way sync exists on our Business plan at $39 per month when you do want an edit in the sheet to return to Airtable.

What to do next

Build the client view in Airtable first, with only the permitted fields and a filter scoped to that one client. Look at it as if you were them. Then sync that view into a spreadsheet of its own and share it with their email address as a Viewer.

The setup steps for the sync itself, including how to point it at a view rather than a table, are in how to sync Airtable to Google Sheets.