Copper + Google BigQuery

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 Row
Triggers 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 Person
Creates a new Person.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

- ProjectRequired
- Dataset
- Table
Trigger
Polling
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write

- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project IDRequired
- Job IDRequired
- LocationRequired
Action
Search

- Entity TypeRequired
- Activity TypeRequired
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 TypeRequired
- Project IdRequired
- Source IdRequired
Action
Write
- 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
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-MailRequired
- 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 IDRequired
- Name
- Primary Contact
- Description
- Assignee
- Status
- Pipeline
- Stage
- Close Date
- Value
- Currency
- Priority
- Win Probability
- Source
- Tags
- Replace or Append to Tags
Action
Write
- NameRequired
- Primary ContactRequired
- Description
- Assignee
- Status
- Pipeline
- Stage
- Close Date
- Value
- Currency
- Priority
- Win Probability
- Source
- Tags
- Replace or Append to Tags
Action
Write
- NameRequired
- Assignee
- Details
- Status
- Tags
Action
Write
- NameRequired
- Assignee
- Details
- Status
- Tags
- Replace or Append to Tags
Action
Write
- Match by TypeRequired
Action
Search
- Match by TypeRequired
Action
Search
- Match by TypeRequired
Action
Search
- Match by TypeRequired
- Activity TypeRequired
- Activity DateRequired
- Parent TypeRequired
- Parent ObjectRequired
- Acting UserRequired
- DetailsRequired
Action
Search or write
- Match 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
Action
Search or write
- Match 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
Action
Search or write

- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Polling
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- RowsRequired
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
- Update ColumnsRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search
- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
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 TypeRequired
- Activity DateRequired
- Parent TypeRequired
- Parent ObjectRequired
- Acting UserRequired
- DetailsRequired
Action
Write
- 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
Action
Write
- NameRequired
- 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-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
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
- NameRequired
- Primary ContactRequired
- Description
- Assignee
- Status
- Pipeline
- Stage
- Close Date
- Monetary Value
- Currency
- Priority
- Win Probability
- Source
- Tags
- Replace or Append to Tags
Action
Write
- NameRequired
- Primary ContactRequired
- Assignee
- Status
- Description
- Pipeline
- Stage
- Close Date
- Monetary Value
- Currency
- Priority
- Win Probability
- Source
- Tags
Action
Write
- NameRequired
- Assignee
- Details
- Status
- Tags
- Replace or Append to Tags
Action
Write
- NameRequired
- Assignee
- Due Date
- Reminder Date
- Description
- Priority
- Tags
- Related Entity Type
- Related Entity Object
Action
Write
- Match by TypeRequired
Action
Search
- Match by TypeRequired
Action
Search
- Match by TypeRequired
Action
Search
- Match by TypeRequired
- NameRequired
- 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 TypeRequired
- NameRequired
- Primary ContactRequired
- Assignee
- Status
- Description
- Pipeline
- Stage
- Close Date
- Monetary Value
- Currency
- Priority
- Win Probability
- Source
- Tags
Action
Search or write
- Match by TypeRequired
- NameRequired
- 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.

Related categories

CRM (Customer Relationship Management)

Similar apps

About Google BigQuery

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

Learn more

Related categories

Related Zap Templates

Add new Copper leads to Google BigQuery as rows

Create rows in Google BigQuery when opportunities are updated in Copper

Copper + Google BigQuery

Create persons in Copper for every new row in Google BigQuery

Query Job Completed (With Row Data)

New Job Completed

Create Row

Delete Rows

Run a Query

API Request (Beta)

Get Rows for Job Completed

New Activity

New Person

New Lead

New Task

Updated Contact Type

Updated Opportunity

Updated Opportunity Status

Updated Lead

Updated Task

Associate to Project

Create/Update Company

Update Person

Create Person

Create/Update Lead

Update Opportunity by ID

Create/Update Opportunity

Create Project

Create/Update Project

Search for an Activity

Search for a Person

Search for a Lead

Search for an Activity (or create)

Search for a Person (or create)

Search for a Lead (or create)

New Row

Updated Row

Create Rows

Import Data

Update Row(s)

Find One Row

Find or Create Record

New Company

New Opportunity

New Project

Updated Company

Updated Person

Updated Opportunity Stage

Updated Lead Status

Updated Project

Create Activity

Update Company

Create Company

Create/Update Person

Update Lead

Create Lead

Update Opportunity

Create Opportunity

Update Project

Create Task

Search for a Company

Search for a Opportunity

Search for a Project

Search for a Company (or create)

Search for a Opportunity (or create)

Search for a Project (or create)

About Copper

Related categories

Similar apps

Capsule CRM

Streak

Insightly

About Google BigQuery

Related categories

Related Zap Templates

Related Zap Templates