Google Sheets and TSheets integrations and automations

Do everything in one place

Customize your Google Sheets and TSheets integration with the following triggers and actions.

Triggers

When this happens…

Google Sheets
  • New row in sheet in My Drive
    New row in a sheet in Google Sheets
  • New row in sheet in My Drive Real-time
    New row in a sheet in Google Sheets
  • New row in sheet in Team Drive
    New row in a sheet in Google Sheets
  • New/updated row in sheet in Team Drive
    New/updated row in a sheet in Google Sheets
  • New/updated row in sheet in My Drive
    New/updated row in a sheet in Google Sheets
  • New/updated row in sheet in My Drive Real-time
    New/updated row in a sheet in Google Sheets

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

Google Sheets
  • Custom action
    Custom action in Google Sheets (Custom)
  • Add rows in bulk Batch
    Add multiple rows in a sheet in Google Sheets
  • Add row
    Add a new row in a sheet in Google Sheets
  • Get rows Batch
    Get rows from sheet in Google Sheets
  • Search rows Batch
    Search rows in a sheet in Google Sheets
  • Update rows in bulk Batch
    Update multiple rows in a sheet in Google Sheets
  • Update row
    Update a row in a sheet in Google Sheets
  • Update row using row ID (old version)
    Update a row using row ID in a sheet in Google Sheets

    • Any other action you can think up

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 Batch
    Get payroll report from TSheets
  • Get user details by ID/employee number
    Get user details from TSheets

    • 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