Pricing
All integrationsCRM & Sales
Live~2 minutes

Copper → Google Sheets

Import people, companies, leads, opportunities, projects & tasks from Copper CRM

API key · Read-only by default · No data stored

~2 minutesSetup time
API keyAuthentication
15 minMin sync interval
Read-onlyDirection

Capabilities

Everything in the Copper connector

3 built-in capabilities, from live queries to scheduled syncs and AI-powered data analysis.

Technical details

Built for IT teams to approve in one read

Every connection is read-only by default. Credentials are encrypted at rest. Brooked is a verified Google Workspace app.

Authentication
API key
Direction
Read-only

Setup guide

Connect in 3 steps

From install to your first live query in under 5 minutes. No engineering help required.

1

Connect your account

Authorize Brooked to access your Copper data using an API key or token.

2

Choose what to import

Pick from 8 available data types, like People, Companies, Leads.

3

Schedule your sync

Run it once, or set a recurring schedule. Data flows straight into your Google Sheet.

Need help? Visit support →

Use cases

How teams use Copper + Brooked

From finance reporting to real-time operations dashboards, see what your team can build.

Keep Copper data current in Sheets

Automatically sync your crm & sales data from Copper into a Google Sheet on a schedule, so reports and dashboards always reflect what's actually in Copper, no manual exports.

Live in Google Sheets
Copper → Sheets · auto-refresh

Available functions

Query Copper from a cell

Five built-in sheet functions, from natural-language queries to raw SQL and AI-powered KPI cells. No coding required.

fx

=BRKD_QUERY("Copper", "open deals by stage and owner")

Ask a natural-language question against any connected data source. Returns a table of results that spills into adjacent cells.

=BRKD_QUERY("Copper", "open deals by stage and owner")

Also supported

More CRM & Sales integrations

Connect HubSpot to Google Sheets, sync contacts, deals, and CRM data

Connect Salesforce to Google Sheets, sync accounts, opportunities, and pipeline data

Import contacts, deals, tasks, appointments & sales activities from Freshworks CRM

Get your spreadsheet hours back

Brooked sets up in seconds. Your team is querying live data before lunch.

Get started free