Google Drive Integration

The Google Drive integration manages document organization for every deal — creating the standard folder structure, extracting text via OCR, and filing documents per deal within Dora's Deal Operating System.

Folder Structure

All deal documents live under the Dora-Property-Deals top-level folder. Each deal gets a standardized subfolder:


Dora-Property-Deals/
├── {Deal-ID}/
│   ├── Contract/
│   ├── Disclosures/
│   ├── Photos/
│   ├── Reports/
│   └── Communications/
└── ...


Capabilities
OCR Extraction


Uploaded contracts and disclosures are processed with OCR

Extracted text is fed into dispotree as contractOcrData` (JSONB)
Structured data populates deal financials, property details, and compliance fields

File Organization

Automatic folder creation when a new deal is created
Document classification by type (contract, disclosure, photo, report)
Consistent naming conventions across all deals

Deal Attachment

Link uploaded documents to the correct deal record in DispoTree
Provide document URLs back to DispoTree for buyer-facing deal pages
Enable broker and buyer document review without manual file management

Integration Points

dispotree — deal record links directly to Drive folder; OCR data enriches the property model
dora — orchestrates via the google-drive-mvp skill
gmail-integration — email attachments can be auto-saved to deal folders
docuseal — signed documents are archived back to the deal's Drive folder

Architecture

The integration uses the Google Drive API v3 with service account authentication. Folder creation, file upload, OCR triggering, and permission management are handled programmatically. File content extraction uses Google's built-in OCR capabilities on image-based PDFs.