Intercom + PostgreSQL

Intercom + PostgreSQL integrations

Create or update Intercom users from new PostgreSQL rows using custom queries

Enhance the management of your Intercom contacts via this convenient workflow. Whenever there's a new row from a custom query in PostgreSQL, it actively creates or updates a user in your Intercom app. This streamlined process ensures your Intercom users' list stays updated and consistent with your PostgreSQL data records for efficient customer communication.

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!
Create/Update UserUpdate a user within Intercom given their e-mail address.
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 Intercom

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

- 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

Lead Added Email
Triggers when a Lead enters an email address.
Trigger
Instant
Try It
New Lead
Triggers when a new Lead is created.
Trigger
Instant
Try It

- Which Tag?
Trigger
Instant
Try It
New AI Summary
Triggers when an AI-generated summary is created for a conversation in Intercom.
Trigger
Instant
Try It
New Company
Triggers when a new Company is created.
Trigger
Instant
Try It
New Ticket
Triggers when a new Ticket is created in Intercom.
Trigger
Instant
Try It
- Tag
Trigger
Instant
Try It
Updated Contact
Triggers when a Contact is updated in Intercom.
Trigger
Instant
Try It
- Which Tag?
Trigger
Instant
Try It
- Email
  Required
- Note Text
  Required
Action
Write
- Title
  Required
- Description
- Body
- Author
  Required
- State
- Parent Collection
Action
Write
- Event name
  Required
- Created at
- Contact identifier type
  Required
- Metadata
Action
Write
- Ticket type
  Required
- Contact ID
  Required
- Company ID
Action
Write
- Conversation ID
  Required
- Reply Type
  Required
- Reply Body
  Required
- Attachments
Action
Write
- From
  Required
- To
  Required
- Message Type
  Required
- Body
  Required
- Subject
- Template
- Create Conversation Without Contact Reply?
Action
Write
- Lead ID
- Full Name
- Email
- Phone Number
- Unsubscribed From Emails
- Created At
- IP Address
- Custom Attributes
Action
Write
- Lookup Email
  Required
- Full Name
- User ID
- Company ID
- Unsubscribed From Emails
- Phone Number
- Created At
- IP Address
- Custom Attributes
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Search Field
  Required
- Match Type
  Required
- Conversation Status
- Updated After
- Updated Before
Action
Search
- Search Field
  Required
- Match Type
  Required
- Ticket State
- Updated After
- Updated Before
Action
Search
- Conversation ID
  Required
Action
Search
- Search Mode
  Required
- Search Value
  Required
- Lead ID
- Full Name
- Email
- Phone Number
- Unsubscribed From Emails
- Created At
- IP Address
- Custom Attributes
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
Lead Converted to User
Triggers when a lead converts to a user.
Trigger
Instant
Try It
Contact Replied
Triggers when a Contact replies to a Conversation in Intercom.
Trigger
Instant
Try It
New Conversation Rating
Triggers when a conversation receives a rating.
Trigger
Instant
Try It
- Message body format
Trigger
Instant
Try It
New Conversation
Triggers when a new Conversation is created by a User in Intercom.
Trigger
Instant
Try It
New User
Triggers when a new User is created.
Trigger
Instant
Try It
Updated Company
Triggers when a company is updated.
Trigger
Instant
Try It
- Updates
  Required
- Update sample
Trigger
Instant
Try It
New Unsubscription
Triggers when a user unsubscribes from Intercom.io emails.
Trigger
Instant
Try It
- Contact identifier type
  Required
- Tag selection method
Action
Write
- Contact Type
  Required
- Message Body
  Required
Action
Write
- User Association Note
- Company
  Required
- Warning
- Name
- Website
- Size
- Monthly Revenue
- Plan
- Industry
- Custom Attributes
Action
Write
- Contact identifier type
  Required
- Tag
  Required
Action
Write
- Contact Identifier
- Message Body
  Required
Action
Write
- Company
  Required
- Tag Name
  Required
- Untag?
Action
Write
- Ticket
  Required
- Title
- Description
- State
- Is Open
- Snoozed Until
- Assigned Admin
Action
Write
- Email
  Required
- Custom Attributes
- Created At
- User ID
- Full Name
- IP Address
Action
Write
- Search Mode
- Search Value
Action
Search
- Search Mode
  Required
- Search Value
  Required
Action
Search
- Search Mode
  Required
- Search Value
  Required
Action
Search
- Search Mode
- Search Value
- User Association Note
- Company Name
  Required
- Plan
- Size
- Website
- Industry
- Custom Attributes
- Monthly Revenue
Action
Search or write

About Intercom

Intercom is the Engagement OS, an open channel between customer and business that is in the product, in the moment, and on their terms. We break down silos, unifying data and systems to create an ongoing dialogue, so companies can make the most of every opportunity.

Learn moreLearn moreHelpHelp

Related categories

Customer Support

Similar apps

HubSpot

Marketing Automation

Inbound Now

Marketing Automation, WordPress

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

Intercom + PostgreSQL

Intercom + PostgreSQL

Create or update Intercom users from new PostgreSQL rows using custom queries

More things you can do with PostgreSQL and Intercom

Related Zap Templates

Related Zap Templates