Copper + Smartsheet

Copper + Smartsheet integrations

Create new Copper contacts from Smartsheet rows

Working with spreadsheets and wish you could automatically create new contacts in your CRM right from the sheet? Now with the help of Zapier, you can. With every new row you add to Smartsheet, a contact will automatically be created within Copper.

When this happens...
New RowTriggers when a new row is added.
TriggerPolling
automatically do this!
Update PersonUpdates a Person depending on the match criteria.
ActionWrite

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

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

Get Reports
[PRIVATE] Generates report list for dropdown.
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Select a Report
  Required
Trigger
Polling
Try It
- Workspace Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row
  Required
- Title
  Required
- Comment
  Required
Action
Write

- Source Folder
  Required
- Destination Folder
  Required
- New Folder Name
  Required
Action
Write
- Workspace
  Required
- New Name
  Required
- What to Include?
- Skip Remap
Action
Write

- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Destination
  Required
- Template
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Choose Row
  Required
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a Sheet
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet ID
  Required
- Row ID
  Required
Action
Search
- 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

- Choose a Sheet
  Required
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
Try It
- Sheet
  Required
- Row
  Required
- File Attachment
  Required
Action
Write
- Choose a Sheet
  Required
- Add Row to Top or Bottom
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Sheet
  Required
- Column
  Required
- Parent Row
Action
Write
- Destination
  Required
- Sheet to Copy
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row ID
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Format
  Required
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a Workspace
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row (Legacy)
Find a row in a specified sheet using a query.
Action
Write
- Sheet ID
  Required
- Query
  Required
Action
Search
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

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 Smartsheet

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

HelpHelp

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

Related Zap Templates

Update Smartsheet rows whenever Copper opportunities status changes