Integrating HubSpot with Snowflake in a bi-directional sync enables seamless data flow between the CRM and data warehouse. This setup allows for real-time updates of customer insights, driving better decision-making and personalized marketing.
By syncing data both ways, organizations can enhance CRM functions in HubSpot and leverage Snowflake’s analytics power, ensuring a unified view of business data.
In this blog, let’s explore how to integrate Snowflake with HubSpot in a bi-directional sync.
Prerequisite
- You must have a Snowflake account
- HubSpot Developer account
- Basic Knowledge of SQL
- Basic Knowledge of node.js, and REST APIs
Let’s check out the step-by-step guide.
Step 1: Create HubSpot Private App
- HubSpot->Settings->Integrations->Legacy App->Create Legacy App->Private App
- Enter the name of the app.
- Go to the ‘Scopes’ option, then select the scopes.
- In Webhooks, enter the target URL and click on ‘Create subscription’.
- Click on Create App
- Copy the Private App Access Token
Step 2: Create a table in Snowflake
- Sign in to the Snowflake account.
- In the side panel, click on the + icon
- Choose the Database and schema
- Write the SQL query for creating the table
- Click on the create table button.
Step 3: Create a Node.js project
- Inside the project folder, run these commands in your command prompt: npm init -y and npm install express axios, snowflake-sdk dotenv body-parser
- hubspot-to-snowflake.js (For Hubspot to Snowflake connection)
- snowflake-to-hubspot.js (For Snowflake to Hubspot connection)
- snowflake.js (Snowflake connection helper)
- hubspot.js (HubSpot API helper)
- .env
Step 4: Run the project
- Run node file-name and npx ngrok http 3000 (if running on a local machine/laptop)
Live Demo
Conclusion
Integrating Snowflake with HubSpot in a bi-directional sync ensures real-time data consistency, improving marketing and sales alignment. It enables deeper customer insights and automates data-driven decisions, driving efficiency and scalability across teams.
For organizations using Salesforce alongside HubSpot, this architecture also complements Salesforce integrations and Salesforce AI initiatives by centralizing analytics in Snowflake.
With the right HubSpot Development Services, businesses can extend this setup to unify CRM data, power AI-driven forecasting, and create a truly connected data ecosystem.
No Data Found.
India 
USA
UK
Canada