Connect TimeKeeper and Zoho Sheet

Both apps 37TimeKeeper 17Zoho Sheet 20

• Trigger
  Employee Clock In

  Triggers when an employee clocks in, returning the new time entry with its employee, job, activity and start time.

• Trigger
  Employee Clock Out

  Triggers when an employee clocks out, delivering the completed time entry with its start and end times, duration, job and activity.

• Trigger
  Leave Request Approved

  Triggers when a leave request is approved in TimeKeeper, for leave falling between 30 days ago and 59 days ahead.

• Trigger
  Who's In

  Triggers when an employee appears on the Who's In list, i.e. each time someone clocks in, with their location, last job and clock-in time.

• Action
  Add activity

  Creates a new activity in TimeKeeper that employees can log time against.

• Action
  Add a Job

  Creates a new job in TimeKeeper with a name and optional job number and address.

• Action
  Get employee timesheet

  Returns an employee's timesheet for a date range, including total regular, overtime and leave hours plus each day's time entries and leave.

• Action
  Get job breakdown report

  Generates a breakdown report for one TimeKeeper job over a date range of up to 60 days.

• Action
  List activities

  Returns every activity set up in your TimeKeeper account, with each activity's name and number.

• Action
  List employees

  Returns the employees in your TimeKeeper account, including archived ones, with their contact details, job title, teams and working locations.

• Action
  List jobs

  Returns every job in your TimeKeeper account, with each job's name, job number, completion status and id.

• Action
  List leave entries

  Returns employee leave entries (annual leave and other leave types) within a date range of up to 30 days, optionally for one employee or one leave type. Public holidays are not included.

• Action
  List leave requests

  Returns the leave requests in your TimeKeeper account for a date range of up to 90 days, optionally filtered by status, leave type or employee. Returns open requests unless another status is chosen.

• Action
  List shifts

  Returns the draft, open and published shifts scheduled in a date range of up to 90 days, optionally for one employee. Shift times are in UTC.

• Action
  List time entries

  Returns the time entries recorded in your TimeKeeper account for a date range of up to 90 days, optionally narrowed to one employee, job or activity.

• Action
  Update activity

  Updates the name and activity number of an existing activity in TimeKeeper.

• Action
  Update a Job

  Updates an existing job in TimeKeeper, changing its name, job number, address or address coordinates.

• Trigger
  New or Updated Row (WorkDrive)

  Triggers when a new row is added or an existing row is modified in a specified worksheet.

• Trigger
  New Row (WorkDrive)

  Triggers when a new row is created in a specified worksheet.

• Trigger
  New Workbook

  Triggered when a new workbook is created in Zoho Sheet.

• Trigger
  Updated Column

  Fires when a cell inside the chosen column(s) of a Zoho Sheet worksheet is changed.

• Trigger
  Updated Column (WorkDrive)

  Triggers when the value of a particular column is set on both new and updated rows. The corresponding row data is returned along with this trigger.

• Action
  Create Row

  Adds one or more rows to a worksheet in a Zoho Sheet workbook, matching values to columns by the header row.

• Action
  Create Row (WorkDrive)

  Adds one or more rows to a worksheet in a Zoho Sheet workbook (including workbooks stored in Zoho WorkDrive), matching values to the table's header columns.

• Action
  Create Worksheet

  Adds a new worksheet (tab) to a Zoho Sheet workbook.

• Action
  Create Worksheet (WorkDrive)

  Creates a new worksheet in the specified workbook.

• Action
  Delete Row

  Deletes a particular row based on its index.

• Action
  Delete Row (WorkDrive)

  Deletes a particular row based on its index.

• Action
  List Worksheets

  Lists the worksheets (tabs) in a workbook via worksheet.list.

• Action
  Search and Delete Row

  Deletes the row(s) in a Zoho Sheet worksheet that match a search criteria, removing them so the rows below move up.

• Action
  Search and Delete Row (WorkDrive)

  Finds the rows in a worksheet of a WorkDrive-stored Zoho Sheet workbook that match a search criteria and deletes them.

• Action
  Search and Update Row

  Searches and then updates a row based on some criteria.

• Action
  Search and Update Row (WorkDrive)

  Finds the rows in a Zoho Sheet worksheet (stored in WorkDrive) that match a criteria and updates them with new column values.

• Action
  Search Row

  Returns the rows of a Zoho Sheet worksheet that match the specified criteria.

• Action
  Search Row - Workdrive Users

  Returns the rows of a Zoho Sheet worksheet (stored in WorkDrive) that match the specified criteria.

• Action
  Update Row

  Updates one row of a Zoho Sheet worksheet, identified by its row number, with new values keyed by column header.

• Action
  Update Row (WorkDrive)

  Updates one row of a worksheet in a Zoho Sheet workbook stored in WorkDrive, identified by its row number, with new values keyed by column header.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.