Skip to content

Copper + Google BigQuery

Copper + Google BigQuery

Copper + Google BigQuery integrations

Create persons in Copper for every new row in Google BigQuery

Simplify your data management with this convenient automation. When new information appears in your Google BigQuery, this workflow swiftly creates a new person record in Copper. Ideal for businesses looking to streamline data transfer and keep all client information systematized and organized.

When this happens...
New RowTriggers when a new row is added to a table. We know when a new row is added whenthe table is sorted by a column and the latest row is different from the previous latest row.
TriggerPolling
automatically do this!
Create PersonCreates a new Person.
ActionWrite

Start free with email

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Google BigQuery and Copper

Discover other triggers and actions you can use with Google BigQuery and Copper

- Project
  Required
- Dataset
- Table
Trigger
Polling
Try It
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
Action
Write
- Project ID
  Required
- SQL Query
  Required
- Location
Action
Write

- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Action
Search

- Entity Type
  Required
- Activity Type
  Required
Trigger
Instant
Try It
New Person
Triggers when a new Person is created in Copper.
Trigger
Instant
Try It
New Lead
Triggers when a Lead is created in Copper.
Trigger
Instant
Try It
New Task
Triggers when a new Task is created in Copper.
Trigger
Instant
Try It
Updated Contact Type
Triggers when a Person's Contact Type is changed.
Trigger
Instant
Try It
Updated Opportunity
Triggers when an Opportunity is changed.
Trigger
Instant
Try It
Updated Opportunity Status
Triggers when an Opportunity's status is changed.
Trigger
Instant
Try It
Updated Lead
Triggers when a Lead is changed.
Trigger
Instant
Try It
Updated Task
Triggers when a Task is changed.
Trigger
Instant
Try It
- Source Type
  Required
- Project Id
  Required
- Source Id
  Required
Action
Write
- Name
  Required
- Assignee
- E-Mail Domain
- Contact Type
- Description
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
- Replace or Append to Tags
Action
Write
- 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
Action
Write
- Full Name
- Name Prefix
- First Name
- Middle Name
- Last Name
- Name Suffix
- E-Mail
  Required
- Assignee
- Title
- Company
- Contact Type
- Description
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
Action
Write
- 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
Action
Write
- Opportunity ID
  Required
- Name
- Primary Contact
- Description
- Assignee
- Status
- Pipeline
- Stage
- Close Date
- Value
- Currency
- Priority
- Win Probability
- Source
- Tags
- Replace or Append to Tags
Action
Write
- Name
  Required
- Primary Contact
  Required
- Description
- Assignee
- Status
- Pipeline
- Stage
- Close Date
- Value
- Currency
- Priority
- Win Probability
- Source
- Tags
- Replace or Append to Tags
Action
Write
- Name
  Required
- Assignee
- Details
- Status
- Tags
Action
Write
- Name
  Required
- Assignee
- Details
- Status
- Tags
- Replace or Append to Tags
Action
Write
- Match by Type
  Required
Action
Search
- Match by Type
  Required
Action
Search
- Match by Type
  Required
Action
Search
- Match by Type
  Required
- Activity Type
  Required
- Activity Date
  Required
- Parent Type
  Required
- Parent Object
  Required
- Acting User
  Required
- Details
  Required
Action
Search or write
- Match by Type
  Required
- Full Name
- Name Prefix
- First Name
- Middle Name
- Last Name
- Name Suffix
- E-Mail
  Required
- Assignee
- Title
- Company
- Contact Type
- Description
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
Action
Search or write
- Match by Type
  Required
- 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
Action
Search or write

- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Unique Column
  Required
Trigger
Polling
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- IS Operator
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Rows
  Required
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
- Update Columns
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search
- Project
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search or write
New Company
Triggers when a new Company is created in Copper.
Trigger
Instant
Try It
New Opportunity
Triggers when an Opportunity is created in Copper.
Trigger
Instant
Try It
New Project
Triggers when a new Project is created in Copper.
Trigger
Instant
Try It
Updated Company
Triggers when a Person's Company is changed.
Trigger
Instant
Try It
Updated Person
Triggers when a Person is changed.
Trigger
Instant
Try It
Updated Opportunity Stage
Triggers when an Opportunity's stage is changed.
Trigger
Instant
Try It
Updated Lead Status
Triggers when a Lead's status is changed.
Trigger
Instant
Try It
Updated Project
Triggers when a Project is changed.
Trigger
Instant
Try It
- Activity Type
  Required
- Activity Date
  Required
- Parent Type
  Required
- Parent Object
  Required
- Acting User
  Required
- Details
  Required
Action
Write
- Name
  Required
- Assignee
- E-Mail Domain
- Contact Type
- Description
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
- Replace or Append to Tags
Action
Write
- Name
  Required
- Assignee
- E-Mail Domain
- Contact Type
- Description
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
Action
Write
- Full Name
- Name Prefix
- First Name
- Middle Name
- Last Name
- Name Suffix
- E-Mail
  Required
- 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
Action
Write
- 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
Action
Write
- 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
Action
Write
- Name
  Required
- Primary Contact
  Required
- Description
- Assignee
- Status
- Pipeline
- Stage
- Close Date
- Monetary Value
- Currency
- Priority
- Win Probability
- Source
- Tags
- Replace or Append to Tags
Action
Write
- Name
  Required
- Primary Contact
  Required
- Assignee
- Status
- Description
- Pipeline
- Stage
- Close Date
- Monetary Value
- Currency
- Priority
- Win Probability
- Source
- Tags
Action
Write
- Name
  Required
- Assignee
- Details
- Status
- Tags
- Replace or Append to Tags
Action
Write
- Name
  Required
- Assignee
- Due Date
- Reminder Date
- Description
- Priority
- Tags
- Related Entity Type
- Related Entity Object
Action
Write
- Match by Type
  Required
Action
Search
- Match by Type
  Required
Action
Search
- Match by Type
  Required
Action
Search
- Match by Type
  Required
- Name
  Required
- Assignee
- E-Mail Domain
- Contact Type
- Description
- Phone Number
- Social Profiles
- Website
- Street
- City
- State
- Zip Code
- Country
- Tags
Action
Search or write
- Match by Type
  Required
- Name
  Required
- Primary Contact
  Required
- Assignee
- Status
- Description
- Pipeline
- Stage
- Close Date
- Monetary Value
- Currency
- Priority
- Win Probability
- Source
- Tags
Action
Search or write
- Match by Type
  Required
- Name
  Required
- Assignee
- Details
- Status
- Tags
Action
Search or write

About Copper

Copper is a Recommended for Google Workspace CRM that improves productivity and increases visibility across all your customer interactions.

Learn moreLearn moreHelpHelp

Related categories

CRM (Customer Relationship Management)

Similar apps

Capsule CRM

CRM (Customer Relationship Management)

Streak

CRM (Customer Relationship Management)

Insightly

CRM (Customer Relationship Management)

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn moreLearn moreHelpHelp

Related categories

Related Zap Templates

Related Zap Templates

Add new Copper leads to Google BigQuery as rows

Create rows in Google BigQuery when opportunities are updated in Copper