Skip to content

Copper + Snowflake

Copper + Snowflake

Copper + Snowflake integrations

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 CompanyTriggers when a Person's Company is changed.
TriggerInstant
automatically do this!
Create RowsInsert data into a table by specifying the column names and values to insert.
ActionWrite

Start free with email

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 Copper and Snowflake

Discover other triggers and actions you can use with Copper and Snowflake

- Entity Type
  Required
- Activity Type
  Required
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 Type
  Required
- Project Id
  Required
- Source Id
  Required
Action
Write
- Name
  Required
- 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-Mail
  Required
- 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 ID
  Required
- Name
- Primary Contact
- Description
- Assignee
- Status
- Pipeline
- Stage
- Close Date
- Value
- Currency
- Priority
- Win Probability
- Source
- Tags
- Replace or Append to Tags
Action
Write
- Name
  Required
- Primary Contact
  Required
- Description
- Assignee
- Status
- Pipeline
- Stage
- Close Date
- Value
- Currency
- Priority
- Win Probability
- Source
- Tags
- Replace or Append to Tags
Action
Write
- Name
  Required
- Assignee
- Details
- Status
- Tags
Action
Write
- Name
  Required
- Assignee
- Details
- Status
- Tags
- Replace or Append to Tags
Action
Write
- Match by Type
  Required
Action
Search
- Match by Type
  Required
Action
Search
- Match by Type
  Required
Action
Search
- Match by Type
  Required
- Activity Type
  Required
- Activity Date
  Required
- Parent Type
  Required
- Parent Object
  Required
- Acting User
  Required
- Details
  Required
Action
Search or write
- Match by Type
  Required
- Full Name
- Name Prefix
- First Name
- Middle Name
- Last Name
- Name Suffix
- E-Mail
  Required
- Assignee
- Title
- Company
- Contact Type
- Description
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
Action
Search or write
- Match by Type
  Required
- 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
Polling
Try It
New Table
Triggers when a new table is created.
Trigger
Polling
Try It
- Table
  Required
- Columns to Return
- Updated Date Column
  Required
- Primary Key
Trigger
Polling
Try It
- Disclaimer
- Table
  Required
- Primary Key Column
  Required
- Primary Key Values
  Required
Action
Write
- Table
  Required
- Primary Key Column
  Required
- Primary Key Values
  Required
- Column Name
  Required
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 Type
  Required
- Activity Date
  Required
- Parent Type
  Required
- Parent Object
  Required
- Acting User
  Required
- Details
  Required
Action
Write
- Name
  Required
- 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
- Name
  Required
- 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-Mail
  Required
- 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
- Name
  Required
- Primary Contact
  Required
- Description
- Assignee
- Status
- Pipeline
- Stage
- Close Date
- Monetary Value
- Currency
- Priority
- Win Probability
- Source
- Tags
- Replace or Append to Tags
Action
Write
- Name
  Required
- Primary Contact
  Required
- Assignee
- Status
- Description
- Pipeline
- Stage
- Close Date
- Monetary Value
- Currency
- Priority
- Win Probability
- Source
- Tags
Action
Write
- Name
  Required
- Assignee
- Details
- Status
- Tags
- Replace or Append to Tags
Action
Write
- Name
  Required
- Assignee
- Due Date
- Reminder Date
- Description
- Priority
- Tags
- Related Entity Type
- Related Entity Object
Action
Write
- Match by Type
  Required
Action
Search
- Match by Type
  Required
Action
Search
- Match by Type
  Required
Action
Search
- Match by Type
  Required
- Name
  Required
- 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 Type
  Required
- Name
  Required
- Primary Contact
  Required
- Assignee
- Status
- Description
- Pipeline
- Stage
- Close Date
- Monetary Value
- Currency
- Priority
- Win Probability
- Source
- Tags
Action
Search or write
- Match by Type
  Required
- Name
  Required
- Assignee
- Details
- Status
- Tags
Action
Search or write
- SQL Statement
  Required
- Primary Key
Trigger
Polling
Try It
New View
Triggers when a new view is created (from yesterday onwards).
Trigger
Polling
Try It
- Table
  Required
- Column Name
  Required
Action
Write
- SQL Statement
  Required
Action
Write
- Table
  Required
- Column Name
- Where Clause
  Required
Action
Search

About Copper

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

Learn moreLearn moreHelpHelp

Related categories

CRM (Customer Relationship Management)

Similar apps

Capsule CRM

CRM (Customer Relationship Management)

Streak

CRM (Customer Relationship Management)

Insightly

CRM (Customer Relationship Management)

About Snowflake

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

Related categories

Related Zap Templates

Related Zap Templates

Create rows in Snowflake for new companies in Copper

Process new Copper leads by executing Snowflake sqls