BambooHR and Google BigQuery integrations and automations

Seamlessly connect BambooHR and Google BigQuery. Automate workflows, and boost efficiency with Workato.

Rating

4.9

Pre-built

150+

integrations

Total

100+

active users

avg

2 min

to connect

Custom Connections

Available

via HTTP connector

Market leaders run on Workato

  • monday.svg
  • box.svg
  • hp-2.svg
  • atlassian.svg
  • cisco.png

Build Powerful Workflows, fast

Triggers

When this happens…

BambooHR
  • New employee
    New employee in BambooHR
  • New employee Real-time
    New employee in BambooHR
  • Schedule custom employee report Batch
    Scheduled report in BambooHR
  • New/updated employee
    New/updated employee in BambooHR
  • New/updated employee Real-time
    New/updated employee in BambooHR

    • Any other trigger you can think up

Google BigQuery
  • New job completed
    New job completed in BigQuery
  • New row
    New row in a table in BigQuery
  • New rows Batch
    New batch of rows in a table in BigQuery
  • Scheduled query Batch
    New scheduled query using custom SQL in BigQuery

    • Any other trigger you can think up

Actions

Do this…

BambooHR
  • Custom action
    Custom action in BambooHR (Custom)
  • Create employee
    Create employee in BambooHR
  • Create/update time off request
    Create/update a time off request on BambooHR
  • Create table record of employee
    Create table record of employee in BambooHR
  • Delete table record
    Delete table record of employee in BambooHR
  • Get company employee report by ID
    Get company report by ID in BambooHR
  • Get employee details by ID
    Get employee details in BambooHR
  • Get report by ID (v2)
    Get report by ID in BambooHR
  • Get table records of employee Batch
    Get table records of employee in BambooHR
  • Get time off balance
    Get time off balance in BambooHR
  • List employees in directory Batch
    List employees in BambooHR
  • List time off requests Batch
    List time off request on BambooHR
  • List time off types
    List time off types in BambooHR
  • List who's out
    List who's out in BambooHR
  • Create custom employee report Batch
    Create a custom report on employees in BambooHR
  • Request time off
    Request time off in BambooHR
  • Search employees
    Search employees in BambooHR
  • Update employee
    Update employee in BambooHR
  • Update table record of employee
    Update table record of employee in BambooHR
  • Update time off request status
    Update time off request on BambooHR

    • Any other action you can think up

Google BigQuery
  • Custom action
    Custom action in Google BigQuery (Custom)
  • Cancel job
    Cancel job in BigQuery
  • Estimate query cost
    Estimate query cost in BigQuery
  • Execute SQL statement
    Execute SQL statement in BigQuery
  • Get dataset
    Get dataset metadata in BigQuery
  • Get job
    Get job status in BigQuery
  • Get batch of rows by Job ID Batch
    Get batch of rows from query result in BigQuery
  • Get table
    Get table schema and metadata in BigQuery
  • Insert row
    Insert a row in table in BigQuery
  • Insert rows Batch
    Insert rows in table in BigQuery
  • List datasets
    List datasets in BigQuery
  • List tables
    List tables in a dataset in BigQuery
  • Load data into BigQuery
    Load data into table on BigQuery
  • Load data from Google Cloud Storage into BigQuery
    Load data from Google Cloud Storage into table on BigQuery
  • Preview table rows
    Preview rows of a table in BigQuery
  • Run custom SQL in BigQuery
    Run custom SQL in BigQuery
  • Run query
    Run query in BigQuery
  • Select rows (Old) Batch
    Select rows asynchronously in a table in BigQuery
  • Select rows Batch
    Select rows in a table in BigQuery
  • Select rows using custom SQL (Old) Batch
    Select rows asynchronously using custom SQL in BigQuery
  • Select rows using custom SQL Batch
    Select rows using custom SQL in BigQuery
  • Select rows using custom SQL and insert into table Batch
    Select rows using custom SQL and insert into table in BigQuery

    • Any other action you can think up

One platform

  • Power
  • Agility
  • Speed
  • Innovation