Google BigQuery + Workiz

Google BigQuery + Workiz integrations

Create new rows in Google BigQuery when new jobs are added in Workiz

Maintain an up-to-date record of job assignments effortlessly. With this workflow, each time a new job appears in your Workiz app, it immediately creates a new row in Google BigQuery. This process simplifies data management and saves you from manual entry, ensuring accurate tracking of tasks across teams. Experience streamlined workflow and enhanced efficiency with this easy-to-use setup.

When this happens...
New JobTriggers when a new job is created.
TriggerPolling
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 Workiz and Google BigQuery

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

Job Is Done
Triggers when a job is completed and status has changed to Done
Trigger
Polling
Try It
Lead Status Change
Triggers when a lead status is changed
Trigger
Polling
Try It
New Lead
Triggers when a new lead is created.
Trigger
Polling
Try It
- First Name
  Required
- Last name
- Phone Number
- Address
- City
- State
- PostalCode
- Lead start time
- Email address
- Lead source
- Description
- Company
Action
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

Job Status Change
Triggers when a job status is changed
Trigger
Polling
Try It
New Job
Triggers when a new job is created.
Trigger
Polling
Try It
- First Name
  Required
- Last name
- Phone
- Address
  Required
- City
  Required
- State
- PostalCode
  Required
- Jobs start time
  Required
- Job Type
  Required
- Service Area
- Email address
- Job source
- JobNotes
- Company
- Phone Ext
- Second Phone
- Second Phone Ext
- Unit
- Job End Date Time
- Client Id
Action
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 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 Workiz

Workiz makes it easier than ever for service business owners to run their business, save time, make their team more efficient and their business more profitable.

Learn moreLearn moreHelpHelp

Related categories

Scheduling & Booking

Related Zap Templates

Create rows in Google BigQuery for new leads in Workiz

Related Zap Templates

Create rows in Google BigQuery for new leads in Workiz