Intercom + PostgreSQL + Front Integrations
How to connect Intercom + PostgreSQL + Front
Zapier lets you send info between Intercom, PostgreSQL, and Front automatically—no code required.
Do even more with Intercom + PostgreSQL + Front
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Intercom, PostgreSQL, and Front. And don’t forget that you can add more apps and actions to create complex workflows.
Lead Added Email
Triggers when a Lead enters an email address.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Lead
Triggers when a new Lead is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Which Tag?
If left blank, we'll trigger on every tag.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Closed Conversation
Triggers when you close a conversation. (Note: The "Reply and close" button won't trigger this. You must reply and then close the conversation separately).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New User
Triggers when a new user is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Unsubscription
Triggers when a user unsubscribes from Intercom.io emails.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.EmailRequired
Event NameRequired
The name of the event that occurred. This is presented to your App’s admins when filtering and creating segments. For example,
updated-plan.Metadata
Limited to max 5 key/value pairs.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CompanyRequired
Select a company to tag. You can also select Custom Value from the dropdown to search for a company by the
Company ID.Tag NameRequired
You can also select Custom Value from the dropdown and add a tag name. If a tag with a matching name doesn't exist, a new one will be created automatically.
Untag?
If
Yesis selected, the tag will be removed from the Company.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
Specify the user you would like to tag or untag.
Tag NameRequired
You can also select Custom Value from the dropdown and add a tag name. If a tag with a matching name doesn't exist, a new one will be created automatically.
Untag?
If
Yesis selected, the tag will be removed from the User.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead ID
The "ID" value from a previous search step. If no ID is provided, a new Lead will be created. (Note: this is different from the "user_id" value).
Full Name
Email
The email you want to assign to the lead.
Phone Number
The phone number you want to assign the lead.
Unsubscribed From Emails
Created At
If you want the current datetime to be used, try entering "now".
IP Address
An ip address (e.g. “1.2.3.4”) representing the last ip address the user visited your application from. (Used for updating location_data).
Custom Attributes
Key/value pairs containing any other data about the user you want Intercom to store.
Field names must not contain Periods (‘.’) or Dollar (‘$’) characters. .
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
Custom Attributes
Key/value pairs containing any other data about the user you want Intercom to store.
Created At
If you want the current datetime to be used, try entering "now".
User ID
A unique string identifier for the user.
Full Name
IP Address
An ip address (e.g. “1.2.3.4”) representing the last ip address the user visited your application from. (Used for updating location_data).
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search ModeRequired
Which value would you like to search by? You can use the company
NameorCompany ID(which returns the most recent result).Search ValueRequired
Put your desired search value here. (e.g. If it's the company name, make sure the Search Mode is set to name)..
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ModeRequired
Which value would you like to search by? You can use an
Email,ID, orUser ID(which returns the most recent result).Search ValueRequired
Put your desired search value here. (e.g. If it's an email, make sure the Search Mode is set to email).
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ModeRequired
Which value would you like to search by? You can use the company
NameorCompany ID(which returns the most recent result).Search ValueRequired
Put your desired search value here. (e.g. If it's the company name, make sure the Search Mode is set to name)..
Company NameRequired
Monthly Revenue
How much revenue the company generates for your business each month.
Plan
The name of the plan you have associated with the company.
Custom Attributes
Key/value pairs containing any other data about the user you want Intercom to store.
Field names must not contain Periods (‘.’) or Dollar (‘$’) characters.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundQueryRequired
Query results must have a unique
idfield so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTable/ViewRequired
Primary KeyRequired
Usually something auto-incremented like
id. Must be unique. Column names that contain a space must be enclosed within brackets[ ].Order ByRequired
Usually something like
date_updatedorlast_modified. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.Trigger Column
Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTableRequired
ID ColumnRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.QueryRequired
You should include desired ordering and limiting (usually to 1 record) in the query.
This query must run in less than ~30 seconds.
ActionThis is an event a Zap performs.SearchFind existing data in your appTeam
The Team that this Zap should be added to.
RuleRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Team
The Team that this Zap should be added to.
Inboxes
List of the inboxes the conversation is sent from. Specifying no inboxes will trigger the event for every outbound messages.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Conversation IDRequired
The conversation for which to post a comment.
AuthorRequired
The teammate who should be the author of this comment.
BodyRequired
Plain text body of the comment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Conversation IDRequired
ID of the conversation to reply to. This value should start with "cnv_".
Teammate
The teammate to assign the conversation to. Leave blank to unassign the conversation.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Team
The ID of the team the contact should be associated to.
Name
Description
Short description.
Email Addresses
List of the contact's email addresses.
Phone Numbers
List of the contact's phone numbers. Each phone number must be in the format "+# (###) ###-####", with spaces after the country code and area code.
Links
List of URLs (website, social media profile, ...).
Groups
List of the group names the contact belongs to. If a group doesn't exist in Front, it will automatically be created.
Picture
Picture of the contact.
Custom Attributes
Custom attributes of the Account. A mapping of the Custom Field name to Custom Attribute is expected. For example: "Job title": "CEO"
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Conversation IDRequired
The ID of the conversation to create a draft reply for. Should look like "cnv_1234"
Author
To
List of the recipient handles to draft the message to.
Cc
List of the recipient handles to cc on the draft.
Bcc
List of the recipient handles to bcc on the draft.
Subject
Subject of the draft message.
BodyRequired
Body of the message. Accepts plain text or HTML.
Sharing
Whether to share the draft when creating it. If the draft is not shared, it will only be visible to the author. If it is shared, it will be visible to all teammates with access to the conversation.
Channel IDRequired
Channel for which the draft should be created.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Conversation IDRequired
ID of the conversation, e.g.
cnv_abc123
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Link IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ChannelRequired
Channel through which the message will be sent.
Sender Name
Sender's name.
ToRequired
List of the recipient handles to send the message to.
Cc
List of the recipient handles who will receive a copy of the message (for email messages only).
BCC
List of the recipient handles who will receive a blind copy of the message (for email only).
Subject
Subject of the message.
BodyRequired
Body of the message. Accepts plain text or HTML.
Attachment
File to attach to the message.
Author
Specifying an author will send the message on behalf of this teammate.
Archive the Conversation
Whether or not to archive the newly created conversation.
Tags
List of the tag names that will be added to the newly created conversation.
Tag IDs
List of Tag IDs.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Account IDRequired
ID of the Account to be updated.
Name
New name of the Account
Description
New description of the Account
Email Domains
New email domain(s) of the Account. All email domains that this account should have should be provided.
Custom Attributes
A mapping of the Custom Field name to value is expected. Only Custom Attributes that should be added or updated need to be included. The custom field name must match an account custom field created in Front (case sensitive).
For example: "Job title": "CEO"
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Inbox
Inbox to move the conversation to.
Conversation IDRequired
Assignee
Teammate to assign the conversation to.
Status
Tags
List of all the tags to apply to the conversation.
This list will entirely replace the conversation tags meaning that new tags will be added and missing ones will be removed.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email Domain
Email domain of the Account
External ID
External ID of the Account
Account ID
ID of the Account to be retrieved
ActionThis is an event a Zap performs.SearchFind existing data in your appEmail Domain
Email domain of the Account
External ID
An optional unique identifier for this Account, usually from another data source like a CRM or internal system.
Account ID
ID of the Account to be retrieved
Account NameRequired
Name of the Account to be created
Description
Description of the Account to be created
Email Domains
Email domain(s) of the account to be created (ex. acme.com). Contacts with matching email domains will be automatically associated with this account.
Custom Attributes
A mapping of the Custom Field name to value is expected. For example: "Job title": "CEO". The custom field name must match an account custom field created in Front (case sensitive).
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Lead Converted to User
Triggers when a lead converts to a user.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Which Tag?
If left blank, we'll trigger on every tag.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Conversation
Triggers when a new conversation is created by a user in Intercom.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Company
Triggers when a new Company is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Which Tag?
If left blank, we'll trigger on every tag.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.EmailRequired
The email address of the user you wish to add a note to.
Note TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.From EmailRequired
Message BodyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
Specify the lead you would like to tag or untag.
Tag NameRequired
Attach a tag to a specific lead.
Untag?
If
Yesis selected, the tag will be removed from the Lead.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CompanyRequired
Monthly Revenue
How much revenue the company generates for your business each month.
Plan
The name of the plan you have associated with the company.
Custom Attributes
Key/value pairs containing any other data about the user you want Intercom to store.
Field names must not contain Periods (‘.’) or Dollar (‘$’) characters.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lookup EmailRequired
We will use this email and the User ID below, if provided, to look up the user in Intercom.io and update information from the fields below. If both email and User ID are provided, both must match an existing record for it to be found. If the user does not exist yet, we will create the user.
Full Name
User ID
A unique string identifier for the user. If provided, used as part of the search for existing users. If the User ID does not match the existing record with the email address specified above, a new user record will be created.
Company
Associates the user with a company in Intercom.
Unsubscribed From Emails
Phone Number
The phone number of the user.
Created At
If you want the current datetime to be used, try entering "now".
IP Address
An ip address (e.g. “1.2.3.4”) representing the last ip address the user visited your application from. (Used for updating location_data).
Custom Attributes
Key/value pairs containing any other data about the user you want Intercom to store.
Field names must not contain Periods (‘.’) or Dollar (‘$’) characters.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Intercom are located here https://developers.intercom.com/reference
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search ModeRequired
Which value would you like to search by? You can use an
ID,Email, orUser ID(which returns the most recent result).Search ValueRequired
Put your desired search value here. (e.g. If it's an email, make sure the Search Mode is set to email).
ActionThis is an event a Zap performs.SearchFind existing data in your appCompany NameRequired
Enter the name of the company you're trying to find.
Monthly Revenue
How much revenue the company generates for your business each month.
Plan
The name of the plan you have associated with the company.
Custom Attributes
Key/value pairs containing any other data about the user you want Intercom to store.
Field names must not contain Periods (‘.’) or Dollar (‘$’) characters.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch ModeRequired
Which value would you like to search by? You can use an
ID,Email, orUser ID(which returns the most recent result).Search ValueRequired
Put your desired search value here. (e.g. If it's an email, make sure the Search Mode is set to email).
Lead ID
The "ID" value from a previous search step. If no ID is provided, a new Lead will be created. (Note: this is different from the "user_id" value).
Full Name
Email
The email you want to assign to the lead.
Phone Number
The phone number you want to assign the lead.
Unsubscribed From Emails
Created At
If you want the current datetime to be used, try entering "now".
IP Address
An ip address (e.g. “1.2.3.4”) representing the last ip address the user visited your application from. (Used for updating location_data).
Custom Attributes
Key/value pairs containing any other data about the user you want Intercom to store.
Field names must not contain Periods (‘.’) or Dollar (‘$’) characters. .
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundTable/ViewRequired
We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.
Order By
Highly recommended! Usually you want the results to be most recent first so we can skim off only new results, so choose something like
date_createdor your autoincrementid. Column names that contain a space must be enclosed within brackets[ ].Dedupe Key
We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan
New Table
Triggered when you add a new table.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TableRequired
Lookup ColumnRequired
Lookup ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appTeam
The Team that this Zap should be added to.
Inboxes
List of the inboxes the conversation must be in. Leave this empty if you would like to have this Zap trigger on all inboxes.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Team
The Team that this Zap should be added to.
Inboxes
List of the inboxes the conversation is received in. Specifying no inboxes will trigger the event for every incoming message.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Team
The Team that this Zap should be added to.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Conversation IDRequired
Links External URLsRequired
External URLs of the Links to add to the Conversation (e.g.
https://example.com/ORD-1234). If a Link already exists with a matching URL, that Link will be added. If not, a new Link will automatically be created.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Account NameRequired
Name of the Account to be created
Description
Description of the Account to be created
Email Domains
Email domain(s) of the account to be created (ex. acme.com). Contacts with matching email domains will be automatically associated with this account.
External ID
An optional unique identifier for this Account, usually from another data source like a CRM or internal system.
Custom Attributes
A mapping of the Custom Field name to value is expected. For example: "Job title": "CEO". The custom field name must match an account custom field created in Front (case sensitive).
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Channel IDRequired
Channel for which the draft should be created.
AuthorRequired
Teammate on behalf of whom the draft will be created.
To
List of the recipient handles to draft the message to.
cc
List of the recipient handles to cc on the draft.
bcc
List of the recipient handles to bcc on the draft.
Subject
Subject of the draft message
BodyRequired
Body of the message. Accepts plain text or HTML.
Sharing
Whether to share the draft when creating it. If the draft is not shared, it will only be visible to the author. If it is shared, it will be visible to all teammates with access to the conversation.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
A display name for this LInk
External URLRequired
The identifying URL of the Link, usually pointing to a task/item/loan/shipment etc. in an external system. E.g.
https://example.com/ORD-1234
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.InboxRequired
Inbox into which the message will be imported.
Sender Name
Name of the contact.
Sender HandleRequired
Can be an email address or a phone number.
Sender Handle TypeRequired
ToRequired
List of the recipients the message has been sent to.
Subject
Body Format
Set the format of the message body. The message body can be written in HTML or Markdown.
BodyRequired
Body of the message.
DateRequired
Date of the message.
Attachment
File to attach to the message.
External IDRequired
Unique identifier for the message. Duplicated external ID won't be imported.
Message Type
Message Direction
Select "Inbound" if the message is received or "Outbound" if the message is sent.
Author
Teammate sending the message (Ignored if the message is inbound).
Is ArchivedRequired
Whether or not the message should be directly archived once imported.
Should Skip RulesRequired
Select "Skip Rules" if you want Front to skip applying rules to this message, or "Apply Rules" if you want Front to apply rules to this message.
Thread Reference
Messages with the same thread reference will be grouped in the same conversation.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Conversation IDRequired
Link IDsRequired
IDs of the Links to remove from the Conversation (e.g. "top_123").
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Conversation IDRequired
ID of the conversation to reply to. This value should start with "cnv_". Best if used with a Front message trigger.
To
List of the recipient handles who will receive this reply. By default Front will use the recipients of the last received message.
Cc
List of the recipient handles who will receive a copy of this reply. By default Front will use the cc'ed recipients of the last received message.
BCC
List of the recipient handles who will receive a blind copy of this reply.
Subject
Subject of the reply. By default, Front will reuse the subject of the conversation.
BodyRequired
Body of the reply.
Attachment
File to attach to the message.
Channel
Channel through which the reply should be sent. Mandatory only if the conversation has been imported with the API (no channels) or has been received on multiple channels.
Tags
List of the tag names that will be added to the conversation.
Tag IDs
List of Tag IDs.
Archive the Conversation
Whether or not to archive the conversation after sending the reply.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContactRequired
Name
Description
Short description about the contact.
Links
List of URLs (website, social media profile, ...).
Groups
List of the group names the contact belongs to. If a group doesn't exist in Front, it will automatically be created. If the "Remove Contact From Every Group" option is checked, this field is ignored and the contact will not belong to any groups.
Remove Contact From Every Group
Checking this option will make sure the contact does not belong to any group. Checking this option will override the "Groups" field above.
Picture
Picture of the contact.
Custom Attributes
Custom attributes of the Account. A mapping of the Custom Field name to Custom Attribute is expected. IMPORTANT NOTE: ALL custom attributes that you wish to keep on the Contact must be provided. Any custom attributes that currently exist on the Contact that are not provided will be removed.
For example: "Job title": "CEO"
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Link IDRequired
NameRequired
New name of the Link.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Handle SourceRequired
Email or phone number of contact.
HandleRequired
Handle of the contact (email address, phone number, twitter username, ...).
ActionThis is an event a Zap performs.SearchFind existing data in your appHandle SourceRequired
Email or phone number of contact.
HandleRequired
Handle of the contact (email address, phone number, twitter username, ...).
Team
The ID of the team the contact should be associated to.
Name
Description
Short description.
Email Addresses
List of the contact's email addresses.
Phone Numbers
List of the contact's phone numbers. Each phone number must be in the format "+# (###) ###-####", with spaces after the country code and area code.
Links
List of URLs (website, social media profile, ...).
Groups
List of the group names the contact belongs to. If a group doesn't exist in Front, it will automatically be created.
Picture
Picture of the contact.
Custom Attributes
Custom attributes of the Account. A mapping of the Custom Field name to Custom Attribute is expected. For example: "Job title": "CEO"
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Top companies trust Zapier to automate work and free up time
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.
How Intercom + PostgreSQL + Front Integrations Work
- Step 1: Authenticate Intercom, PostgreSQL, and Front.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
About Intercom
Related categories
Similar apps
HubSpot
Marketing Automation
Keap Max Classic
Marketing Automation
Inbound Now
Marketing Automation, WordPress
About PostgreSQL
Related categories
Similar apps
MySQL
Databases
SQL Server
Databases
Amazon Relational Database Services (RDS)
Amazon, Databases
About Front
Related categories
Similar apps
Zendesk
Customer Support
Gmail
Email, Google
Help Scout
Customer SupportGet started for free
You can't add more hours to the day. Zapier is the next best thing.