Unscheduled Treatment in Open Dental: A Weekly Workflow

Every office has a pile of treatment that was diagnosed, presented, maybe even agreed to, and then never booked. Henry Schein One, which sells practice software, published a 2024 benchmark study from its Jarvis analytics data where the average case acceptance rate was 46%, against 83% for the top 10% of practices. It counts treatment as accepted once it's completed or scheduled, so much of that gap is treatment that never made it onto the schedule.

Open Dental already has the tools to find those patients. The hard part is working the list every week without losing track of who you've called. This walkthrough starts with what's built into Open Dental, then shows how our weekly unscheduled treatment follow-up recipe automates the repetitive part.

Step 1: Know which Open Dental list you're looking at

Open Dental has three places that sound alike, and they're meant for different things. The Appointment Lists page of the Open Dental manual describes them:

Planned Appointment Tracker. Patients with a planned appointment that hasn't been scheduled. The manual says this list "should be long and regularly reviewed."
Unscheduled List. No-shows and cancellations that weren't rescheduled. The manual calls it a "short list" for patients who were no-shows or canceled without rescheduling, and says appointments "should not stay on this list long," and its Unscheduled List page says not to send planned appointments there.
Treatment Finder. A report rather than a list, covered next.

If your team has been using the Unscheduled List for treatment follow-up, that's the first thing to change. It's built for a different job.

Step 2: Run the Treatment Finder report

The Treatment Finder report is under Standard Reports, then Lists. It shows patients with treatment-planned procedures (excluding $0 fees) and no scheduled appointment. By default it assumes a calendar-year insurance benefit.

Filters worth setting:

TP Date From and To, so you're working plans presented in a range, not every plan since the office opened.
Amount remaining over, if you want to start with patients who still have insurance benefits left this year.
Ins Month Start, if your patients' plans don't renew in January.
Providers, Clinics and Billing Type, to split the list between coordinators.

The grid shows each patient's preferred recall contact method, annual maximum, amount used and amount pending. That's enough to prioritize calls, especially late in the benefit year.

Step 3: Decide who calls, and how often

The report gives you names. It doesn't remember what happened last week. Pick one person to own the list, set a day to work it, and record every attempt as a commlog so the next person can see it. An offset of a couple of weeks after a plan is presented gives the patient room to think before anyone calls.

If you want an Open Dental report that's closer to what you need, the Reports page of the manual shows how to add custom report files to Open Dental, using a file named "Unsched Treat Plans.rdl" as its example.

Step 4: Automate the weekly list (optional)

If the manual routine works for your office, stop here. If it keeps slipping, this is where the recipe comes in. Every Monday at 10:00 it does the same lookup, de-duplicates against the previous weeks, and writes a call list to a Google Sheet for your treatment coordinator: patient, planned codes, fee and date presented.

The workflow has 9 nodes. We don't have screenshots yet, so here they are in order from the workflow file:

Every Monday 10:00 (schedule), plus a manual/test run webhook
Open Dental: TP procedures, no future visit
Sheet rows, then Sheet: call list + text ledger
Texts, then Send text (Twilio)
Commlogs, then Open Dental: POST commlogs

Patients drop off the list when they book. Patients who reply or opt out become call-only.

Step 5: Add a text nudge, carefully

The recipe can also text patients who agreed to texts, but it's deliberately limited:

At most two texts per plan, at least 30 days apart, never a third.
The text is generic, along the lines of "you have a follow-up visit to schedule with us," with your phone number and online scheduling link. It never includes the procedure, tooth or fee.
It's under 160 characters and ends with "Reply STOP to opt out."
It shares a frequency limit with our other dental recipes: no more than one automated text in 24 hours and three in seven days, so a patient who just got a missed-call text doesn't get a treatment nudge the same afternoon.
It waits 14 days after a plan is presented before the first text (TP_MIN_AGE_DAYS).

Keeping texts generic is a choice about privacy. We cover the reasoning, and where BAAs come in, in is texting patients HIPAA compliant? That post, and the "HIPAA, TCPA and BAAs" section on the dental hub, are general information, not legal advice. The call list itself contains patient details, so it belongs in a Google Workspace account where you've accepted Google's BAA, shared only with the coordinator.

How we tested it

Our testing notes describe the setup for every recipe. We imported the workflow into n8n 2.45.4 and ran it against a local mock server built from Open Dental's, Twilio's and Google's API documentation. The mock enforces Open Dental's request throttle and records every call. We also compared the mock's field names with Open Dental's public test database, using read-only requests with the test key Open Dental publishes. No real patient data was used and nothing was sent to a real phone. There's no AI model; every decision is a written rule. The last run passed 5 of 5 scenarios:

U1, the first weekly run. Every unbooked plan made the call list. Only patients marked OK for texts got the generic text. Patients with a future visit, inactive patients and plans presented in the last 14 days were skipped.
U2, a week later. Patients whose booked visits had passed while the plan was still open joined the list. Patients who'd already been texted waited out their 30 days.
U3, early December. A patient who booked dropped off. A patient who replied became call-only. Plans that had aged past 14 days got a first text, and the rest got their second.
U4, early January. After two texts, it's call-only. No third text.
U5, shared frequency cap. A patient who got a missed-call text two hours earlier wasn't texted again, and an Open Dental rate-limit reply was waited out and retried.

The thing we got wrong along the way wasn't in the workflow. An early version of our setup notes treated a community forum reply about n8n Cloud and BAAs as if it came from n8n staff. It came from a volunteer "Top Supporter," not an official n8n statement, and n8n's Trust Center lists GDPR, SOC 2 and SOC 3 but not HIPAA. We rewrote the notes to say that, and the recipe now assumes a self-hosted n8n for patient data.

Mocks can't tell you how your patients respond or how your carrier filters texts. The recipe's setup suggests a first live run with the Twilio node turned off, so you can check the call list before anyone gets a text.

What it costs

The text side is cheap: the recipe page works through an illustrative month with 40 texts at well under a dollar in Twilio fees. The real cost is the Open Dental API. Open Dental's API permissions page lists a free tier that can only read, and a $15-a-month tier that adds the Comm permission this recipe needs to write commlogs. All in, the recipe page estimates about $16 a month plus your n8n server, reusing the Twilio number from the dental missed-call text-back.

Limits to know

It's built for Open Dental only.
It doesn't know when a patient's insurance year resets, so it won't time nudges to benefits. Use the Treatment Finder's insurance filters for that.
It doesn't replace the call. The point is a clean list for a person to work.

All dental automations
Overdue recall reactivation
Insurance verification prep, which helps when patients ask what treatment will cost
Review requests with a response guard
Is a missed-call text-back legal?, which covers TCPA consent and opt-outs for texting
Browse every recipe, or read more posts on the blog

How to work unscheduled treatment in Open Dental