| You get | A proposed field sheet, source references and missing or conflicting values |
|---|---|
| Stays with you | Choosing the authoritative document, checking values and entering records |
| You need | Readable documents you may share and a fixed list of fields to extract |
| Rough cost | Try a few pages with existing AI access; scanning or OCR may add cost |
| Skip it if | A form, existing export or a few manual entries already cover the job |
1What it looks like handed off
You have a request form and an attachment, and need to copy a handful of details into a record. The proposed sheet puts each field beside the exact supporting text, filename and page. You can check the value without searching the whole stack again.
This is extraction from documents into a separate review file. The template guide starts with known values and prepares a document; this job starts with documents and checks the values before they enter a record. It doesn't clean or merge an existing spreadsheet.
| Field and source | Proposed value and review state |
|---|---|
| Business name. Request-A, page 1: “Moss Lane Workshop” | Moss Lane Workshop. Copied; awaiting your check. |
| Requested start date. Request-A, page 1: “10/11/26” | 10/11/26 as written. Date order unknown; ask before normalizing. |
| Reference number. Attachment-B, page 2: unclear scan | Unreadable. No guessed number. |
| Address. Request-A says “14 Pine Road”; Attachment-B says “41 Pine Road” | Conflict. Both passages retained; no chosen address. |
A neat cell can hide uncertainty. Keep the original text separate from any normalized value, with “copied,” “missing,” “unreadable” or “conflict” as the extraction state. Record your review decision separately.
2The job, end to end
- Make copies of documents you're allowed to process. Give each file a stable name and version; retain the originals.
- List the fields you actually need. State the allowed formats, and which source is authoritative for each field if you know.
- Ask the agent to extract the literal value, filename, page and supporting passage. Require a row for every requested field, even when no value is found.
- Keep unreadable text, missing fields and conflicting documents separate. A newer filename alone doesn't establish which document controls.
- Check every field against the original page. Inspect scans visually; the extracted text can have misread a digit or skipped a line.
- Resolve questions with the document owner, save the checked sheet and enter only approved values into your business system.
For a repeating document type, keep the field list and sample review sheet. A recurring agent can prepare the next sheet when files arrive. It should stop when the document layout changes or the required source is absent, rather than copying last week's value.
Start with a fictional document you can read completely. Include a blank field, a blurry reference and two different addresses so you can see whether uncertainty survives extraction.
Google's source guidance for Gemini explains why a citation still needs checking: a cited document may not support the particular value. Apply the same check to each field here.
Try the fictional example
Download the files below. No signup is needed. All names, IDs, dates and documents are made up. The answer key shows the intended review decisions; it is not a measured AI result.
- Instructions and copyable prompt (TXT)
- Request-A (TXT)
- Attachment-B (TXT)
- Fields to extract (CSV)
- Blank review sheet (CSV)
- Answer key (CSV)
Extract the five requested fields, then compare your proposal with the answer key. Keep the ambiguous date, conflicting addresses, unreadable reference and missing email visible. The unreadable marker simulates missing evidence; it does not test OCR.
Start with the instructions, give your existing AI tool the inputs and field rules, and keep the answer key aside until you have a proposal. Open the CSV files in your spreadsheet app. Leave approval fields blank until you have checked the sources.
3What stays with you
- Authority
- You decide which source establishes a value. The agent can point out disagreement, but it doesn't decide which contract, instruction or policy applies.
- Entry and submission
- Keep the first trial away from live-system write access. The agent prepares a file; you enter checked values and approve any submission.
- Interpretation
- Copying a phrase isn't interpreting its legal or insurance meaning. Licensed staff handle policy facts and coverage questions.
- Sharing
- Use only files you may send to your AI provider. Remove private information that isn't needed for the field list. Local files may still be transmitted when processed by a cloud model.
When a field isn't present, the result is “missing.” It mustn't be filled from a similar customer's document or from what the model thinks normally belongs there.
4When it gets something wrong
- A digit changes
- Check identifiers character by character on the original page. Preserve leading zeroes and punctuation where they matter. A plausible number still needs evidence.
- A date gets reversed
- Keep the literal text. Ask which date convention applies before converting an ambiguous date.
- Fields cross between documents
- Keep the document ID on every row. Check that a name from one request hasn't been paired with an address from another.
- A missing field disappears
- Compare the output with your fixed field list. Missing fields need visible rows, not fewer rows.
- A correction doesn't reach the sheet
- Mark the old proposal as superseded and extract from the corrected source. Recheck already entered values before importing anything again.
Keep a versioned source bundle beside the checked sheet. A source reference helps find a mistake; it doesn't prove the value was transcribed accurately or that the document is authoritative.
5What it costs
Begin with a few readable pages and the AI access you already have. File limits and document-processing usage vary by tool. Scanning or optical character recognition (OCR) may be a separate service; check its price and data handling before adding it.
Count the whole job: preparing documents, finding exceptions, checking each value and entering the approved result. Poor scans may leave you with more review work than manual entry. There is no measured time saving claimed here.
Doing it yourself
- Create a short fictional document bundle and a list of required fields. Write down the expected values and exceptions.
- Ask: “Extract each requested field into a review sheet. Include literal text, filename, page, passage and extraction state. Keep missing, unreadable and conflicting values visible. Do not guess, enter records or submit anything.”
- Compare every proposed value with its original page and check that all required fields appear.
- Resolve uncertainty, then save a checked version with the source versions and your review decisions.
- Try a small permitted real bundle. Enter approved values yourself and check the resulting record before relying on it.
6When not to bother
If your source system can export the exact fields you need, start there. If customers can fill a short form instead of sending free-form documents, improve the intake first.
For a few clear values, typing and checking them yourself may be quicker. An AI proposal still needs that check.
If the source is unreadable or its meaning needs professional judgment, ask for a clearer document or the appropriate reviewer. This guide demonstrates no AMS integration, insurance decision or customer outcome.
7Want this running on your own computer?
I'll set it up, and keep it running if you like. On a Mac mini, a Windows PC or Omarchy, with the agent you use or want: OpenClaw, Hermes, Claude Code, Codex or another. Out of the box, it asks before it spends money or sends anything. Tell me about the job and I'll quote it. If a $20 subscription does it, I'll tell you. You keep the computer, the accounts and the setup.
Tyler Mayberry, who runs Cirlet (formerly Animas)
Cirlet sets up assistants and teaches teams at independent insurance agencies nationwide. Monthly live training and lifetime learning-library access are included. Open the team training library.