Skip to content
Back to Blog
How-Toveterinarian

How to Use the Lido MCP to Extract Data from Veterinary Intake Forms

Wire Lido's spreadsheet-OCR engine into Claude via MCP to auto-extract structured data from paper or scanned intake forms, then chain it for client comms in your practice voice.

8 min read

A two-DVM practice ships somewhere between 30 and 60 intake forms a week โ€” new client + new patient flows, annual wellness, surgical pre-ops. Each form is structured-ish data (owner, address, phone, pet name, breed, age, weight, vaccination history, allergy flags) plus narrative ("anything we should know"). Each gets typed into the PIMS by a CSR or tech, line by line.

Lido is the modern spreadsheet + OCR tool that handles document-to-structured-data conversion. Its MCP server wraps the same flow for agentic use: a form arrives in the practice's intake folder, Lido extracts the structured fields, Claude chains the result into client comms in your practice voice.

๐Ÿ’ก The stack. Lido MCP handles the OCR + structured extraction. The AI Cowork Vault Bundle provides the agentic skill layer (no vet-specific vault yet โ€” coming if Tier 2 light products validate). For now, raw Claude + bundle skills like /client-communication work fine. $49 one-time for all 7 vaults if you want the cross-profession workflow toolkit.

What the Lido MCP actually does

Lido's product is a hybrid spreadsheet + document-extraction tool. The MCP exposes:

  • extract_form โ€” given a document (PDF or image), extract structured fields against a template you define
  • extract_table โ€” given a document with tabular data, return rows
  • anomaly_flag โ€” flag fields that don't match the expected pattern (missing required fields, suspicious values)

For veterinary intake, you'd define a template once: owner name, contact info, pet name, breed, sex, DOB, weight, current meds, allergies, prior vet, vaccination records, emergency contact. Lido learns the form layout; future extractions hit it cleanly.

Pre-flight

  • Claude Cowork (desktop) or Claude Code
  • A Lido account โ€” free tier covers ~100 doc extractions/month; paid for higher volume
  • A scanning workflow that lands intake forms in a folder Claude can read (Drive, Dropbox, or local)
  • A defined Lido template matching your intake form

Configure the MCP server

{
  "mcpServers": {
    "lido": {
      "command": "npx",
      "args": ["-y", "@lido/mcp-server"],
      "env": {
        "LIDO_API_KEY": "your-api-key",
        "LIDO_WORKSPACE_ID": "your-workspace-id"
      }
    }
  }
}

Restart Claude. The Lido server appears in connectors. You'll define the template once in Lido's UI; the MCP references it by name.

Run an intake extraction

When an intake form lands in your folder:

Use the Lido MCP to extract structured data from
/intake/2026-05-24-johnson-buddy.pdf

Apply the "veterinary-new-client-v2" template.
Return all fields plus any anomaly flags.

Lido returns the parsed structured data:

Owner: Sarah Johnson
Phone: 555-0188
Email: sjohnson@example.com
Pet: Buddy
Species: Canine
Breed: Mixed (Lab/Golden estimated)
Sex: Male, neutered
DOB: 2021-04-12 (~5 years)
Weight: 67 lbs
Current meds: Heartgard, Bravecto
Allergies: NONE NOTED (free-text says "maybe chicken?")
Prior vet: City Animal Hospital
Vaccination records: ATTACHED (not extracted; route to tech)
Anomaly flag: Allergy field has narrative content; review.

The anomaly flag is the useful part. Lido sees "NONE NOTED" but flags that the free-text section contradicts. A tech reviews; the allergy "maybe chicken" gets recorded properly.

Chain into PIMS-ready format

Most PIMS (Cornerstone, Avimark, ezyVet) have a structured import format. Have Claude convert:

Format the extracted data above for import into ezyVet:
- Owner record: standard fields
- Patient record: standard fields  
- Flag the "maybe chicken" allergy for tech review before import
- Hold the vaccination records page for manual entry (image, not structured)

You get a clean import payload + a one-line note for the tech.

Chain into the new-client welcome email

Draft a new-client welcome email:
Recipient: Sarah Johnson (newclient)
Pet: Buddy (5yo neutered male, mixed breed)
First appointment: [date โ€” pull from intake form's "preferred date"]
Practice voice: warm, modern, not stuffy
Include: parking note, what to bring, our policy on visits without owners present
Compliance: state-specific intake disclosure language [your state]

Out comes the welcome email. Pets-by-name (Buddy, not "your pet"). Practice voice. Appointment logistics. State-required intake disclosure language.

Chain into the post-visit follow-up

After the wellness visit, the same context drives the follow-up:

Draft a post-visit summary email for the Johnson visit today:
Patient: Buddy
Today's exam findings: [DVM dictates 3-5 bullets]
Diagnostics ordered: [e.g., CBC, chem panel โ€” DVM notes]
Plan: [meds, recheck timing]
Owner-facing tone: clear, no jargon, what-it-means-for-Buddy framing

Five-minute follow-up email becomes a 30-second drafting task. The DVM dictates the medical content; the vault renders the owner-facing prose.

What this doesn't do

It doesn't replace your PIMS. The PIMS is still the system of record for medical history.

It doesn't auto-import to PIMS. Most PIMS lack good API surfaces; the structured output is for the tech to paste into the PIMS, not for autoposting.

It doesn't diagnose. Lido extracts text. Claude organizes prose. The DVM diagnoses.

Common failure modes

  • Handwritten fields extract poorly. This is unavoidable on intake forms with handwriting boxes. Redesign forms with checkboxes where possible; route handwritten fields to humans.
  • Vaccination record images aren't OCR'd reliably. They're often photos of paper records, with poor lighting. Route those to tech review; don't try to extract them automatically.
  • Allergy field contradictions. Common pattern: client checks "no allergies" but writes a note in free text. Lido flags these reliably; make tech review of flagged items part of the SOP.
  • Two pets on one intake form. Some forms allow multiple-pet entries. Define a Lido template for the multi-pet case; running the single-pet template on a multi-pet form will extract only the first.

When you'd skip this stack

  • Under 15 intake forms/week. Manual entry is faster than the setup.
  • All-digital intake already. If your clients fill the intake form on a tablet in the lobby (with structured fields) and it auto-imports to your PIMS, you don't need the OCR step. Use the chain-into-welcome / chain-into-follow-up parts only.
  • Mobile / house-call practice. Different workflow; intake happens in the home with paper. Manual entry is the norm.

Sources

AI Cowork Vault7 vaults ยท save $54 vs piecemeal

Save hours every week with the AI Career Lab โ€” All 7 AI Cowork Vaults

All seven profession-specific AI Cowork Vaults โ€” 315 agentic skills total with ambient compliance guards. Works on Claude Cowork + Microsoft 365 Copilot Cowork.

Get all 7 vaults for $49One-time payment ยท Updates free for life

Frequently asked questions

Is this HIPAA-equivalent for pet health data?+

Veterinary medicine isn't covered by HIPAA (HIPAA applies to human PHI). The closest analog is your state's veterinary practice act + general data-protection laws. That said, Lido is SOC 2 Type II and processes documents in-transit with at-rest encryption; combined with sensible data minimization (only request the fields you need), the posture is reasonable. Don't store SSNs of pet owners in intake forms unless you have a billing-or-credit reason; Lido extracts what's there.

Does it work on handwritten forms?+

Yes, with caveats. Structured printed forms get near-perfect extraction. Handwritten sections (allergy notes, prior history) come back at lower accuracy and get flagged for human review. Expect to confirm one in five handwritten extractions. If your intake form has free-text handwriting fields, redesign them as checkboxes where possible.

What's the right way to handle the pet's medical history field?+

Pull the structured part automatically; route the free-text 'tell us about your pet's history' field to a human. Lido extracts both, but the structured part is reliable. The narrative part is where a tech needs to actually read and judge.

By Reviewed by Alex LowePublished May 24, 2026

Related Guides

Get weekly AI tips for your profession

Join thousands of professionals saving hours every week with AI. Free. No spam.