Copper and Google Sheets automations
Copper holds opportunities and companies, and Google Sheets keeps a row for each through “Add New Row to Sheet”.
Set up an automation: when updated opportunity in Copper, update spreadsheet row in Google Sheets
Build itOr have an AI agent work across Copper and Google Sheets: it decides what to do in each on every run, on a schedule or when you ask it in its chat.
Copper and Google Sheets in practice
Used for
Copper holds opportunities and companies, and Google Sheets keeps a row for each through “Add New Row to Sheet”.
Best template
“Updated Opportunity” in Copper, then “Update Spreadsheet Row” in Google Sheets. It keeps one row per deal current as an opportunity changes, instead of piling up copies.
Watch out
“Update Spreadsheet Row” changes an existing row, so the sheet needs a row for the opportunity first.
Copper and Google Sheets templates
Pick one and Captain builds it with you.


When updated opportunity in Copper, update spreadsheet row in Google Sheets
Build this

When new project in Copper, add new row to sheet in Google Sheets
Build this

When new opportunity in Copper, add new row to sheet in Google Sheets
Build this

When new company in Copper, add new row to sheet in Google Sheets
Build this

When new task in Copper, add new row to sheet in Google Sheets
Build this
Copper and Google Sheets triggers and actions
Every one of both apps. A trigger starts the work; actions are the steps.
Triggers
17- New companyTriggers when a new Company is created in Copper.
- New personTriggers when a new Person is created in Copper.
- New opportunityTriggers when a new Opportunity is created in Copper.
- New leadTriggers when a new Lead is created in Copper.
- New projectTriggers when a new project is created in Copper.
- New taskTriggers when a new task is created in Copper.
- Updated companyTriggers when a Person's Company is changed.
- Updated personTriggers when a Person is changed.
- Updated opportunityTriggers when an opportunity is changed.
- Updated leadTriggers when an lead is changed.
- Updated projectTriggers when a project is changed.
- Updated taskTriggers when a task is changed.
- Task deletedTriggers when an existing task is deleted.
- Person deletedTriggers when an existing person is deleted.
- Company deletedTriggers when an existing company is deleted.
- Opportunity deletedTriggers when an existing opportunity is deleted.
- Project deletedTriggers when an existing project is deleted.
No triggers match.
Actions
26- Create projectCreates a new project
- Create personCreates a new person
- Update personUpdates an existing person
- Create companyCreates a new company
- Search companySearches an existing company in copper
- Search for a projectSearches an existing project in copper
- Search for a opportunitySearches an existing opportunity in copper
- Search for a personSearches an existing persson in copper
- Search for a leadSearches an existing lead in copper
- Search for a company [or create]Searches an existing company in copper or creates a company if none is found
- Search for a person [or create]Searches an existing person in copper or creates a new person if none is found.
- Search for a project [or create]Searches an existing project in copper or creates a new one
- Create opportunityCreates a new opportunity
- Create leadCreates a new lead
- Update opportunityUpdates an opportunity based on opportunity Id
- Update projectUpdates an existing project
- Update companyUpdates an existing company
- Search for a opportunity [or create]Searches an existing opportunity in copper or create a new opportunity if none is found.
- Search usersFind users by name or email, with optional page number and page size.
- Get customer sourcesRetrieve customer sources with optional search text, page size, and page number.
- Find contact typesRetrieve contact types and optionally filter by name; supports page size and page number.
- List pipelinesList pipelines with optional search and pagination (search_text, page_size, page_number).
- List tagsList tags with options to search, return names only, sort, and paginate using page size/number.
- Search tasksSearch for tasks with filters (dates, tags, assignees), pagination, and keyword search.
- Search activitiesSearch activities using pagination, search text, parent, date range, activity type, and full-result option.
- List activity typesRetrieve activity types; filter by category, IDs, disabled or interaction flag, search text, and paginate results.
No actions match.
Triggers
1- Row added or updatedRuns when row added or updated
No triggers match.
Actions
23- Update spreadsheet rowUpdate columns in sheet row
- List rows in sheetGet rows from a sheet tab as objects with row numbers. Supports an optional header row, offset/limit paging, and fetching from the last row.
- Delete rowsDelete one or more rows from a specific sheet in a Google Spreadsheet using a row range or row numbers.
- Add new row to sheetRuns as a step in Google Sheets.
- Lookup spreadsheet rowsFind rows in a Google Sheet that match a column value or an advanced filter.
- Copy sheet to spreadsheetCopy a sheet to another file
- Add multiple rowsAdd one or more rows to a specific sheet in a Google Spreadsheet. Provide data column-by-column or paste a JSON array for bulk inserts. If the sheet has no headers, they will be auto-created from your JSON keys.
- Create subsheetAdd a new subsheet to a spreadsheet and optionally set its position and add column headers in the first row.
- Create sheet columnInsert a new column into the specified Google Sheets sheet at the given index (or append to the end) and optionally set its header.
- Get rows from rangeRetrieve rows from sheet range
- Create a spreadsheetCreate a new spreadsheet.
- Find subsheetSearches a sheet in a spreadsheet by name and returns the sheet name, column titles, and number of rows.
- Get row detailsRetrieve values and metadata for a specific row in a spreadsheet sheet.
- Clear spreadsheet rowClears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.
- Create spreadsheet from templateCreate sheet from template
- List spreadsheetsFetch all spreadsheets
- List spreadsheet tabsLists all tabs (sheets) in a spreadsheet and returns the total count.
- Batch update cell valuesUpdate multiple cells at once
- Format spreadsheet rowFormat row font and background
- Add conditional formatting ruleApply conditional formatting to cells in a Google Sheets spreadsheet based on their values
- Update sheet nameRenames an existing sheet (tab) within a Google Spreadsheet to a new name you specify.
- Update multiple rowsUpdate values in one or more rows of a Google Sheet.
- Permanently delete spreadsheetPermanently delete a spreadsheet from Google Drive, including files on shared drives.
No actions match.
Questions about Copper and Google Sheets
What can start a Copper and Google Sheets automation?
“Updated opportunity”, “New project”, “New opportunity”, “New company” and “New task”.
Which other apps work with both Copper and Google Sheets?
CheckFlow, Daftra, Freshsales Classic, Contacts+ and Slack. Each one has templates with Copper and with Google Sheets, so a third app can join the same job.
All Copper integrations · All Google Sheets integrations · Every app, A to Z