Create or Update Mixpanel Profiles from New HubSpot Contacts

This polling trigger checks HubSpot hourly for contacts created since the previous check. When new contacts are found, the trigger captures {{hubspot.properties.email}}, {{hubspot.properties.firstname}}, {{hubspot.properties.lastname}}, and {{hubspot.createdAt}} (the timestamp when the contact was created in HubSpot). The workflow runs for every new contact added to HubSpot during the polling interval, whether manually entered, imported, or created through forms/integrations.

This step creates or updates a Mixpanel profile using the $set_once operation, which sets properties only if they don't already exist (preserving original values for properties like creation date).

Configuration: You must provide your Mixpanel Project Token during setup—find this in Mixpanel under Project Settings. The profile uses {{hubspot.properties.email}} as the $distinct_id (Mixpanel's unique user identifier). The $set_once array includes three properties: "Email" ({{hubspot.properties.email}}), "First Name, Last Name" (concatenated from {{hubspot.properties.firstname}} and {{hubspot.properties.lastname}}), and "Created At" ({{hubspot.createdAt}}). Using $set_once means if a profile already exists for this email, these initial properties won't be overwritten, preserving the user's original signup data while still ensuring the profile exists.

Note on $set_once: This operation creates the profile if it doesn't exist, or does nothing if it does (preserving existing values). If you want to update profiles with current HubSpot data instead, you'd change this to use a $set operation that overwrites values.