Sync Copper CRM Data
to Flat Files
& Spreadsheets
Automatically sync your Copper CRM data to cloud storage and spreadsheets with Flatly's no-code, triggerless, turnkey integration service.
About the integration: Copper (formerly ProsperWorks CRM) is a productivity CRM software designed for companies that love G Suite and use solutions such as GMail, Google Calendar, and Google Sheets. Flatly integrates with Copper CRM's official APIs.
Available Datasets
Flatly can sync the following datasets from Copper CRM.
- Activities-Alltime
- Activities-Last X days Date-ranged
- Companies-Alltime Enriched by CustomFieldDefinitions + 2 more records
- Companies-Last X days Date-ranged Enriched by CustomFieldDefinitions + 2 more records
- Companies+Activities-Alltime Combo Enriched by CustomFieldDefinitions + 2 more records
- Companies+Activities-Last X days Combo Date-ranged Enriched by CustomFieldDefinitions + 2 more records
- ContactTypes
- CustomerSources
- CustomFieldDefinitions
- Leads-Alltime Enriched by CustomFieldDefinitions + 3 more records
- Leads-Last X days Date-ranged Enriched by CustomFieldDefinitions + 3 more records
- Leads+Activities-Alltime Combo Enriched by CustomFieldDefinitions + 3 more records
- Leads+Activities-Last X days Combo Date-ranged Enriched by CustomFieldDefinitions + 3 more records
- LeadStatuses
- LossReasons
- Opportunities-Alltime Enriched by CustomFieldDefinitions + 5 more records
- Opportunities-Last X days Date-ranged Enriched by CustomFieldDefinitions + 5 more records
- Opportunities+Companies-Alltime Combo Enriched by CustomFieldDefinitions + 5 more records
- Opportunities+Companies-Last X days Combo Date-ranged Enriched by CustomFieldDefinitions + 5 more records
- People-Alltime Enriched by CustomFieldDefinitions + 2 more records
- People-Last X days Date-ranged Enriched by CustomFieldDefinitions + 2 more records
- People+Activities-Alltime Combo Enriched by CustomFieldDefinitions + 2 more records
- People+Activities-Last X days Combo Date-ranged Enriched by CustomFieldDefinitions + 2 more records
- Pipelines
- PipelineStages
- Projects-Alltime Enriched by CustomFieldDefinitions + 1 more record
- Projects-Last X days Date-ranged Enriched by CustomFieldDefinitions + 1 more record
- Tasks-Alltime Enriched by CustomFieldDefinitions + 1 more record
- Tasks-Last X days Date-ranged Enriched by CustomFieldDefinitions + 1 more record
- Users Enriched by CustomFieldDefinitions
Send Copper CRM data to
Flatly can sync Copper CRM data to any of these destinations.
- Airtable Airtable
- Amazon S3 XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Azure Storage XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Box XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- CSV
- Cloud Storage
- Dropbox XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Excel
- Excel Online XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- FTP XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google BigQuery NDJSON
- Google Cloud Storage XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google Drive Google Sheets (Parsed) Google Sheets (Raw) XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google Looker Studio
- Google Sheets Google Sheets (Parsed) Google Sheets (Raw) XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Looker NDJSON
- Markdown
- Microsoft Power BI
- OneDrive XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- OneDrive for Business XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- SFTP XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- SharePoint XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Smartsheet Smartsheet
- Zoho Sheet Zoho Sheet
Note: Some destinations are aliased, for intents and purposes they are functionally equivalent.
FAQ: Copper CRM
What is unique about this integration?
Custom Field Enrichment
Flatly automatically enriches some fields in some Copper data sets if they contain Custom Fields. Your resulting data will contain extra columns, created by Flatly, which are labeled by a combination of the prefix "flatly_enriched" and a suffix derived from your Custom Field's label. The values under these enriched columns will be useful and interpretable by human users, instead of being identifiers meant for computer programs.
https://support.copper.com/en/articles/8823331-create-edit-and-manage-custom-fields