Google BigQuery + iClosed

Google BigQuery + iClosed integrations

Update queries in Google BigQuery each time contacts are updated in iClosed

Keep track of updates to your contacts in iClosed with ease. Set up this workflow to run a specific query in Google BigQuery whenever a contact detail changes in iClosed. It helps streamline your data analysis process, providing you the most updated information on your contacts without the hassle of manual input.

When this happens...
Contact UpdatedTriggers when a contact is updated.
TriggerInstant
automatically do this!
Run a QueryRuns a SQL query against a table in BigQuery.
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 iClosed and Google BigQuery

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

- Custom Field ID
  Required
Trigger
Instant
Try It
Call Cancelled
Triggers when a call is cancelled by an Invitee or by a Closer.
Trigger
Instant
Try It
- Event Type
  Required
Trigger
Instant
Try It
Note Added
Triggers when a note is added.
Trigger
Instant
Try It
- Trigger
  Required
Trigger
Instant
Try It

- Outcome
  Required
Trigger
Instant
Try It
- Event Call ID
  Required
- Outcome
  Required
- Notes
Action
Write

- Contact ID
  Required
- User ID
  Required
Action
Write
- First Name
- Last Name
- Email
  Required
- Phone Number
- Tag
- Event Name
Action
Write
- Contact Email
  Required
- Contact First Name
- Contact Last Name
- Contact Phone Number
- Transaction Time
- Transaction Value
- Product Name
Action
Write
- Name
- Type
- Input Type
Action
Search
- Contact ID
  Required
- Start Date
- Type
- Closer ID
Action
Search
- Email
- Phone Number
Action
Search
- 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

Setter Owner Assigned
Triggers when a setter owner is assigned to a contact
Trigger
Instant
Try It
- Call Outcome
  Required
- Trigger When Outcome is:
Trigger
Instant
Try It
- Final Status
  Required
- Wait for X Seconds
- Send Last Active Status?
Trigger
Instant
Try It
- Trigger
  Required
Trigger
Instant
Try It
- Event Type
  Required
Trigger
Instant
Try It
Transaction Synced
Triggers when a transaction is synced with a Deal.
Trigger
Instant
Try It
- Contact ID
- Custom Field ID
Action
Write
- Event Call ID
  Required
- Cancel Reason
Action
Write
- Contact ID
  Required
- Notes
  Required
Action
Write
- Contact ID
  Required
- First Name
- Last Name
- Email
- Phone Number
- Secondary Email
- Secondary Phone Number
- Status
Action
Write
- Email
- Phone Number
Action
Search
- Name
- Synced
- Email
- Phone Number
- Source
- Value
Action
Search
- 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 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

About iClosed

iClosed is a sales analytics & scheduler platform that helps you scale your business.

Learn moreLearn moreHelpHelp

Related categories

Scheduling & Booking

Related Zap Templates

Update rows in Google BigQuery when contacts are updated in iClosed

Create new rows in Google BigQuery when new outcomes are updated in iClosed

Create rows in Google BigQuery when new calls are booked in iClosed