SQL Server and Outlook integrations and automations

Do everything in one place

Customize your SQL Server and Outlook integration with the following triggers and actions.

Triggers

When this happens…

SQL Server
  • New row
    New row in a table in SQL Server
  • New rows Batch
    New batch of rows in a table in SQL Server
  • New rows via custom SQL Batch
    New batch of rows via custom SQL in SQL Server
  • Scheduled query Batch
    Scheduled query using custom SQL in SQL Server
  • New/updated row
    New/updated row in a table in SQL Server
  • New/updated rows Batch
    New/updated batch of rows in a table in SQL Server
  • New/updated rows via custom SQL Batch
    New/updated batch of rows via custom SQL in SQL Server

    • Any other trigger you can think up

Outlook
  • 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 event Real-time
    New/updated event in Outlook Calendar

    • Any other trigger you can think up

Actions

Do this…

SQL Server
  • Bulk load from an on-prem file
    Bulk load rows into a table in SQL Server from an on-prem file
  • Delete rows Batch
    Delete rows in a table in SQL Server
  • Execute stored procedure Batch
    Execute stored procedure in SQL Server
  • Export query result
    Export query result as a CSV file in SQL Server
  • Insert row
    Insert row in a table in SQL Server
  • Insert rows Batch
    Insert batch of rows in a table in SQL Server
  • Replicate schema
    Replicate table schema in SQL Server
  • Run custom SQL Batch
    Run custom SQL in SQL Server
  • Run long query using custom SQL
    Run long query using custom SQL in SQL Server
  • Select rows Batch
    Select rows in a table in SQL Server
  • Select rows using custom SQL Batch
    Select rows using custom SQL in SQL Server
  • Replicate rows Batch
    Replicate batch of rows to table in SQL Server
  • Get table schema
    Get table schema for SQL Server
  • Update rows
    Update rows in a table in SQL Server
  • Update rows Batch
    Update batch of rows in a table in SQL Server
  • Upsert row
    Upsert row in a table in SQL Server
  • Upsert rows Batch
    Upsert batch of rows in a table in SQL Server

    • Any other action you can think up

Outlook
  • Custom action
    Custom action in Outlook (Custom)
  • Create contact
    Create contact in Outlook
  • Create calendar event
    Create event in Outlook Calendar
  • 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 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

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