Insurance verification prep 72 hours ahead: eligibility check and front-desk checklist (Open Dental + Stedi)

The problem

Manual verification takes staff time on every visit, and unverified coverage turns into surprise bills and write-offs. The figures below come from an industry index as reported by a vendor.

• CAQH Index figures, as reported in a Colorado Dental Association news piece written by a vendor: about 12 minutes per manual eligibility check, around 24 with follow-up. Source: Colorado Dental Association: study reveals losses to manual and insufficient electronic insurance verification (Dental association news piece written by a vendor CEO, citing the CAQH Index)
• The same piece describes a dental support organisation that could verify only about 30% of patients before their visit. Source: Colorado Dental Association: study reveals losses to manual and insufficient electronic insurance verification (Dental association news piece written by a vendor CEO, citing the CAQH Index)

Who it's for

US dental offices on Open Dental that verify insurance by phone or portal and want the routine checks done before the day they are needed.

Tools and monthly cost

Example month: Illustrative arithmetic. Assume 400 insured visits a month: 400 eligibility checks = 250 x $0.30 + 150 x $0.15 = $97.50 at Stedi's pay-as-you-go rates (re-runs on the same morning don't check again). Open Dental API $15 per location. No texts. About $113 a month plus your n8n server, against roughly 80 staff hours if each check took 12 minutes by hand.

Setup

1. Read the 'HIPAA, TCPA and BAAs' section on the dental hub first. Eligibility responses are PHI: use a Stedi HIPAA account (Stedi's BAA covers HIPAA accounts only) and a BAA-covered n8n server.
2. In Stedi, create a production API key and put it in an n8n credential (STEDI_API_KEY in our mock setup). Map Open Dental carriers to Stedi payer IDs in STEDI_PAYER_MAP (JSON: carrier name or Open Dental ElectID to Stedi payer ID); carriers without a mapping use their ElectID.
3. Set PRACTICE_NAME and PRACTICE_NPI (the billing provider sent to the payer), PRACTICE_TZ, VERIFY_DAYS_AHEAD (default 3) and LOW_MAX_REMAINING (default $300).
4. Give the workflow an Open Dental API key with the $15 tier (InsuranceSimple for insverifies, Comm for commlogs).
5. Create the checklist Sheet in BAA-covered Google Workspace and swap the mock sheet URL for n8n's Google Sheets node. Run a week with the Open Dental write disabled and compare the checklist with your own calls. The workflow also has a manual 'run now' webhook used by our tests. Delete it, or put it behind n8n's header authentication, before you go live.

Download

Download dental-insurance-verification-prep.zip

Contains the n8n workflow, the mock data, the test runner with its last results, and the mock server we tested against. All keys in .env.example are fake.

Test result

Every workflow was imported into n8n 2.45.4 and run end to end on our test machine. Open Dental's API, Twilio, Stedi, Google Sheets and the email sender (Resend) were replaced by a local mock server built from their official API docs: it checks the same request shapes and required fields, enforces Open Dental's request throttle (HTTP 429) and records every call. We also compared the mock's field names with Open Dental's public test database (read-only GET requests with the test key Open Dental publishes, no writes). These recipes use no AI model; every decision is a written rule. Patients, plans and phone numbers are invented. Verified with mocks; no real patient data used, and nothing was sent to a real phone, patient, payer or account.

Actual output from the test run

Checklist rows written in scenario I1 (invented patients and plans; member IDs show the last 4 digits only). Names and numbers are invented.

[
 {
  "appointment": "2026-11-05 09:00",
  "patient": "Ana Lopez",
  "PatNum": 101,
  "plan": "Primary: Delta Dental (fictional plan) / Lakeside Schools",
  "member": "...0001",
  "subscriber": "self",
  "status": "Active",
  "deductible_left": "$50",
  "annual_max_left": "$1,210",
  "coinsurance": "preventive 0%, basic 20%, endo 20%, crowns 50%",
  "flags": "",
  "next_step": "None - verified"
 },
 {
  "appointment": "2026-11-05 10:00",
  "patient": "Carla Nguyen",
  "PatNum": 103,
  "plan": "Primary: MetLife Dental (fictional plan) / Rivet Manufacturing",
  "member": "...2033",
  "subscriber": "self",
  "status": "Active",
  "deductible_left": "$0",
  "annual_max_left": "$120",
  "coinsurance": "preventive 0%, basic 20%, endo 50%, crowns 50%",
  "flags": "Only $120 of the annual maximum left",
  "next_step": "Review the estimate with the patient at check-in"
 },
 {
  "appointment": "2026-11-05 11:00",
  "patient": "Erin Walsh",
  "PatNum": 105,
  "plan": "Primary: Cigna Dental (fictional plan) / County Employees",
  "member": "...1005",
  "subscriber": "self",
  "status": "Inactive",
  "deductible_left": "",
  "annual_max_left": "",
  "coinsurance": "",
  "flags": "Coverage not active",
  "next_step": "Call the patient before the visit (new plan? self-pay?)"
 },
 {
  "appointment": "2026-11-05 13:00",
  "patient": "Grace Kim",
  "PatNum": 107,
  "plan": "Primary: MetLife Dental (fictional plan) / Rivet Manufacturing",
  "member": "...510X",
  "subscriber": "self",
  "status": "Payer error 72",
  "deductible_left": "",
  "annual_max_left": "",
  "coinsurance": "",
  "flags": "Invalid/Missing Subscriber/Insured ID - Check the member ID on the insurance card.",
  "next_step": "Ask the patient for the card / call (800)555-0102"
 },
 {
  "appointment": "2026-11-05 14:00",
  "patient": "Iris Chen",
  "PatNum": 109,
  "plan": "none on file",
  "status": "No insurance on file",
  "flags": "Confirm self-pay or ask for a card at check-in",
  "next_step": "Front desk"
 }
]