Google BigQuery and Workato FileStorage integrations and automations

Do everything in one place

Customize your Google BigQuery and Workato FileStorage 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

Workato FileStorage
  • New CSV file Batch Real-time
    New CSV file in Workato FileStorage
  • New file Real-time
    New file in Workato FileStorage
  • New lines in CSV file Batch Real-time
    New CSV lines in file in Workato FileStorage

    • 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

Workato FileStorage
  • Append to file
    Append to file in Workato FileStorage
  • Generate shareable file link
    Generate shareable file link in Workato FileStorage
  • Delete directory
    Delete directory in Workato FileStorage
  • Delete file
    Delete file in Workato FileStorage
  • Create directory
    Create directory in Workato FileStorage
  • Get lines from CSV file Batch
    Get lines from CSV file in Workato FileStorage
  • Get file contents
    Get file contents in Workato FileStorage
  • Rename/move file
    Rename/move file in Workato FileStorage
  • Search files Batch
    Search files in Workato FileStorage
  • Create file
    Create file in Workato FileStorage

    • 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

  • monday
  • box
  • att
  • atlassian
  • slack

Let’s start automating

Schedule a Demo