Connect Personio and Zoho Sheet

Both apps 33Personio 13Zoho Sheet 20

• Trigger
  New Employment Created

  Triggers when one or more Employment details of a Person are created

• Action
  Add project

  /v2/projects - create a project.

• Action
  Create Absence

  Creates a new absence.

• Action
  Create Attendance

  Creates a new attendance.

• Action
  Create Employee

  Creates a new employee.

• Action
  Delete absence

  /v2/absence-periods/{id} - delete an absence period.

• Action
  Delete attendance

  /v2/attendance-periods/{id} - delete an attendance period.

• Action
  Delete person

  /v2/persons/{id} - delete a person.

• Action
  List Compensations

  Lists compensations filtered by person.id and a start_date/end_date window; returns id, amount, interval, type, effective_from per record.

• Action
  List org units

  /v2/org-units - list org units.

• Action
  Update absence

  /v2/absence-periods/{id} - update an absence period.

• Action
  Update Attendance

  Updates an existing attendance.

• Action
  Update Employee

  Updates an existing employee.

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