Google BigQuery + iClosed

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 Updated
Triggers when a contact is updated.
TriggerInstant
automatically do this!
Run a Query
Runs a SQL query against a table in BigQuery.
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

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

- OutcomeRequired
Trigger
Instant
Try It
- Event Call IDRequired
- OutcomeRequired
- Notes
Action
Write

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

Setter Owner Assigned
Triggers when a setter owner is assigned to a contact
Trigger
Instant
Try It
- Call OutcomeRequired
- Trigger When Outcome is:
Trigger
Instant
Try It
- Final StatusRequired
- Wait for X Seconds
- Send Last Active Status?
Trigger
Instant
Try It
- TriggerRequired
Trigger
Instant
Try It
- Event TypeRequired
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 IDRequired
- Cancel Reason
Action
Write
- Contact IDRequired
- NotesRequired
Action
Write
- Contact IDRequired
- 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
- 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

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

About iClosed

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

Learn more

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

Google BigQuery + iClosed

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

Contact Custom Field Updated

Call Cancelled

Call Rescheduled

Note Added

Contact Updated

Appointment Setting Outcome

Add Call Outcome

Assign Setter Owner

Create Contact

Create Transaction

Search Custom Fields

Search Call

Search Users

New Row

Updated Row

Create Rows

Import Data

Update Row(s)

Find One Row

Find or Create Record

Setter Owner Assigned

Call Outcome

Contact by Status

Data Intelligence

Call Booked

Transaction Synced

Update Contact Custom Field

Cancel Call

Create Note

Update Contact

Search Contact

Search Transaction

Query Job Completed (With Row Data)

New Job Completed

Create Row

Delete Rows

Run a Query

API Request (Beta)

Get Rows for Job Completed

About Google BigQuery

Related categories

About iClosed

Related categories

Related Zap Templates

Related Zap Templates