Live User Data from our Application

Data Hub 💬 RevOps Discussions
6

Hi @SahilBahri this is a great question. I run a PLG company so we have to store a lot of product data in HubSpot as well to trigger marketing journey. We get data from two sources into HubSpot - Mixpanel and Internal Database(PostgreSQL).

We have made use of custom properties under the ‘Contacts’ object where we aggregate a few data points and store them. Based on this we trigger marketing emails and even sales teams use these data points.

Here is our workflow:

  1. Bring data from Mixpanel and Internal Database into Google Sheets. (this is automated)
  2. Clean and aggregate some metrics(We use Appscript to do aggregations, this automatically happens when data comes into the Google Sheet daily)
  3. Push this data back to HubSpot automatically using Superjoin’s HubSpot connector that allows 2-way sync between HubSpot and Google Sheets.

Hope this helps. We don’t know if this is the best solution or not, but this works for us really well!