Google BigQuery and ServiceM8 integrations and automations

Do everything in one place

Customize your Google BigQuery and ServiceM8 integration with the following triggers and actions.

Triggers

When this happens…

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

ServiceM8
  • Contact created
    Contact created in ServiceM8
  • Job activity created
    Job activity created in ServiceM8
  • Material created
    Material created in ServiceM8
  • Staff created
    Staff created in ServiceM8
  • Job quoted
    Job quoted in ServiceM8
  • Client updated
    Client updated in ServiceM8
  • Job updated
    Job updated in ServiceM8

    • Any other trigger you can think up

Actions

Do this…

Google BigQuery
  • Custom action
    Custom action in Google BigQuery (Custom)
  • Get batch of rows by Job ID Batch
    Get batch of rows from query result in BigQuery
  • Insert row
    Insert a row in table in BigQuery
  • Insert rows Batch
    Insert rows in table 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
  • Run custom SQL in BigQuery
    Run custom SQL 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

ServiceM8
  • Add job
    Add job in ServiceM8
  • Add job material
    Add job material to a job in ServiceM8
  • Create material
    Create material in ServiceM8
  • Add staff
    Add new staff in ServiceM8
  • Create client
    Create client in ServiceM8
  • Create contact
    Create contact in ServiceM8
  • Get client details by UUID
    Get client details in ServiceM8
  • Get job by UUID
    Get job in ServiceM8
  • Get job materials by job/UUID Batch
    Get job materials in ServiceM8
  • Get staff by UUID
    Get staff in ServiceM8
  • Search client
    Search client in ServiceM8
  • Search contact Batch
    Search contact in ServiceM8
  • Search job activities Batch
    Search job activities in ServiceM8
  • Search materials
    Search materials in ServiceM8
  • Search staff Batch
    Search staff in ServiceM8
  • Update client
    Update client in ServiceM8
  • Update contact
    Update contact in ServiceM8
  • Update job
    Update job in ServiceM8
  • Update material
    Update material in ServiceM8

    • Any other action you can think up

The wonders of Workato

Easily set up as many intelligent automations you need.
  • 1000s of ready-to-use templates
  • Accelerate work with intelligent automation
  • Do it yourself, faster
  • Build bots. Put them to work

Market leaders run on Workato

  • mgm
  • adobe
  • att
  • atlassian
  • slack

Let’s start automating

Schedule a Demo