Copper + Snowflake

Update rows in Snowflake when companies are updated in Copper

Keep your Snowflake data warehouse up-to-date with company information from Copper by utilizing this automation. Whenever a company is updated in Copper, this workflow will create a new row in your Snowflake table with the most recent information. Stay organized, and ensure your team has access to the latest company data without manual intervention.

When this happens...
Updated Company
Triggers when a Person's Company is changed.
TriggerInstant
automatically do this!
Create Rows
Insert data into a table by specifying the column names and values to insert.
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?

- Entity TypeRequired
- Activity TypeRequired
Trigger
Instant
Try It
New Person
Triggers when a new Person is created in Copper.
Trigger
Instant
Try It
New Lead
Triggers when a Lead is created in Copper.
Trigger
Instant
Try It
New Task
Triggers when a new Task is created in Copper.
Trigger
Instant
Try It
Updated Contact Type
Triggers when a Person's Contact Type is changed.
Trigger
Instant
Try It

Updated Opportunity
Triggers when an Opportunity is changed.
Trigger
Instant
Try It
Updated Opportunity Status
Triggers when an Opportunity's status is changed.
Trigger
Instant
Try It

Updated Lead
Triggers when a Lead is changed.
Trigger
Instant
Try It
Updated Task
Triggers when a Task is changed.
Trigger
Instant
Try It
- Source TypeRequired
- Project IdRequired
- Source IdRequired
Action
Write
- NameRequired
- Assignee
- E-Mail Domain
- Contact Type
- Description
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
- Replace or Append to Tags
Action
Write
- Full Name
- Name Prefix
- First Name
- Middle Name
- Last Name
- Name Suffix
- E-Mail
- Assignee
- Title
- Company
- Contact Type
- Description
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
- Replace or Append to Tags
Action
Write
- Full Name
- Name Prefix
- First Name
- Middle Name
- Last Name
- Name Suffix
- E-MailRequired
- Assignee
- Title
- Company
- Contact Type
- Description
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
Action
Write
- Full Name
- First Name
- Middle Name
- Last Name
- Name Prefix
- Name Suffix
- E-Mail
- Assignee
- Status
- Company
- Title
- Description
- Value
- Currency
- Customer Source
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
- Replace or Append to Tags
Action
Write
- Opportunity IDRequired
- Name
- Primary Contact
- Description
- Assignee
- Status
- Pipeline
- Stage
- Close Date
- Value
- Currency
- Priority
- Win Probability
- Source
- Tags
- Replace or Append to Tags
Action
Write
- NameRequired
- Primary ContactRequired
- Description
- Assignee
- Status
- Pipeline
- Stage
- Close Date
- Value
- Currency
- Priority
- Win Probability
- Source
- Tags
- Replace or Append to Tags
Action
Write
- NameRequired
- Assignee
- Details
- Status
- Tags
Action
Write
- NameRequired
- Assignee
- Details
- Status
- Tags
- Replace or Append to Tags
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Match by TypeRequired
Action
Search
- Match by TypeRequired
Action
Search
- Match by TypeRequired
Action
Search
- Match by TypeRequired
- NameRequired
- Assignee
- E-Mail Domain
- Contact Type
- Description
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
Action
Search or write
- Match by TypeRequired
- NameRequired
- Primary ContactRequired
- Assignee
- Status
- Description
- Pipeline
- Stage
- Close Date
- Monetary Value
- Currency
- Priority
- Win Probability
- Source
- Tags
Action
Search or write
- Match by TypeRequired
- NameRequired
- Assignee
- Details
- Status
- Tags
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

New Company
Triggers when a new Company is created in Copper.
Trigger
Instant
Try It
New Opportunity
Triggers when an Opportunity is created in Copper.
Trigger
Instant
Try It
New Project
Triggers when a new Project is created in Copper.
Trigger
Instant
Try It
Updated Company
Triggers when a Person's Company is changed.
Trigger
Instant
Try It
Updated Person
Triggers when a Person is changed.
Trigger
Instant
Try It
Updated Opportunity Stage
Triggers when an Opportunity's stage is changed.
Trigger
Instant
Try It
Updated Lead Status
Triggers when a Lead's status is changed.
Trigger
Instant
Try It
Updated Project
Triggers when a Project is changed.
Trigger
Instant
Try It
- Activity TypeRequired
- Activity DateRequired
- Parent TypeRequired
- Parent ObjectRequired
- Acting UserRequired
- DetailsRequired
Action
Write
- NameRequired
- Assignee
- E-Mail Domain
- Contact Type
- Description
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
- Replace or Append to Tags
Action
Write
- NameRequired
- Assignee
- E-Mail Domain
- Contact Type
- Description
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
Action
Write
- Full Name
- Name Prefix
- First Name
- Middle Name
- Last Name
- Name Suffix
- E-MailRequired
- If Person Already Exists
- Assignee
- Title
- Company
- Contact Type
- Description
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
- Replace or Append to Tags
Action
Write
- Full Name
- First Name
- Middle Name
- Last Name
- Name Prefix
- Name Suffix
- E-Mail
- Assignee
- Status
- Company
- Title
- Description
- Monetary Value
- Currency
- Customer Source
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
- Replace or Append to Tags
Action
Write
- Full Name
- First Name
- Middle Name
- Last Name
- Name Prefix
- Name Suffix
- E-Mail
- Assignee
- Status
- Company
- Title
- Description
- Monetary Value
- Currency
- Customer Source
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
Action
Write
- NameRequired
- Primary ContactRequired
- Description
- Assignee
- Status
- Pipeline
- Stage
- Close Date
- Monetary Value
- Currency
- Priority
- Win Probability
- Source
- Tags
- Replace or Append to Tags
Action
Write
- NameRequired
- Primary ContactRequired
- Assignee
- Status
- Description
- Pipeline
- Stage
- Close Date
- Monetary Value
- Currency
- Priority
- Win Probability
- Source
- Tags
Action
Write
- NameRequired
- Assignee
- Details
- Status
- Tags
- Replace or Append to Tags
Action
Write
- NameRequired
- Assignee
- Due Date
- Reminder Date
- Description
- Priority
- Tags
- Related Entity Type
- Related Entity Object
Action
Write
- Match by TypeRequired
Action
Search
- Match by TypeRequired
Action
Search
- Match by TypeRequired
Action
Search
- Match by TypeRequired
- Activity TypeRequired
- Activity DateRequired
- Parent TypeRequired
- Parent ObjectRequired
- Acting UserRequired
- DetailsRequired
Action
Search or write
- Match by TypeRequired
- Full Name
- Name Prefix
- First Name
- Middle Name
- Last Name
- Name Suffix
- E-MailRequired
- Assignee
- Title
- Company
- Contact Type
- Description
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
Action
Search or write
- Match by TypeRequired
- Full Name
- First Name
- Middle Name
- Last Name
- Name Prefix
- Name Suffix
- E-Mail
- Assignee
- Status
- Company
- Title
- Description
- Monetary Value
- Currency
- Customer Source
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
Action
Search or write
- 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

About Copper

Copper is a Recommended for Google Workspace CRM that improves productivity and increases visibility across all your customer interactions.

Learn more Help

Related categories

CRM (Customer Relationship Management)

Similar apps

Highrise

CRM (Customer Relationship Management)

Capsule CRM

CRM (Customer Relationship Management)

Streak

CRM (Customer Relationship Management)

About Snowflake

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

Learn more

Related categories

Databases

PRODUCTS

CAPABILITIES

By team

Copper + Snowflake

Update rows in Snowflake when companies are updated in Copper

New Activity

Activity TypeRequired

New Person

New Lead

New Task

Updated Contact Type

Updated Opportunity

Updated Opportunity Status

Updated Lead

Updated Task

Associate to Project

Source TypeRequired

Project IdRequired

Source IdRequired

Create/Update Company

NameRequired

Assignee

E-Mail Domain

Contact Type

Description

Phone Number

Social Profiles

Website

Street

City

State

Zip Code

Country

Tags

Replace or Append to Tags

Update Person

Full Name

Name Prefix

First Name

Middle Name

Last Name

Name Suffix

E-Mail

Assignee

Title

Company

Contact Type

Description

Phone Number

Social Profiles

Website

Street

City

State

Zip Code

Country

Tags

Replace or Append to Tags

Create Person

Full Name

Name Prefix

First Name

Middle Name

Last Name

Name Suffix

E-MailRequired

Assignee

Title

Company

Contact Type

Description

Phone Number

Social Profiles

Website

Street

City

State

Zip Code

Country

Tags