Webform to CRM Pipeline: Multi-Branch Contact & Deal Creation in Pipedrive via Google Sheets

Problem:

A business was manually transferring webform submissions into Pipedrive — creating contacts, persons, deal holders, and linking records by hand, a repetitive process that introduced data entry errors, delayed pipeline population, and left sales teams waiting for records to appear in their CRM.

Solution:

Built a complex multi-branch Make.com scenario triggered instantly on webform submission, the data flows through Google Sheets for structured capture, searches for existing contact persons to prevent duplicates, then routes through a cascading router that handles six distinct deal configurations: creating contact persons, deal holders (types 1 and 2), linking holders to deals, updating contact persons, and pushing finalized records to Pipedrive CRM at every branch endpoint.

Result:

Eliminated all manual CRM data entry, every webform submission now instantly creates a fully structured Pipedrive record with the correct contact hierarchy, deal associations, and holder linkages, with the sales pipeline populated in real time the moment a form is submitted.