N8N HubSpot CRM Automatisering: Sales en Marketing Workflows die Converteren

HubSpot Trigger (Contact Created)
→ Code Node (extract email domain)
→ HTTP Request (Clearbit/Apollo API - bedrijfsdata ophalen)
→ HubSpot Update Contact {
    company: response.company.name,
    jobtitle: response.person.title,
    industry: response.company.industry,
    company_size: response.company.employees,
    linkedin: response.person.linkedin
  }
→ IF Node (enterprise bedrijf?)
  → Slack Alert (#enterprise-leads)

Verrijkt automatisch elk nieuw contact met bedrijfs- en persoonsdata. Bespaart handmatig research.

HubSpot Trigger (Deal Stage Changed)
→ Code Node {
  const stages = {
    'appointmentscheduled': { emoji: '📅', action: 'Meeting gepland' },
    'qualifiedtobuy': { emoji: '✅', action: 'Gekwalificeerd' },
    'presentationscheduled': { emoji: '📊', action: 'Demo ingepland' },
    'decisionmakerboughtin': { emoji: '🤝', action: 'Decision maker akkoord' },
    'contractsent': { emoji: '📝', action: 'Contract verstuurd' },
    'closedwon': { emoji: '🎉', action: 'GEWONNEN!' },
    'closedlost': { emoji: '😔', action: 'Verloren' }
  };
  return stages[$json.dealstage];
}
→ Slack Node (#sales-pipeline)
  "{{emoji}} Deal: {{dealname}} — {{action}}
   Bedrag: €{{amount}} | Owner: {{hubspot_owner_id}}"
→ IF Node (stage === closedwon?)
  → Google Sheets Append (won deals log)
  → Email Node (felicitatie naar sales rep)

Houd een Google Sheet gesynchroniseerd met HubSpot. Handig als het management-team liever in spreadsheets werkt.

// Richting 1: HubSpot → Sheets
HubSpot Trigger (Contact Created/Updated)
→ Google Sheets Lookup (bestaat contact al in sheet?)
→ IF Node
  ├── Nieuw: Google Sheets Append
  └── Bestaand: Google Sheets Update

// Richting 2: Sheets → HubSpot
Schedule Trigger (elke 15 min)
→ Google Sheets Read (rijen met status "Nieuw")
→ Loop Over Items
→ HubSpot Search (bestaat email al?)
→ IF Node
  ├── Nieuw: HubSpot Create Contact
  └── Bestaand: HubSpot Update Contact
→ Google Sheets Update (status → "Gesynchroniseerd")

HubSpot Trigger (Deal Created)
→ Wait Node (2 dagen)
→ HubSpot Read Deal (check: is deal nog in zelfde stage?)
→ IF Node (geen activiteit in 2 dagen?)
  → Email Node {
      To: deal contact email
      Subject: "Even checken: heb je nog vragen over {{dealname}}?"
      Body: Persoonlijke follow-up template
    }
  → HubSpot Update Deal (last_followup_date = nu)
  → Wait Node (5 dagen)
  → ... (herhaal tot max 3 follow-ups)

Schedule Trigger (elke maandag 09:00)
→ HubSpot API (GET /marketing/v1/emails/with-statistics)
→ Code Node {
  // Bereken metrics per campagne
  const campaigns = $json.objects.map(email => ({
    naam: email.name,
    verzonden: email.counters.sent,
    geopend: email.counters.open,
    geklikt: email.counters.click,
    open_rate: (email.counters.open / email.counters.sent * 100).toFixed(1) + '%',
    click_rate: (email.counters.click / email.counters.sent * 100).toFixed(1) + '%'
  }));
  return { campaigns };
}
→ Google Sheets Append (marketing dashboard sheet)
→ Slack Node (#marketing)
  "📊 Wekelijks Email Marketing Rapport:
   Verstuurd: {{totaal_verzonden}} | Open rate: {{gem_open_rate}}
   Beste campagne: {{beste_campagne}} ({{beste_open_rate}} open rate)"

HubSpot Trigger (Form Submission)
→ Code Node (extraheer form fields)
→ HubSpot Search Contact (bestaat al?)
→ IF Node
  ├── Nieuw: HubSpot Create Contact
  └── Bestaand: HubSpot Update Contact
→ HubSpot Create Deal {
    dealname: "{{bedrijf}} — {{type_dienst}}"
    dealstage: "appointmentscheduled"
    amount: geschat_bedrag
    pipeline: "default"
    associations: [contactId]
  }
→ HubSpot Create Task {
    subject: "Bel {{naam}} - formulier ingevuld"
    due_date: morgen
    owner: sales_rep_id
  }
→ Slack #sales ("Nieuwe aanvraag via website!")