Intercom + Snowflake

Manage new or updated Snowflake rows by adding or removing tags on Intercom users

Keep your user data in sync between Snowflake and Intercom with this handy workflow. Whenever a new or updated row is detected in Snowflake, this sets off a process that updates user information in Intercom, making sure to add or remove tags as necessary. This automation eliminates the need for manual updates, maintaining streamlined and efficient communications with your users.

When this happens...
New or Updated Row
Triggers when a row is either created or updated.
TriggerScheduled
automatically do this!
Add/Remove Tag on User
Attach or remove a tag on a specific user.
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

What does this mean?

- The table to look for new columns on.Required
Trigger
Scheduled
Try It
New Table
Triggers when a new table is created.
Trigger
Scheduled
Try It
- TableRequired
- Column NameRequired
Action
Write
- SQL StatementRequired
Action
Write
- TableRequired
- Column Name
- Where ClauseRequired
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

- 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 Contact
Triggers when a Contact is updated in Intercom.
Trigger
Instant
Try It
- Which Tag?
Trigger
Instant
Try It
- EmailRequired
- Note TextRequired
Action
Write
- Event nameRequired
- Created at
- Contact identifier typeRequired
- Metadata
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
- CompanyRequired
- Monthly Revenue
- Plan
- 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
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- 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
- Search ModeRequired
- Search ValueRequired
- Lead ID
- Full Name
- Email
- Phone Number
- Unsubscribed From Emails
- Created At
- IP Address
- Custom Attributes
Action
Search or write

- SQL StatementRequired
- Primary Key
Trigger
Scheduled
Try It
- TableRequired
- Columns to Return
- Updated Date ColumnRequired
- Primary Key
Trigger
Scheduled
Try It
- Disclaimer
- TableRequired
- Primary Key ColumnRequired
- Primary Key ValuesRequired
Action
Write
- TableRequired
- Primary Key ColumnRequired
- Primary Key ValuesRequired
- Column NameRequired
Action
Write
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 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
- 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
- TagRequired
Action
Write
- Contact identifier typeRequired
- TagRequired
Action
Write
- Contact Identifier
- Message BodyRequired
Action
Write
- CompanyRequired
- Tag NameRequired
- Untag?
Action
Write
- Lead ID
- Full Name
- Email
- Phone Number
- Unsubscribed From Emails
- Created At
- IP Address
- Custom Attributes
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
- 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 Help

Related categories

Customer Support

Similar apps

HubSpot

Marketing Automation

Inbound Now

Marketing Automation, WordPress

About Snowflake

Snowflake allows corporate users to store and analyze data using cloud-based hardware and software.

Learn more Help

Related categories

Databases

PRODUCTS

CAPABILITIES

By team

Intercom + Snowflake

Manage new or updated Snowflake rows by adding or removing tags on Intercom users

New Column

New Table

Create Rows

TableRequired

Column NameRequired

Execute SQL

SQL StatementRequired

Find Row

TableRequired

Column Name

Where ClauseRequired

Lead Converted to User

Contact Replied

New Closed Conversation

Message body format

New Conversation

New User

Updated Contact

Tag Added to User

Which Tag?

Add Note

EmailRequired

Note TextRequired

Create Data Event

Event nameRequired

Created at

Contact identifier typeRequired

Metadata

Reply to Conversation

Conversation IDRequired

Reply TypeRequired

Reply BodyRequired

Attachments

Send Message to Contact

FromRequired

ToRequired

Message TypeRequired

BodyRequired

Subject

Template

Create Conversation Without Contact Reply?

Update Company

CompanyRequired

Monthly Revenue

Plan

Custom Attributes

Create/Update User

Lookup EmailRequired

Full Name

User ID

Company ID

Unsubscribed From Emails

Phone Number

Created At

IP Address

Custom Attributes

API Request (Beta)

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find Lead

Search ModeRequired

Search ValueRequired

Find or Create Company

Search Mode

Search Value

User Association Note

Company NameRequired

Plan

Size

Website

Industry