Sync Stripe Charges to HubSpot Contacts

This workflow automatically syncs customer payment data from Stripe into HubSpot contacts. It collects all Stripe charges, aggregates the total amount captured per customer, and updates (or creates) a HubSpot contact property to store their lifetime spend. The workflow runs on a schedule and ensures no duplicate requests are made to Stripe, while also handling HubSpot field creation if the property doesn’t exist yet.

Features

• 🔄 Automated Sync: Fetches all Stripe charges on a scheduled basis (default: daily at midnight).
• 🧹 Duplicate Handling: Removes duplicate customers to minimize unnecessary Stripe API calls.
• 📊 Data Aggregation: Calculates the total amount captured per customer (in dollars).
• 👤 Customer Enrichment: Retrieves additional Stripe customer details before updating HubSpot.
• 📝 HubSpot Integration: Creates or updates a custom HubSpot property (Stripe - Total Spend) for each contact.
• ⚙️ Configurable: Easily adjust HubSpot property ID, label, and field creation checks.
• 🚫 Error Handling: Skips field checking and handles “no customer assigned” charges gracefully.