Connect HubSpot and SQL Server to power AI-driven automation

No-code AI automation
Full audit trails and controls
SOC 2 and GDPR compliant
Easy visual workflow builder
9,000+ apps, 450+ AI tools
Free tier available

Choose a Trigger

Choose an Action

Launch your first automated workflow

Start with a template that brings HubSpot and SQL Server together. Build enterprise-grade automation in minutes.

Our most popular template

Create new HubSpot contacts from new SQL Server rows
Premium
Details
Try it
SQL Server + HubSpot
Add new rows to SQL Server for new HubSpot form submissions
Premium
Details
Try it
HubSpot + SQL Server
Add updated HubSpot contacts to rows in SQL Server
Premium
Details
Try it
HubSpot + SQL Server
Create HubSpot deals from new SQL Server rows
Premium
Details
Try it
SQL Server + HubSpot
Add new HubSpot engagements to SQL Server as rows
Premium
Details
Try it
HubSpot + SQL Server
Add new SQL Server rows to HubSpot contact lists
Premium
Details
Try it
SQL Server + HubSpot

Create new HubSpot contacts from new SQL Server rows

Details

Try it

SQL Server + HubSpot

Add new rows to SQL Server for new HubSpot form submissions

Details

Try it

HubSpot + SQL Server

Add updated HubSpot contacts to rows in SQL Server

Details

Try it

HubSpot + SQL Server

Create HubSpot deals from new SQL Server rows

Details

Try it

SQL Server + HubSpot

Add new HubSpot engagements to SQL Server as rows

Details

Try it

HubSpot + SQL Server

Add new SQL Server rows to HubSpot contact lists

Details

Try it

SQL Server + HubSpot

Add new HubSpot contacts to SQL Server as rows effortlessly
Premium
Details
Try it
HubSpot + SQL Server
Add new or updated SQL Server rows to HubSpot contact workflow
Premium
Details
Try it
SQL Server + HubSpot

Top companies trust Zapier to automate work that solves their unique business problems—no coding required.

How Zapier works

Zapier makes it easy to integrate HubSpot with SQL Server - no code necessary. See how you can get setup in minutes.

100%

Help

1. Choose trigger event

2. Choose action

1. Select the event

Setup

Test

App

Trigger event

Choose a trigger event

Choose a trigger

A trigger is the event that starts your Zap—like a "New Company" from HubSpot.

Add your action

An action happens after the trigger—such as "Create Custom Query" in SQL Server.

You’re connected!

Zapier seamlessly connects HubSpot and SQL Server, automating your workflow.

Supported triggers and actions

Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.

- Note
- Additional properties to retrieve
Trigger
Polling
Try It
- Object Type
  Required
- Properties to Retrieve
Trigger
Polling
Try It
- Note
- Additional properties to retrieve
Trigger
Polling
Try It
- Note
- Additional properties to retrieve
Trigger
Polling
Try It
- Event Type
Trigger
Polling
Try It

- Type
Trigger
Polling
Try It
- Note
- Additional properties to retrieve
Trigger
Polling
Try It

- Blog Url
  Required
- Article State
  Required
Trigger
Polling
Try It
New Deal
Triggers when a new Deal is created.
Trigger
Instant
Try It
- Property Name
  Required
- Properties to retrieve
  Required
Trigger
Polling
Try It
- Note
- Additional properties to retrieve
Trigger
Polling
Try It
- Object Type
  Required
- Property Name
  Required
- Additional Properties to Retrieve
Trigger
Polling
Try It
- Property Name
  Required
- Note
- Additional properties to retrieve
Trigger
Instant
Try It
- Note
- Note
- Additional properties to retrieve
Trigger
Polling
Try It
- Note
- List Name
  Required
- Contact
  Required
- Halt my task if contact is already a member of the list
Action
Write
Create Company
Creates a Company in HubSpot.
Action
Write
Create Associations
Creates associations between objects.
Action
Write
- Note
- Halt task if any associations error occurred
- Engagement Type
  Required
- Assigned To
Action
Write
- Note
- Social Media Channel
  Required
- Message Content
  Required
- When
- Save as draft
Action
Write
- Note
- Note
- Name
  Required
- Company
- Contact
Action
Write
Delete CRM Object
Deletes a CRM object from HubSpot
Action
Write
- Company ID
  Required
- Note
- Additional properties to retrieve
Action
Write
- Type of Custom Object
  Required
Action
Write
- Note
Action
Write
- Product ID
  Required
- Note
- Additional properties to retrieve
Action
Write
Create Line_item
Creates a Line_item in HubSpot.
Action
Write
- Note
- Contact Email Address
  Required
- Event ID
  Required
- Contact Value
Action
Write
Get CRM Object
Gets a CRM object from HubSpot by ID
Action
Write
- Note
- List Name
  Required
- Contact
  Required
- Halt my task if contact wasn't a member of the list
  Required
Action
Write
Create Ticket
Creates a Ticket in HubSpot.
Action
Write
Update Contact
Update a Contact in HubSpot.
Action
Write
Update Line_item
Update a Line_item in HubSpot.
Action
Write
Update Product
Update a Product in HubSpot.
Action
Write
- Type of Custom Object
  Required
Action
Write
- Folder
  Required
- Filename
  Required
- Access level
  Required
- File
  Required
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Note
- Name
  Required
Action
Search
- Note
- Additional properties to retrieve
Action
Search
- Note
- Name
  Required
Action
Search
Find Associations
Find associations between objects.
Action
Search
- Object Type
  Required
- Pipeline Id
  Required
- Stage Id
  Required
Action
Search
- Note
- Additional properties to retrieve
Action
Search
- Note
- Additional properties to retrieve
Action
Search
- Note
- Additional properties to retrieve
Action
Search or write
- Type of Custom Object
  Required
Action
Search or write
- Note
- Additional properties to retrieve
Action
Search or write
- Note
- Additional properties to retrieve
Action
Search or write
- Table/View
  Required
Trigger
Polling
Try It
- Query
  Required
Trigger
Polling
Try It
- Table/View
  Required
- Primary_key
  Required
- Order_by
  Required
- Trigger_column
Trigger
Polling
Try It
- DisclaimerCopy
- Query
  Required
Action
Write
- Table
  Required
- ID Column
  Required
Action
Write
- Query
  Required
Action
Search

- Note
- Additional properties to retrieve
Trigger
Polling
Try It
- Note
- Additional properties to retrieve
Trigger
Polling
Try It
- Note
- Additional properties to retrieve
Trigger
Polling
Try It
- Property Name
  Required
Trigger
Instant
Try It
Email Subscriptions Timeline
Triggers when new email timeline subscription added for the portal.
Trigger
Polling
Try It
- Form
  Required
Trigger
Instant
Try It
- Contact List
  Required
- Note
- Additional properties to retrieve
Trigger
Instant
Try It
- Type of Custom Object
  Required
Trigger
Instant
Try It
- Channel
  Required
- Status
Trigger
Polling
Try It
- Note
- Additional properties to retrieve
Trigger
Polling
Try It
- Object Type
  Required
- Properties to Retrieve
Trigger
Polling
Try It
- Property Name
  Required
Trigger
Polling
Try It
- Type of Custom Object
  Required
Trigger
Instant
Try It
- Note
- Contact Email
  Required
- Subscription Types
  Required
- Legal Basis Explanation
Action
Write
- Note
- Name
  Required
Action
Write
Create Contact
Creates a Contact in HubSpot.
Action
Write
Create CRM Object
Creates a CRM object in HubSpot
Action
Write
- Note
- List Name
  Required
- Object Type
  Required
- Processing Type
  Required
- Folder ID
Action
Write
- Type of Custom Object
  Required
Action
Write
Create Deal
Creates a Deal in HubSpot.
Action
Write
- Note
- Workflow Name
  Required
- Contact's Email
  Required
Action
Write
- Contact ID
  Required
- Note
- Additional properties to retrieve
Action
Write
- Deal ID
  Required
- Note
- Additional properties to retrieve
Action
Write
- Line_item ID
  Required
- Note
- Additional properties to retrieve
Action
Write
- Ticket ID
  Required
- Note
- Additional properties to retrieve
Action
Write
- Note
- Blog URL
  Required
- Blog Author
  Required
- Publish This Post?
  Required
- Blog Post URL
  Required
- Blog Post Title
  Required
- Blog Post Content
  Required
- Meta Description
  Required
- Featured image URL
Action
Write
Create Product
Creates a Product in HubSpot.
Action
Write
Remove Associations
Removes associations between objects.
Action
Write
- Note
- Form
  Required
- Note
- HubSpot usertoken
- IP address
- Page name
- Page URI
- Page ID
- SFDC campaign ID
- GoToWebinar key/ID
- Submission timestamp
- Skip validation
Action
Write
Update Company
Update a Company in HubSpot.
Action
Write
Update Deal
Update a Deal in HubSpot.
Action
Write
Update CRM Object
Updates a CRM object in HubSpot
Action
Write
Update Ticket
Update a Ticket in HubSpot.
Action
Write
- Note
- Email
  Required
Action
Write
- Note
- Note
- Contact Email
  Required
Action
Write
Find CRM Object
Finds CRM objects by searching with filters
Action
Search
- Note
- Additional properties to retrieve
Action
Search
- Type of Custom Object
  Required
Action
Search
- Note
- Additional properties to retrieve
Action
Search
- Owner email
  Required
- Search among deactivated owners
Action
Search
- Owner Id
  Required
- Search among deactivated owners
Action
Search
- Note
- Additional properties to retrieve
Action
Search
- Note
- Name
  Required
Action
Search or write
- Note
- Additional properties to retrieve
Action
Search or write
- Note
- Name
  Required
- Note
- Company
- Contact
Action
Search or write
- Note
- Additional properties to retrieve
Action
Search or write
- Note
- Additional properties to retrieve
Action
Search or write
- Table/View
  Required
- Order_by
- Dedupe_key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- Query
  Required
Trigger
Polling
Try It
- Table
  Required
Action
Write
- Table
  Required
- Lookup Column
  Required
- Lookup_value
  Required
Action
Search
- Query
  Required
Action
Search

For AI agents & developers

Use HubSpot and SQL Server with AI agents and code

Beyond Zap workflows. Call HubSpot and SQL Server actions directly from your AI client or your codebase, using the same 9,000+ app integrations Zapier already runs.

No code

Connect via Zapier MCP

Expose HubSpot and SQL Server actions as tools in any MCP client. Authenticate once, then call them in natural language.

Example actions on this page

Update Contact Subscription Preferences
Create Custom Query

Works with

Claude · ChatGPT · Cursor · any MCP-compatible client

Connect Zapier MCP

Typescript

Call from code with the Zapier SDK

Trigger HubSpot and SQL Server actions from backend services, scripts, or agent code.

Install

# TypeScript / Node
npm install @zapier/zapier-sdk

Run an action

import { createZapierSdk } from '@zapier/zapier-sdk';

const zapier = createZapierSdk();
await zapier.runAction({ /* hubspot / sql-server action */ });

Run the SDK docs

There is no Python package yet. SDK is TypeScript-only (@zapier/zapier-sdk). The MCP server URL is personal to your account; get it at zapier.com/mcp.

Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023

G2 Badge - Most Implementable - Winter 2024

G2 Badge - Leader Mid-Market - Winter 2024

93%

Customers who say using Zapier has made them better at their job

25m

Customers have created over 25 million Zaps on the platform

6 mins

The average user takes less than 6 minutes to set up a Zap

Practical ways you can use HubSpot and SQL Server

Track new leads in SQL Server.

When a new contact is created in HubSpot, Zapier will add a new row in your SQL Server database. This improves lead tracking and ensures business owners have a comprehensive, up-to-date view of potential clients.

Business Owner

Try it

Sync database changes with HubSpot.

When a row is added or updated in SQL Server, Zapier updates the corresponding company record in HubSpot. This ensures your CRM always reflects the latest database changes, saving time on manual updates and preventing data inconsistency.

Try it

Log form submissions to SQL Server for better analysis.

When a new form submission is received in HubSpot, Zapier automatically adds the data as a new row in SQL Server. This creates a centralized data source for analyzing marketing campaign performance over time.

Marketing & Marketing Ops

Try it

Learn how to automate HubSpot on the Zapier blog

Learn how to automate SQL Server on the Zapier blog

Make work flow with AI

Level up your HubSpot to SQL Server integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.

Learn about AI automation

Frequently Asked Questions about HubSpot + SQL Server integrations

New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with HubSpot and SQL Server

What is needed to connect HubSpot with SQL Server?

To connect HubSpot with SQL Server, you'll need access to both accounts. Ensure your HubSpot API key or OAuth token is on hand, while for SQL Server, you should have the connection string details like server name, database name, and authentication credentials.

How can triggers be set up in the integration between HubSpot and SQL Server?

You can set up triggers in the integration by specifying an event in HubSpot that initiates an action. For example, a new contact entry in HubSpot could trigger automatic data input into the corresponding table in SQL Server.

What actions can be performed in SQL Server from a HubSpot trigger?

Actions such as inserting new records, updating existing records, or deleting records can be performed in SQL Server. These actions are initiated when specific triggers, like form submissions or contact updates in HubSpot, occur.

Is it possible to update existing entries in SQL Server based on changes in HubSpot?

Yes, it's possible to update existing entries in SQL Server when changes are detected through specific triggers in HubSpot. For example, if a contact's email changes, this can automatically update the corresponding record.

How do we ensure data consistency between HubSpot and SQL Server during integration?

Data consistency is managed by mapping fields accurately and setting conditions under which data transfers occur. We recommend using timestamps or unique identifiers to sync updates both ways effectively.

Can we filter which data gets transferred from HubSpot to SQL Server?

Yes, filtering rules can be applied within the integration setup to transfer only certain types of data from HubSpot based on criteria such as deal stage or contact source.

What should be done if there’s an error during the integration process between HubSpot and SQL Server?

If there's an error during the integration process, checking logs for error messages is a good start. Confirm that all authentication credentials are correct and review trigger-action setups for any misconfigurations.

About HubSpot

HubSpot is your all-in-one stop for all of your marketing software needs.

Learn moreLearn moreHelpHelp

Related categories

Marketing Automation

Similar apps

Inbound Now

Marketing Automation, WordPress

Intercom

Customer Support

Zapier Forms

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

About SQL Server

SQL server (or MS SQL) is a top of the line database geared for the cloud

Learn moreLearn moreHelpHelp

Related categories

Databases

Similar apps

MySQL

Databases

PostgreSQL

Databases

Firebase / Firestore

Databases

Connect HubSpot and SQL Server to power AI-driven automation

Launch your first automated workflow

Create new HubSpot contacts from new SQL Server rows

Add new rows to SQL Server for new HubSpot form submissions

Add updated HubSpot contacts to rows in SQL Server

Create HubSpot deals from new SQL Server rows

Add new HubSpot engagements to SQL Server as rows

Add new SQL Server rows to HubSpot contact lists

Create new HubSpot contacts from new SQL Server rows

Add new rows to SQL Server for new HubSpot form submissions

Add updated HubSpot contacts to rows in SQL Server

Create HubSpot deals from new SQL Server rows

Add new HubSpot engagements to SQL Server as rows

Add new SQL Server rows to HubSpot contact lists

Add new HubSpot contacts to SQL Server as rows effortlessly

Add new or updated SQL Server rows to HubSpot contact workflow

Top companies trust Zapier to automate work that solves their unique business problems—no coding required.

How Zapier works

Choose a trigger

Add your action

You’re connected!

Supported triggers and actions

Use HubSpot and SQL Server with AI agents and code

Connect via Zapier MCP

Call from code with the Zapier SDK

Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023

Practical ways you can use HubSpot and SQL Server

Track new leads in SQL Server.

Sync database changes with HubSpot.

Log form submissions to SQL Server for better analysis.

Learn how to automate HubSpot on the Zapier blog

How to integrate ChatGPT with HubSpot

How to use Zapier's HubSpot Salesforce integration

How to integrate Hubspot with Gmail

Learn how to automate SQL Server on the Zapier blog

5 ways to automate SQL Server with Zapier

Make work flow with AI

Frequently Asked Questions about HubSpot + SQL Server integrations

Connect HubSpot to SQL Server on the world's largest no-code automation platform