Organize Pet Medical Expenses and Prepare Insurance Claim Drafts
Suggested workflow: Import transaction records, match invoices, and generate claim forms and email drafts for pet medical insurance. Task: The system detects veterinary charges from manual NetBank CSV uploads, searches Gmail for matching invoices, and fills insurer PDF claim forms. It stages Gmail drafts for human review and tracks insurer replies through a state machine. The user confirms ambiguous pet assignments or invoice splits, reviews drafts, and manually sends emails; the system never sends automatically.; tools: OpenClaw. Human role: Not stated in the source; limitations: This is a single-household solution requiring manual CSV uploads and OAuth access to Gmail. Sensitive data (bank records, invoices) is stored locally in SQLite. The OpenClaw gateway migration is incomplete, so some processes may not yet run via the new gateway. LLM costs and API rate limits apply to invoice extraction..
Tools
Published on Agent Work Atlas:
Overview
Suggested workflow: Import transaction records, match invoices, and generate claim forms and email drafts for pet medical insurance.
Workflow
The system detects veterinary charges from manual NetBank CSV uploads, searches Gmail for matching invoices, and fills insurer PDF claim forms. It stages Gmail drafts for human review and tracks insurer replies through a state machine. The user confirms ambiguous pet assignments or invoice splits, reviews drafts, and manually sends emails; the system never sends automatically.
Reported result
The author reports processing ten live approval letters where arithmetic checks passed to the cent, but five required human clarification on assessed amounts. Independent verification of reimbursement success or time savings is not provided. The system flags uncertainties rather than guessing, ensuring human oversight on financial claims.
Human role
Not stated in the source
Limitations
This is a single-household solution requiring manual CSV uploads and OAuth access to Gmail. Sensitive data (bank records, invoices) is stored locally in SQLite. The OpenClaw gateway migration is incomplete, so some processes may not yet run via the new gateway. LLM costs and API rate limits apply to invoice extraction.
Try it
Act as a personal assistant for pet insurance claims. I will provide a NetBank CSV file and access to my Gmail account. First, identify veterinary expenses in the CSV. Search my Gmail for matching invoices using merchant names and dates. Extract invoice details using an LLM, handling image scans with OCR if necessary. Fill out the attached insurer PDF claim form with the claimable subtotal (excluding routine care). Create a Gmail draft with the filled form and invoices attached. Do not send the email. If an invoice is missing, draft a request email to the vet but do not send it. If pet assignment is ambiguous, ask me via Telegram or dashboard. I will review all drafts and send them manually. Start with a dry run on one sample transaction to verify matching accuracy before processing the full batch.
Source reports are not independently verified. Publication date is the catalog publication date, not the original article date.