Do everything in one place

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

Triggers

When this happens…

SQL Server secondary
  • New row
    New row in a table in SQL Server secondary
  • New rows Batch
    New batch of rows in a table in SQL Server secondary
  • New rows via custom SQL Batch
    New batch of rows via custom SQL in SQL Server secondary
  • Scheduled query Batch
    Scheduled query using custom SQL in SQL Server secondary
  • New/updated row
    New/updated row in a table in SQL Server secondary
  • New/updated rows Batch
    New/updated batch of rows in a table in SQL Server secondary
  • New/updated rows via custom SQL Batch
    New/updated batch of rows via custom SQL in SQL Server secondary
  • Any other trigger you can think up

TSheets
  • New job
    New job in TSheets
  • New timesheet
    New timesheet in TSheets
  • New user
    New user in TSheets
  • New/updated timesheet
    New or updated timesheet in TSheets
  • Any other trigger you can think up

Actions

Do this…

SQL Server secondary
  • Delete rows
    Delete rows in a table in SQL Server secondary
  • Execute stored procedure
    Execute stored procedure in SQL Server secondary
  • Export query result Bulk
    Export result of custom SQL in SQL Server secondary
  • Insert row
    Insert row in a table in SQL Server secondary
  • Insert rows Batch
    Insert batch of rows in a table in SQL Server secondary
  • Run custom SQL
    Run custom SQL in SQL Server secondary
  • Run long query using custom SQL
    Run long query using custom SQL in SQL Server secondary
  • Select rows
    Select rows in a table in SQL Server secondary
  • Select rows using custom SQL
    Select rows using custom SQL in SQL Server secondary
  • Replicate rows Batch
    Replicate batch of rows to table in SQL Server secondary
  • Update rows
    Update rows in a table in SQL Server secondary
  • Update rows Batch
    Update batch of rows in a table in SQL Server secondary
  • Upsert row
    Upsert row in a table in SQL Server secondary
  • Upsert rows Batch
    Upsert batch of rows in a table in SQL Server secondary
  • Any other action you can think up

  • Show all 14
TSheets
  • Custom action
    Custom action in TSheets (Custom)
  • Create timesheet
    Create timesheet in TSheets
  • Create user
    Create user in TSheets
  • Delete timesheet
    Delete timesheet in TSheets
  • Edit timesheet
    Edit timesheet in TSheets
  • Edit user
    Edit user in TSheets
  • Get jobcode details by ID
    Get jobcode details from TSheets
  • Get payroll report
    Get payroll report from TSheets
  • Get user details by ID/employee number
    Get user details from TSheets
  • Any other action you can think up

  • Show all 9

Let us tailor your SQL Server secondary and TSheets integrations

Pre-built SQL Server secondary and TSheets Automations

See more

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