HubSpot to Snowflake data pipeline diagram
This is a worked example. Wavelength built the diagram below from the description on this page. Nobody drew it by hand.
What was said
New leads come in through HubSpot forms. HubSpot scores each lead. If the score is 60 or higher, the SDR team books a discovery call, otherwise the lead goes into a nurture email sequence. Every night Fivetran syncs HubSpot contacts and deals into Snowflake. dbt models the raw tables into a pipeline mart, and the revenue operations team reads the mart in Tableau.
The diagram
Opens an editable copy you can change by voice or by hand. Free account, no card.
What is in this flow
- Systems: HubSpot Forms, HubSpot, Nurture Email Sequence, Fivetran, dbt and Tableau.
- Data stores: Snowflake.
- People and teams: SDR Team and Revenue Operations Team.
- Decisions: Score >=60?.
- Size: 11 steps and 10 connections.
Mermaid code
Copy this into any Markdown file, GitHub README, or Mermaid Live to render the same flow.
flowchart TD
n1(["New Leads"])
n2{{"HubSpot Forms"}}
n3{{"HubSpot"}}
n4{"Score >=60?"}
n5("SDR Team")
n6{{"Nurture Email Sequence"}}
n7{{"Fivetran"}}
n8[("Snowflake"])
n9{{"dbt"}}
n10("Revenue Operations Team")
n11{{"Tableau"}}
n1 -->|submitted| n2
n2 -->|scores| n3
n3 -->|score| n4
n4 -->|Yes| n5
n4 -->|No| n6
n3 -->|sync nightly| n7
n7 -->|loads contacts & deals| n8
n8 -->|models raw tables| n9
n9 -->|provides mart| n10
n10 -->|reads mart| n11Map your own process
Describe your version out loud, or paste the transcript of a call. Wavelength draws the flow as you talk, and you can edit it by voice, by prompt, or by hand.
Every new account starts with 7 days of Pro. No card needed.
Related
- Flow diagram examples: all 37 worked process and data flow diagrams
- Nightly Events Pipeline template: the editable template, with its steps and the conversation that built it
- Order to cash process: a finance flow example
- Procure to pay process: a procurement flow example
- Employee onboarding: an HR flow example
- Invoice approval workflow: an approval flow example
- Support ticket escalation: a support flow example
- Flowchart template: copy, edit, and make your own
- For business analysts: capture an as-is process in swimlanes
- Live demo: describe a process and see the flow, no account needed