Deal to Onboarding Document Automation
How a finance firm automated WorkDrive folder creation and document filing from Zoho CRM, with folder naming and document routing pulled from live Account data.
Client details generalized to protect confidentiality.
Firms whose client documents accumulate in inconsistently named folders, especially where signed agreements need to be found years later.
The Challenge
Client folders were created by whoever onboarded the client, named however they preferred. Contacts, deal documents, and signed agreements ended up in whichever folder was open at the time. Finding a signed engagement letter for a client onboarded two years earlier meant searching by partial name across a shared drive and hoping the right person still worked there.
The Solution
Folder Creation on Account Creation
The folder structure is created the moment an Account exists, so there is never a window where documents have nowhere correct to go.
- Trigger on Account create
- Folder tree from a defined template
- Named from live Account fields
- Folder ID stored on the Account
Document Routing by Type
Contact, deal, and agreement documents route to their own subfolder rather than landing in one flat directory.
- Subfolders by document category
- Routing rules by record type
- Naming applied at file level
- Destination resolved by stored folder ID
Signed Agreement Filing
Documents completed in Zoho Sign file themselves into the right subfolder with the executed date in the name.
- Sign completion event triggers filing
- Executed date included in file name
- Link written back to the Deal
- Original retained on regeneration
Naming From Live Account Data
Names are derived from current Account fields, so the convention holds even when a client name changes.
- Single naming function for folders and files
- Normalization of client names
- Rename on Account name change
- Raw and normalized values both retained
Apps in This Solution
Zoho CRM
Zoho WorkDrive
Zoho Sign
Under the Hood Technical detail
- Trigger Point
- Folder creation fires on Account create rather than at first document, because the gap between those two moments is exactly when documents get misfiled. Creating a few unused folders is cheaper than any misfiling.
- Folder ID Storage
- The folder identifier is stored on the Account so later filing resolves the destination directly. Searching by folder name breaks the first time a client is renamed, which happens more often in finance than elsewhere.
- Naming Function
- One function produces both folder and file names, so the pattern cannot diverge between them. Client name normalization is centralized there, with the raw value retained separately for display.
- Sign Integration
- Filing is driven by the Sign completion event rather than a scheduled sweep, so the executed document is in place before anyone looks for it. A sweep introduces a window where the document exists but is unfiled.
- Notable Constraint
- Documents still arrive by email. A monitored intake folder holds unfiled items and the weekly review of that folder is a deliberate manual step, rather than pretending every path is automated.
The Results
- Every client has the same folder structure from the day the Account exists.
- Signed agreements file themselves with the executed date in the name.
- Finding a document no longer depends on who handled the onboarding.
Client Documents Hard to Find?
We have built document automation for finance, legal, and real estate firms. Tell us how your files are organized today.