Google BigQuery + iClosed

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

When a call outcome is recorded in the iClosed app, this automation promptly adds a new row in Google BigQuery. It helps to keep track of every call, saving you the manual task of data entry and ensuring your BigQuery dataset is always up-to-date with your call records. This way, your data remains streamlined, allowing you to make smarter business decisions.

When this happens...
Call Outcome
Triggers when an outcome of a call is added in iClosed.
TriggerInstant
automatically do this!
Create Row
Creates a new row of data in a table. Note: Does not create a job.
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
- 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

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
- 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

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 rows in Google BigQuery when new calls are booked in iClosed

Google BigQuery + iClosed

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

Contact Custom Field Updated

Call Cancelled

Call Rescheduled

Note Added

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

Setter Owner Assigned

Call Outcome

Contact by Status

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

About Google BigQuery

Related categories

About iClosed

Related categories

Related Zap Templates

Related Zap Templates