Hubspot (Destination)

Hubspot (Destination)

You can now sync your database or data warehouse → Hubspot with a simple SQL statement.

image

Steps

  1. Authorize the app.
  2. Write your SQL in the app to obtain the data you want to update/insert. Be sure to include the Id for the record in Hubspot.
  3. Add Parameters for fields that you are adding or updating in Hubspot. You can add a Parameter by typing a variable name in double curly brackets (e.g. {{channel}}) in your query.
  4. After creating your Parameter, it should appear under "Parameters" on the right panel. Change these Parameter types to "Hubspot" and map your SQL field (e.g." u.channel") to the name of that field in Hubspot (e.g. "channel").
image

5. Select Hubspot as the destination and select your object (e.g. Contacts) and operation (e.g. update).

image

6. Run your query and check that the record(s) were updated / created in Hubspot.

7. (Optional) Set a schedule so your updates run automatically!