Intercom + PostgreSQL

Create Intercom api requests from new PostgreSQL rows with custom queries

Boost your communication efficiency by marrying your PostgreSQL database with the Intercom messaging service. Whenever a new row appears in your PostgreSQL via a custom query, this workflow swiftly sends an API request to Intercom. This automation saves you time and ensures your data on both platforms stays up-to-date and accurate, helping you maintain seamless customer interactions.

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!
API Request (Beta)
This is an advanced action which makes a raw HTTP request that includes this integration's authentication.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

- Table/ViewRequired
Trigger
Polling
Try It
- QueryRequired
Trigger
Polling
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
Trigger
Polling
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
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
- EmailRequired
- Note TextRequired
Action
Write
- TitleRequired
- Description
- Body
- AuthorRequired
- State
- Parent Collection
Action
Write
- Event nameRequired
- Created at
- Contact identifier typeRequired
- Metadata
Action
Write
- Ticket typeRequired
- Contact IDRequired
- Company ID
Action
Write
- Conversation IDRequired
- Reply TypeRequired
- Reply BodyRequired
- Attachments
Action
Write
- FromRequired
- ToRequired
- Message TypeRequired
- BodyRequired
- 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 EmailRequired
- Full Name
- User ID
- Company ID
- Unsubscribed From Emails
- Phone Number
- Created At
- IP Address
- Custom Attributes
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Search FieldRequired
- Match TypeRequired
- Conversation Status
- Updated After
- Updated Before
Action
Search
- Search FieldRequired
- Match TypeRequired
- Ticket State
- Updated After
- Updated Before
Action
Search
- Conversation IDRequired
Action
Search
- Search ModeRequired
- Search ValueRequired
- Lead ID
- Full Name
- Email
- Phone Number
- Unsubscribed From Emails
- Created At
- IP Address
- Custom Attributes
Action
Search or write

- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- QueryRequired
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
- UpdatesRequired
- Update sample
Trigger
Instant
Try It
New Unsubscription
Triggers when a user unsubscribes from Intercom.io emails.
Trigger
Instant
Try It
- Contact identifier typeRequired
- Tag selection method
Action
Write
- Contact TypeRequired
- Message BodyRequired
Action
Write
- User Association Note
- CompanyRequired
- Warning
- Name
- Website
- Size
- Monthly Revenue
- Plan
- Industry
- Custom Attributes
Action
Write
- Contact identifier typeRequired
- TagRequired
Action
Write
- Contact Identifier
- Message BodyRequired
Action
Write
- CompanyRequired
- Tag NameRequired
- Untag?
Action
Write
- TicketRequired
- Title
- Description
- State
- Is Open
- Snoozed Until
- Assigned Admin
Action
Write
- EmailRequired
- Custom Attributes
- Created At
- User ID
- Full Name
- IP Address
Action
Write
- Search Mode
- Search Value
Action
Search
- Search ModeRequired
- Search ValueRequired
Action
Search
- Search ModeRequired
- Search ValueRequired
Action
Search
- Search Mode
- Search Value
- User Association Note
- Company NameRequired
- 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 more

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 more

Related categories

Databases

Intercom + PostgreSQL

Create Intercom api requests from new PostgreSQL rows with custom queries

New Column

New Row (Custom Query)

New or Updated Row

Update Row

Find Rows via Custom Query

Lead Added Email

New Lead

Tag Added to Lead

New AI Summary

New Company

New Ticket

Tag Added to Conversation

Updated Contact

Tag Added to User

Add Note

Create Article

Create Data Event

Create Ticket

Reply to Conversation

Send Message to Contact

Create/Update Lead

Create/Update User

API Request (Beta)

Find Conversation

Find Ticket

Retrieve a Conversation

Find or Create Lead

New Row

New Table

New Row

Find Row

Find Row via Custom Query

Lead Converted to User

Contact Replied

New Conversation Rating

New Closed Conversation

New Conversation

New User

Updated Company

Updated Ticket

New Unsubscription

Add Tag to Contact

Create Conversation

Create or Update Company

Remove Tag From Contact

Send Incoming Message

Add/Remove Tag on Company

Update Ticket

Create User

Find Company

Find Lead

Find User

Find or Create Company

About Intercom

Related categories

Similar apps

HubSpot

Inbound Now

About PostgreSQL

Related categories

Similar apps

MySQL

SQL Server

Amazon Relational Database Services (RDS)

Related Zap Templates

Related Zap Templates