Underwriting email data extraction into CRM

A founder-led capital firm in business finance and lending had years of lender correspondence accumulated and was ready to put that history to work for partner performance analysis and opportunity scoring. This is one angle of the same engagement featured in our named BH Capital Funding case study, where the headline metrics are reported.

Years of lender offer and decline emails sat outside Salesforce, in inboxes nobody could query at scale. Anyone who wanted to understand a lender relationship or score an opportunity was stuck digging through email by hand.

Because the data lived in email rather than the CRM, partner performance analysis and opportunity scoring were effectively blocked. The firm could not see lender relationship history or performance inputs in one place.

The history the firm needed already existed — it was just trapped in an unstructured format. The fix was an extraction pipeline, not a new data-collection effort.

We built an email-to-CRM extraction pipeline that parsed roughly twenty-nine thousand offer and decline emails and bulk-loaded them into Salesforce lender relationship objects as structured records. The ETL turned raw inbox content into data that could be tracked, analyzed, and scored.

Handoff included the extracted records living in the firm's existing Salesforce environment, with documentation so the team could run and rely on it.

Around twenty-nine thousand emails became structured CRM records, and lender relationship history and performance inputs became queryable in-system instead of buried in inboxes. That gave the firm a foundation for partner performance analysis and opportunity scoring.

With lender history now in-system, this extraction became one building block of the firm's broader underwriting and data work with OpsPal.