When this happens...
Google SheetsNew Spreadsheet Row
Then do this...
Copper[LEGACY] Create Opportunity V1

You can only rely on your CRM as your single source of truth if it's up-to-date! Send your most recent spreadsheet data to Copper as its created with this Google Sheets-Copper integration. When new rows are added to your Google Sheets spreadsheet that tracks, say, contacts interested in buying your product, a new opportunity is created in Copper.

How It Works

  1. A row is added to a Google Sheets spreadsheet
  2. Zapier automatically adds a new opportunity on Copper

What You Need

  • Gmail account
  • Copper account

Why Zapier?


Get started for free—14 day trial of premium features and apps.


No coding required—automate any of 1,500+ apps in minutes.


Enterprise-level security—connect mission-critical apps.

It's easy to connect Copper + Google Sheets and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
Updated Opportunity Status

Triggers when an Opportunity's status is changed.

Update Person

Updates a Person depending on the match criteria.

Updated Opportunity Stage

Triggers when an Opportunity's stage is changed.

Create/Update Lead

Creates or Updates a Lead depending on the match criteria.

New Lead

Triggers when a Lead is created in Copper.

Create Person

Creates a new Person.

New Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

Create Lead

Creates a new Lead.

New or Updated Spreadsheet Row

Triggered when a new row is added or modified in a spreadsheet.

Create Worksheet

Create a blank worksheet with a title. Optionally, provide headers.

Use our free platform to build a single Zapier integration and instantly connect your app with 1,500+ others.

Become a Zapier Integration Partner

Copper is a new kind of productivity CRM that's designed to do all your busywork, so you can focus on building long-lasting business relationships

Learn More

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

See Google Sheets Integrations