Google BigQuery and Outlook integrations and automations

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

Ratings

4.9

Peer Insights™

100%

Customer Recommendation

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…

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

Outlook
  • Deleted event Real-time
    Deleted event in Outlook Calendar
  • New contact
    New contact in Outlook
  • New email Real-time
    New email received in Outlook Mail
  • New event Real-time
    New event created in Outlook Calendar
  • New/updated contact
    New/updated contact in Outlook
  • New/updated email Real-time
    New/updated email in Outlook Mail
  • New/updated event Real-time
    New/updated event in Outlook Calendar

    • 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

Outlook
  • Custom action
    Custom action in Outlook (Custom)
  • Create calendar
    Create calendar in Outlook
  • Create contact
    Create contact in Outlook
  • Create calendar event
    Create event in Outlook Calendar
  • Delete calendar event
    Delete calendar event in Outlook
  • Delete contact
    Delete contact in Outlook
  • Download email attachments
    Download email attachments from email in Outlook Mail
  • Get calendar by ID
    Get calendar details by ID in Outlook
  • Get contact
    Get contact in Outlook
  • Get calendar event by ID
    Get event in Outlook Calendar
  • List calendars
    List calendars in Outlook
  • List contacts Batch
    List contacts in Outlook
  • List all instances of an event Batch
    List all instances of an event in Outlook
  • Search calendar Batch
    Search for calendar details in Outlook
  • Search contacts Batch
    Search contacts in Outlook
  • Search calendar events Batch
    Search events in Outlook Calendar
  • Send email
    Send email from Outlook Mail
  • Update contact
    Update contact in Outlook
  • Update calendar event
    Update event in Outlook Calendar

    • Any other action you can think up

One platform

  • Power
  • Agility
  • Speed
  • Innovation

Let’s start automating

Schedule a Demo