Copper + Google Sheets
Update Copper opportunities by id when new or updated rows occur in Google Sheets
Keep your Copper app in sync with new updates into your Google Sheets with this handy workflow. Once set up, whenever there's a new or updated row in your Google Sheets, it updates the corresponding opportunity in Copper, ensuring your data is always current. This results in a streamlined process, saving time and reducing chances of oversight. Perfect for those managing large data sets in Copper and Google Sheets.
Keep your Copper app in sync with new updates into your Google Sheets with this handy workflow. Once set up, whenever there's a new or updated row in your Google Sheets, it updates the corresponding opportunity in Copper, ensuring your data is always current. This results in a streamlined process, saving time and reducing chances of oversight. Perfect for those managing large data sets in Copper and Google Sheets.
- When this happens...
New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Update Opportunity by IDUpdates an Opportunity based off of Opportunity ID.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Company
Triggers when a new Company is created in Copper.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Opportunity
Triggers when an Opportunity is created in Copper.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Project
Triggers when a new Project is created in Copper.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Company
Triggers when a Person's Company is changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Person
Triggers when a Person is changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Opportunity Stage
Triggers when an Opportunity's stage is changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Lead Status
Triggers when a Lead's status is changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Project
Triggers when a Project is changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Activity TypeRequired
Activity DateRequired
Parent TypeRequired
Parent ObjectRequired
Acting UserRequired
DetailsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Assignee
E-Mail Domain
Contact Type
Description
Phone Number
Social Profiles
Website
Street
City
State
Zip Code
Country
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Primary ContactRequired
Description
Assignee
Status
Pipeline
Stage
Close Date
Monetary Value
Currency
Priority
Win Probability
Source
Tags
Replace or Append to Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Primary ContactRequired
Assignee
Status
Description
Pipeline
Stage
Close Date
Monetary Value
Currency
Priority
Win Probability
Source
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Assignee
Details
Status
Tags
Replace or Append to Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Assignee
Due Date
Reminder Date
Description
Priority
Tags
Related Entity Type
Related Entity Object
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Match by TypeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appMatch by TypeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appMatch by TypeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appMatch by TypeRequired
Activity TypeRequired
Activity DateRequired
Parent TypeRequired
Parent ObjectRequired
Acting UserRequired
DetailsRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundMatch 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundMatch 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundEntity TypeRequired
Activity TypeRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Person
Triggers when a new Person is created in Copper.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Lead
Triggers when a Lead is created in Copper.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Task
Triggers when a new Task is created in Copper.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Contact Type
Triggers when a Person's Contact Type is changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Opportunity
Triggers when an Opportunity is changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Opportunity Status
Triggers when an Opportunity's status is changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Lead
Triggers when a Lead is changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Task
Triggers when a Task is changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Source TypeRequired
Project IdRequired
Source IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Opportunity IDRequired
Name
Primary Contact
Description
Assignee
Status
Pipeline
Stage
Close Date
Value
Currency
Priority
Win Probability
Source
Tags
Replace or Append to Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Primary ContactRequired
Description
Assignee
Status
Pipeline
Stage
Close Date
Value
Currency
Priority
Win Probability
Source
Tags
Replace or Append to Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Assignee
Details
Status
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Assignee
Details
Status
Tags
Replace or Append to Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Match by TypeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appMatch by TypeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appMatch by TypeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appMatch by TypeRequired
NameRequired
Assignee
E-Mail Domain
Contact Type
Description
Phone Number
Social Profiles
Website
Street
City
State
Zip Code
Country
Tags
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundMatch by TypeRequired
NameRequired
Primary ContactRequired
Assignee
Status
Description
Pipeline
Stage
Close Date
Monetary Value
Currency
Priority
Win Probability
Source
Tags
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundMatch by TypeRequired
NameRequired
Assignee
Details
Status
Tags
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Copper
Copper is a Recommended for Google Workspace CRM that improves productivity and increases visibility across all your customer interactions.
Related categories
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related Zap Templates
- Create Copper leads from new rows on Google Sheets
- Add rows in Google Sheets from new opportunities in Copper
- Create Copper contacts for updated Google Sheets rows
- Create Google Sheet rows for new persons added to Copper
- Create Copper opportunities from new Google Sheets spreadsheet rows
- Create tasks in Copper from updated rows in a Google Sheet
- Create Google Sheet rows for new persons added to Copper
- Create Google Sheet rows for new Copper leads
- Create leads in Copper from new Google Sheets spreadsheet rows
- Update Copper opportunities from new Google Sheets rows
- Create persons in Copper from new spreadsheet rows in Google Sheets
- Create or update Copper persons from new or updated Google Sheets rows
- Update Copper leads when new Google Sheets rows are added
- Create leads in Copper from new or updated Google Sheets rows
- Create projects in Copper from new rows in Google Sheets
- Update Google Sheets rows with updated Copper opportunities
- Create people in Copper from new or updated Google Sheets rows
- Update spreadsheet rows in Google Sheets when new activities occur in Copper
- Create or update Copper companies from new or updated rows in Google Sheets
- Create multiple spreadsheet rows in Google Sheets for new opportunities in Copper
- Create spreadsheet rows in Google Sheets for new projects in Copper
- Create or update Copper leads from new or updated rows in Google Sheets
- Create new persons in Copper for new spreadsheet rows in Google Sheets team drive
- Update persons in Copper when new rows are added in Google Sheets
- Create or update Copper persons with new Google Sheets rows
- Create multiple rows in Google Sheets for new Copper companies
- Update Copper opportunities whenever new or updated rows are present in Google Sheets team drive
- Create Copper opportunities from new or updated rows in Google Sheets
- "link new or updated Google Sheets rows to projects in Copper"
- Create Google Sheets rows for updated opportunities in Copper
- Create spreadsheet rows in Google Sheets for updated persons in Copper
- Create spreadsheet rows in Google Sheets for new companies in Copper
- Create new Copper leads from new rows in your Google Sheets team drive
- Create opportunities in Copper for new or updated rows in Google Sheets team drive
- Create new Google Sheets rows from new Copper activities
Related Zap Templates
- Create Copper leads from new rows on Google Sheets
- Create Google Sheet rows for new persons added to Copper
- Create Google Sheet rows for new persons added to Copper
- Update Copper opportunities from new Google Sheets rows
- Update Copper leads when new Google Sheets rows are added
- Update Google Sheets rows with updated Copper opportunities
- Create or update Copper companies from new or updated rows in Google Sheets
- Create or update Copper leads from new or updated rows in Google Sheets
- Create or update Copper persons with new Google Sheets rows
- Create Copper opportunities from new or updated rows in Google Sheets
- Create spreadsheet rows in Google Sheets for updated persons in Copper
- Create opportunities in Copper for new or updated rows in Google Sheets team drive
- Add rows in Google Sheets from new opportunities in Copper
- Create Copper opportunities from new Google Sheets spreadsheet rows
- Create Google Sheet rows for new Copper leads
- Create persons in Copper from new spreadsheet rows in Google Sheets
- Create leads in Copper from new or updated Google Sheets rows
- Create people in Copper from new or updated Google Sheets rows
- Create multiple spreadsheet rows in Google Sheets for new opportunities in Copper
- Create new persons in Copper for new spreadsheet rows in Google Sheets team drive
- Create multiple rows in Google Sheets for new Copper companies
- "link new or updated Google Sheets rows to projects in Copper"
- Create spreadsheet rows in Google Sheets for new companies in Copper
- Create new Google Sheets rows from new Copper activities
- Create Copper contacts for updated Google Sheets rows
- Create tasks in Copper from updated rows in a Google Sheet
- Create leads in Copper from new Google Sheets spreadsheet rows
- Create or update Copper persons from new or updated Google Sheets rows
- Create projects in Copper from new rows in Google Sheets
- Update spreadsheet rows in Google Sheets when new activities occur in Copper
- Create spreadsheet rows in Google Sheets for new projects in Copper
- Update persons in Copper when new rows are added in Google Sheets
- Update Copper opportunities whenever new or updated rows are present in Google Sheets team drive
- Create Google Sheets rows for updated opportunities in Copper
- Create new Copper leads from new rows in your Google Sheets team drive