Asana and Google BigQuery integrations and automations

Seamlessly connect Asana 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…

Asana
  • New event Real-time
    New event in Asana
  • New or updated tasks trigger
    New or updated task in Asana

    • 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…

Asana
  • Custom action
    Custom action in Asana (Custom)
  • Add task to section
    Add task to section in Asana
  • Create a membership
    Create a membership in Asana
  • Create a project
    Create a project in Asana
  • Create a section in a project
    Create a section in a project in Asana
  • Create a status update
    Create a status update in Asana
  • Create a story on a task
    Create a story on a task in Asana
  • Create subtask
    Create subtask in Asana
  • Create tag
    Create tag in Asana
  • Create task
    Create task in Asana
  • Get a project's custom field settings Batch
    Get a project's custom field settings in Asana
  • Get people details by ID
    Get people details by ID in Asana
  • Get project detail by ID
    Get project details by ID in Asana
  • Get project sections Batch
    Get sections in project in Asana
  • Get stories from a task Batch
    Get stories from a task in Asana
  • Get subtasks from a task Batch
    Get subtasks from a task in Asana
  • Get task counts for a project
    Get task counts for a project in Asana
  • Get task details by ID
    Get task details by ID in Asana
  • Get tasks from a section Batch
    Get tasks from a section in Asana
  • Get tasks from a user task list Batch
    Get tasks from a user task list in Asana
  • Get a user's task list
    Get a user's task list in Asana
  • List all tasks with tag Batch
    List tasks with tag in Asana
  • List people Batch
    List people in Asana
  • List project tasks Batch
    List tasks in project in Asana
  • List workspaces Batch
    List workspaces in Asana
  • Search projects Batch
    Search projects in Asana
  • Search tags Batch
    Search tags in Asana
  • Search tasks Batch
    Search tasks in workspace in Asana
  • Search tasks in a workspace Batch
    Search tasks in a workspace in Asana
  • Get objects via typeahead Batch
    Get objects via typeahead in Asana
  • Update task
    Update task in Asana

    • 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