Diligence Ingestion: Data Room to Brain Pages
Goal
Turn pitch decks, financial models, and data room materials into searchable, cross-referenced brain pages with bull/bear analysis.What the User Gets
Without this: pitch decks sit in email attachments. Financial models in Google Drive. No cross-reference to the company brain page. You can’t search “what were the key metrics from Acme Corp’s Series A deck?” With this: every data room document is extracted, diarized, cross-referenced to the company page, and searchable. Index.md gives you the bull/bear case at a glance.modusbrain query "Acme Corp revenue growth" finds the exact chart.
Implementation
Recognize data room materials by PDF filenames containing “Data Deck”, “Intro Deck”, “Data Room”, “Cap Table”, “Financial Model”, “Investor Memo”, “Pitch Deck”, or series round names. Spreadsheet tabs with Revenue, Retention, Cohorts, CAC, Gross Margin, Unit Economics, ARR. User language like “data room”, “diligence”, “deck”, “pitch”, “fundraise materials”.The 9-Step Pipeline
Step 1: Identify the Company. From the document content or filename, identify the company name. Check ifbrain/companies/{slug}.md exists.
Step 2: Create Diligence Directory.
- PDFs: Use PDF extraction tool. For scanned/image-heavy PDFs, use OCR (e.g., Mistral OCR or similar).
- Spreadsheets: Export each sheet as CSV. For Google Sheets:
brain/diligence/{company}/{doc-name}.md:
- Document title and type
- Section-by-section breakdown with key metrics
- Notable footnotes or caveats
- Raw data tables where relevant
brain/diligence/{company}/.raw/
Preserve originals for reference. The diarized version is for search.
Step 6: Create or Update index.md.
Every diligence directory needs an index.md:
brain/companies/{slug}.md:
- Add document sources to frontmatter
- Update compiled truth with key findings
- Add “See Also” link to diligence directory
- If no company page exists, create one via the enrich skill
Quality Bar
A good diligence page reads like an intelligence assessment:- What they say vs what the data shows (the gap is the insight)
- Explicit bull/bear case (not just a summary)
- Key metrics highlighted, not buried
- Open questions that need answers before decision
Tricky Spots
-
PDF extraction is lossy. Scanned decks and image-heavy PDFs lose
tables and charts during extraction. Always check the diarized output
against the original
.raw/file. If key metrics are missing, re-extract with OCR or transcribe manually. -
Idempotency on re-ingestion. If the user sends an updated deck for
the same company, don’t create a duplicate directory. Check for an existing
brain/diligence/{company-slug}/and update in place. Append a version suffix to the document file if the old version should be preserved. - index.md completeness. The index.md is the entry point for the entire diligence package. If it’s missing the bull/bear case or open questions, the diligence is incomplete. Always generate all sections even if some require judgment calls — flag uncertain assessments explicitly.
How to Verify
-
Search for key metrics. After ingestion, run
modusbrain search "revenue growth"ormodusbrain search "{company name} CAC". The diarized content should appear in results. If it doesn’t, the sync or embedding step was missed. -
Check the company page cross-reference. Open
brain/companies/{slug}.mdand verify it links to the diligence directory. The compiled truth section should include key findings from the deck. -
Verify index.md has all sections. Open
brain/diligence/{company}/index.mdand confirm it has Round Details, Document Inventory, Key Findings, Bull Case, Bear Case, and Open Questions. Missing sections mean the pipeline stopped early.
Part of the ModusBrain Skillpack.