Google BigQuery + OnceHub

Google BigQuery + OnceHub integrations

Update rows in Google BigQuery every time new bookings are completed in OnceHub

This workflow keeps your business data current and precise. As soon as a booking is finalized in OnceHub, it initiates a process that instantly updates rows in your Google BigQuery database. Use this streamlined system to maintain accurate records with zero manual intervention, saving time and boosting efficiency.

When this happens...
Booking CompletedTriggers when the date and time for a booking has passed.
TriggerInstant
automatically do this!
Update Row(s)Triggers when an existing row is updated in 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 OnceHub and Google BigQuery

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

Reassigned Booking
Triggers when a booking calendar booking is reassigned.
Trigger
Instant
Try It
Contact Lifecycle Event
Triggers when a contact is captured or updated
Trigger
Instant
Try It
Conversation Lifecycle Event
Triggers when the status of a conversation is changed to “Reached-out”, “Started”, “Closed”, or “Abandoned”.
Trigger
Instant
Try It
Conversation Closed
Triggers when a chatbot conversation reaches its end, or when a website visitor engages with a new chatbot.
Trigger
Instant
Try It
Booking Lifecycle Event
Triggers when the status of a booking is changed to “Scheduled”, “Rescheduled”, “Canceled”, “Completed”, or “No-show”.
Trigger
Instant
Try It

Booking Cancelled and Rescheduled
Triggers when a booking is canceled and replaced by a new booking.
Trigger
Instant
Try It
Booking No-Show
Triggers when the status of a booking is manually changed to “No-show”.
Trigger
Instant
Try It

Booking Scheduled
Triggers when a new booking is scheduled.
Trigger
Instant
Try It
- Booking Id
  Required
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Find Contact by
  Required
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

Contact Captured
Triggers when a contact is captured
Trigger
Instant
Try It
Contact Updated
Triggers when a captured contact is updated
Trigger
Instant
Try It
Conversation Abandoned
Triggers when a chatbot conversation is abandoned by a website visitor.
Trigger
Instant
Try It
Conversation Started
Triggers when a website visitor starts interacting with your chatbot.
Trigger
Instant
Try It
Booking Canceled
Triggers when an existing booking is cancelled.
Trigger
Instant
Try It
Booking Completed
Triggers when the date and time for a booking has passed.
Trigger
Instant
Try It
Booking Rescheduled
Triggers when a booking is rescheduled.
Trigger
Instant
Try It
- Booking ID
  Required
- Cancellation Reason (optional)
- Notify users upon booking cancellation (optional)
Action
Write
- Booking ID
  Required
- Reschedule Reason (optional)
Action
Write
- Booking ID
  Required
Action
Search
- Contact ID
  Required
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

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 OnceHub

Capture, qualify, and engage with inbound leads using ScheduleOnce, ChatOnce, FormOnce and SubmitOnce.

Learn moreLearn moreHelpHelp

Related categories

Scheduling & Booking

Similar apps

Acuity Scheduling

Scheduling & Booking

Setmore Appointments

Scheduling & Booking

YouCanBookMe

Scheduling & Booking