Airtable as a Client Database for Spiritual Practitioners

Most practitioners track clients in one of three ways: a spreadsheet that never gets updated, a folder of email threads, or their own memory. All three fail the same way - six months later, a repeat client books and you have no record of what came up in their last reading, what question they were sitting with, or whether they paid. Airtable fixes the data problem without requiring a developer or a CRM subscription.

This guide covers a practical Airtable setup for a solo tarot reader, astrologer, or healer: how to structure the database, which views matter, and how it compares to Notion for this specific use case.

Notion as a client portal option is covered separately at Notion client portal for readings. This guide is specifically about Airtable's relational database approach.

Why Airtable (and Why Not a Spreadsheet)

A Google Sheet can hold client names and session dates. What it can't do cleanly is link a client record to every session that client has had, then link each session to a payment record, then show you a filtered view of all clients who haven't booked in 60 days. That relationship between tables is what Airtable handles natively through linked records.

When you click a client's name in Airtable, you see every session they've had, every payment, every note - all connected. In a spreadsheet, that requires VLOOKUP formulas and manual cross-referencing. The difference becomes clear around the 30-client mark, when keeping spreadsheet tabs aligned stops being viable.

Airtable Pricing

Pricing as of June 2026, with a note that Airtable's pricing has been in flux - verify current tiers at airtable.com/pricing:

Source: tech-insider.org/airtable-vs-notion-2026 and airtable.com/articles/notion-alternatives (2026). Exact Plus/Pro figures flagged as needing verification against current pricing page.

For a solo practitioner with under 1,000 total client-session records, the Free plan covers the full database structure described here. At a realistic rate of 3-5 sessions per week, you reach 1,000 records after roughly 4-6 years. The Free tier is not a meaningful constraint at startup.

Database Structure: Three Linked Tables

Build three tables and link them together. This is the foundation.

Table 1: Clients

Columns:
- Name (text)
- Email (email)
- Phone (phone number)
- Date of birth (date) - for astrology or numerology calculations
- Services interested in (single or multiple select: Tarot / Astrology / Human Design / Reiki / Other)
- First session date (date)
- Notes on preferences (long text) - communication style, preferred session length, topics to avoid
- Linked field to Sessions table

Table 2: Sessions

Columns:
- Date (date)
- Client (linked record to Clients table)
- Session type (single select: 30-min Tarot / 60-min Natal Chart / 90-min Deep Dive / Group Workshop)
- Reading notes (long text) - what came up, main themes, cards drawn, placements discussed
- Key takeaways for client (long text) - what you'd want to remember before their next session
- Payment status (single select: Paid / Pending / Complimentary)
- Linked field to Payments table

Table 3: Payments

Columns:
- Date (date)
- Amount (currency)
- Method (single select: NowPayments / Wise / Gumroad / Cash / Other)
- Session (linked record to Sessions table)
- Invoice sent (checkbox)
- Notes (text) - crypto transaction ID, partial payment details, etc.

The Views That Save Time

Views are filtered, sorted perspectives on the same underlying data. Create these four from day one:

This Week (Sessions table): Filter - Date is within this week. Sort by date ascending. Every session you have coming up, in order, with the client record one click away.

Follow-up Needed (Clients table): Filter - Most recent session date is more than 60 days ago. This surfaces clients who may be ready to rebook but haven't reached out. Useful for a monthly outreach DM: "Thinking of you - would love to do another session if it feels right."

Pending Payments (Payments table): Filter - Payment status is Pending. Nothing falls through. Every unpaid session is visible.

Client History (Sessions table, grouped by Client): Group by the Client linked field. When you open a client's profile before their session, you see every previous session with your notes.

Airtable vs Notion for Client Records

Both tools work. The choice comes down to how you think about your data.

Many practitioners use both: Airtable for structured data (who, when, what type, payment status) and Notion for the narrative session notes, where they want to paste an image of the spread, write freely, and organize by theme. The two tools link together loosely - you keep the Notion page URL in an Airtable "Notes URL" field.

Source: jotform.com/blog/airtable-vs-notion/ (2026)

For a detailed side-by-side of Notion vs Airtable for knowledge management broadly, see Notion vs Airtable comparison.

Privacy and Client Data

Date of birth, session notes, and personal topics discussed in a reading are sensitive data. Keep this in mind:

- Airtable workspaces are private by default - only accounts you invite can see the data.
- Don't share Airtable views with clients directly unless you've removed sensitive columns from that view.
- In the EU, storing personal data about EU residents in Airtable (a US company) has GDPR implications. Airtable offers a Data Processing Addendum (DPA) for paying plans. For serious GDPR compliance, consult protect client data for readings.
- Use a strong unique password for your Airtable account and enable two-factor authentication.

Getting Started in One Hour

1. Create a free Airtable account at airtable.com.
2. Create a new base called "Client Database".
3. Rename the default table to "Clients" and set up the columns listed above.
4. Add a second table "Sessions" with its columns.
5. Add a third table "Payments" with its columns.
6. In the Sessions table, add a "Linked record" field pointing to Clients. In Payments, add one pointing to Sessions.
7. Create the four views described above.
8. Enter your last 10 clients and their most recent session. The act of entering them cements the structure and surfaces anything the setup is missing for your specific practice.

Frequently Asked Questions

Does Airtable work on mobile for quick session notes?

Yes. Airtable's mobile app (iOS and Android) lets you open a client record and add session notes immediately after a session ends. Tap the client record, open the linked Sessions table, add a new row, and type while the details are fresh. The app is functional for data entry; it's not as comfortable as the desktop version for building views or formulas, but for on-the-go note capture it works.

Can I send payment reminders through Airtable?

Not natively. Airtable is a database, not a communication tool. You can use the Pending Payments view to see who owes you, then send the reminder manually via email or DM. For automated payment reminder emails, connect Airtable to a tool like Zapier: when a payment record status is "Pending" for more than 48 hours, trigger an email via your email provider. That Zapier connection adds cost depending on your plan.

What's the difference between Airtable and a CRM like Dubsado?

A dedicated CRM like Dubsado includes client portals, automated email sequences, contract signing, and invoicing built in. Airtable is a database tool - flexible, but you build the structure yourself, and communication and invoicing happen in separate tools. Airtable costs less (free for most solo practitioners). A CRM like Dubsado or HoneyBook costs $35-49/month but replaces multiple tools. See CRM for spiritual practitioners for a full breakdown of the CRM options.

Can I import my existing Excel or Google Sheets client list?

Yes. Airtable imports CSV files directly - File > Import > CSV. Export your existing spreadsheet as CSV, import it into a new Airtable table. You'll need to create the linked record fields manually after import (CSV import creates flat data, not relational links), but your existing client list becomes the starting data for the Clients table in about 10 minutes.

Is 1,000 records on the free tier really enough?

For solo practitioners: yes, for years. Each session becomes one record in the Sessions table. At 4 sessions per week, that's roughly 200 sessions per year. Five years of sessions at that rate is 1,000 records - and that's just the Sessions table. The Clients table and Payments table add more records. In practice, reaching the 1,000-record limit across all tables typically takes 2-4 years of active practice. When you approach the limit, upgrading to Plus is the straightforward move.