How to Build a OneDrive File Hub in Notion (Without Downloading Files Every Time)
Learn how to build an OneDrive file hub in Notion using a linked database — no file downloads, just direct OneDrive access from inside your Notion workspace.
PracticePanther to Notion: Zapier sync for law firms
Learn a simple, one-way Zapier setup to sync PracticePanther clients, matters, invoices, and payments into Notion, with rollups that track AR without manual work.
TABLE OF CONTENTS
If your firm uses PracticePanther to run matters and billing, and Notion to track operations, you can reduce manual admin work significantly. PracticePanther already has a native Zapier integration that fires on new clients, matters, invoices, and payments.
This guide shows a reliable pattern that keeps PracticePanther as the source of truth while letting Notion handle dashboards and reporting. The integration runs through Zapier — no custom code or middleware required.
Quick answer (what to build)
Build two Zaps:
- Zap 1: New/Updated Client or Matter in PracticePanther → Create/Update record in Notion
- Zap 2: New Invoice + New Payment in PracticePanther → Create records in Notion → Roll up balances in Notion
The key is to avoid “math in Zapier”. Instead, write raw invoice and payment rows into Notion, then let Notion calculate the balance.
Why one-way sync wins (and avoids weirdness)
Two-way sync sounds nice, but it can get confusing fast.
- Billing systems need strict integrity.
- Notion is great for flexible reporting and dashboards.
A one-way approach keeps data clean:
- PracticePanther owns billing and client records.
- Notion owns views, dashboards, rollups, and internal workflows.
The database model in Notion (simple and scalable)
Create (or confirm) these Notion databases:
- Clients
- Matters (related to Clients)
- Invoices (related to Clients and optionally Matters)
- Payments (related to Clients and optionally Matters)
The most important field: PracticePanther Client ID
Add a text property on the Notion Clients database:
- PracticePanther Client ID (text)
Use this to match records reliably even if names change or are typo’d.
Zap 1: Sync clients
Trigger: New Client (PracticePanther)
Actions:
- Find Client in Notion by PracticePanther Client ID
- If found: Update Client
- If not found: Create Client
Fields to store (recommended):
- Client name
- PracticePanther client link
- Client ID
- Status (optional)
Zap 1b: Sync matters
Trigger: New Matter (PracticePanther)
Actions:
- Find the related Client in Notion (by Client ID)
- Create Matter in Notion
- Relate Matter → Client
Fields to store (recommended):
- Matter name
- Matter ID (text)
- Client relation
- Link back to PracticePanther
Zap 2: Sync invoices and payments (the AR pattern)
A. Invoices
Trigger: New Invoice (PracticePanther)
Actions:
- Find the Client in Notion (by Client ID)
- Create an Invoice row in Notion
Invoice fields to capture:
- Invoice date
- Invoice number
- Invoice total
- PracticePanther invoice link
- Client relation
B. Payments
Trigger: New Payment (PracticePanther)
Actions:
- Find the Client in Notion
- Create a Payment row in Notion
Payment fields to capture:
- Payment date
- Payment amount
- Reference or payment ID
- Client relation
C. Balance calculation (in Notion)
On the Clients database:
- Roll up Total Invoiced from Invoices
- Roll up Total Paid from Payments
- Add a formula: AR Balance = Total Invoiced - Total Paid
This handles partial payments and multiple invoices naturally.
Common pitfalls (and how to avoid them)
- Using name matching instead of IDs: Always match on PracticePanther IDs.
- Trying to update a single “balance” number directly in Zapier: Store invoice/payment rows and roll up.
- Not storing source links: Save PracticePanther record links so you can quickly audit issues.
Suggested extensions once the basics work
- Sync “New Note” or “New Email” to a communications log in Notion.
- Add a simple “Client health” formula or status based on overdue invoices.
- Add reminders or internal task templates in Notion for billing follow-ups.
FAQ
Can we store invoice PDFs in Notion?
You can, but it usually adds work and storage complexity. Most teams are better off storing:
- invoice number
- total
- and a link back to PracticePanther
Can this be two-way?
It can, but it is harder to make safe. Start with one-way.
Get help building this
Building the PracticePanther to Notion sync above usually breaks at the AR calculation step — when teams try to store a running balance in Zapier instead of writing raw invoice and payment rows into Notion for rollup. If you've hit that wall, book a ZoomFlow session — one of our consultants can debug it with you live and ship the working version in the same call.
Related Posts
Custom CRM vs. Off-the-Shelf: What a Zapier Automation Consultant Actually Recommends
A Zapier automation consultant breaks down when to build a custom CRM vs. buy off-the-shelf, and how to fill every gap with smart automations.
Airtable Payment Reminder Calendar with Google Calendar Sync
Build a multi-date Airtable payment reminder calendar for due dates, cancellations, and trip windows, then subscribe via iCal so every deadline appears in Google Calendar—without missed cutoffs.
