Capsule CRM + Google BigQuery

Create rows in Google BigQuery for new or updated contacts in Capsule CRM

Effortlessly maintain your Capsule CRM contacts and keep your Google BigQuery data always up-to-date with this seamless workflow. Whenever a new or updated contact is detected in your Capsule CRM, a new row will be created in your Google BigQuery database, ensuring that your contact data remains consistent and easily accessible. This integration streamlines your contact management process, saving you time while improving data accuracy.

When this happens...
New or Updated ContactTriggers when a given action is performed on a Person or Organisation.
TriggerInstant
automatically do this!
Create RowCreates a new row of data in a table. Note: Does not create a job.
ActionWrite

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 Capsule CRM and Google BigQuery

Discover other triggers and actions you can use with Capsule CRM and Google BigQuery

- Action
  Required
Trigger
Instant
Try It
- Action
  Required
Trigger
Instant
Try It
- Contact
  Required
- Name
  Required
- Board
- Description
- Expected Close Date
- Track
- Opportunity
- Owner
- Tags
- Status
Action
Write
- Entity Type
  Required
Action
Write
- Type
  Required
- About
- Email Address
- Street Address
- City
- State
- Zip Code
- Country
- Phone Number
- Website
- Tags
Action
Write

- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
Update Opportunity
This action updates an existing Opportunity in Capsule CRM. You can choose which fields to update from the editor. The Opportunity ID is selected from a dropdown list populated by the listOpportunities endpoint. The milestoneName field is a string input f
Action
Write

- Pipeline
  Required
- Name
  Required
Action
Search
- Search using
  Required
Action
Search
- Search using
  Required
- Contact
  Required
- Name
  Required
- Board
- Description
- Expected Close Date
- Track
- Opportunity
- Owner
- Tags
- Status
Action
Search or write
- Search using
  Required
- Type
  Required
- About
- Email Address
- Street Address
- City
- State
- Zip Code
- Country
- Phone Number
- Website
- 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

- Action
  Required
Trigger
Instant
Try It
- Action
  Required
Trigger
Instant
Try It
- Entity Type
  Required
- Activity Type
- Note
  Required
Action
Write
- Contact
  Required
- Pipeline
  Required
- Name
  Required
- Description
- Expected Close Date
- Actual Close Date
- Currency
- Duration Basis
- Owner
- Track
- Tags
Action
Write
- Description
  Required
- Due Date
  Required
- Detail
- Category
- Owner
- Entity Type
Action
Write
Update Contact
Update an existing Contact
Action
Write
- Search using
  Required
Action
Search
- Search using
  Required
Action
Search
- Board
  Required
- Name
  Required
Action
Search
- Search using
  Required
- Contact
  Required
- Pipeline
  Required
- Name
  Required
- Description
- Expected Close Date
- Actual Close Date
- Currency
- Duration Basis
- Owner
- Track
- Tags
Action
Search or write
- 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

About Capsule CRM

Capsule is an online CRM for managing contacts, tasks and sales opportunities. Add tasks, track communication logs, and close deals in your pipeline faster with Capsule.

Learn moreLearn moreHelpHelp

Related categories

CRM (Customer Relationship Management)

Similar apps

Streak

CRM (Customer Relationship Management)

Insightly

CRM (Customer Relationship Management)

Zapier Forms

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

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

Databases

Google

Premium