HubSpot + PostgreSQL

HubSpot + PostgreSQL integrations

Update HubSpot contacts when new rows are added via custom query in PostgreSQL

Stay on top of your HubSpot contacts with this integration. Whenever a new row appears in your PostgreSQL database according to your custom query condition, the information will be used to update a contact in your HubSpot CRM instantly. This workflow ensures all your HubSpot data matches with your PostgreSQL database, saving time and reducing manual data entry mistakes.

When this happens...
New Row (Custom Query)Triggers when new rows are returned from a custom query that you provide. Advanced Users Only.
TriggerPolling
automatically do this!
Update ContactUpdate a Contact in HubSpot.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with PostgreSQL and HubSpot

Discover other triggers and actions you can use with PostgreSQL and HubSpot

- 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
- Table
  Required
- ID Column
  Required
Action
Write
- Query
  Required
Action
Search

- 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 Email
  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 Email
  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
- 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
- Order_by
- Dedupe_key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- Table
  Required
Action
Write
- Table
  Required
- Lookup Column
  Required
- Lookup_value
  Required
Action
Search
- 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

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 PostgreSQL

PostgreSQL is a powerful, open-source database engine with a uniquely advanced query optimizer and dozens of built in features, making it an easy choice for production databases.

Learn moreLearn moreHelpHelp

Related categories

Databases

Premium

Similar apps

MySQL

Databases

SQL Server

Databases

Amazon Relational Database Services (RDS)

Amazon, Databases

HubSpot + PostgreSQL

HubSpot + PostgreSQL

Update HubSpot contacts when new rows are added via custom query in PostgreSQL

More things you can do with PostgreSQL and HubSpot

Related Zap Templates

Related Zap Templates