Google Sheets + Personio

Add new Personio absences to Google Sheets rows effortlessly

Keep track of employee absences with ease using this workflow. Whenever there is a new absence recorded in Personio, it will create a row in a Google Sheets spreadsheet. Not only does this allow for efficient record keeping, but it also provides a comprehensive, real-time overview of absences within your team or company. This automation streamlines absence management, reducing the time and effort required to maintain accurate records.

Keep track of employee absences with ease using this workflow. Whenever there is a new absence recorded in Personio, it will create a row in a Google Sheets spreadsheet. Not only does this allow for efficient record keeping, but it also provides a comprehensive, real-time overview of absences within your team or company. This automation streamlines absence management, reducing the time and effort required to maintain accurate records.

  1. When this happens...
    PersonioPersonio
    New Absence

    Triggers when a new absence is created.

    TriggerScheduled
  2. automatically do this!
    Google SheetsGoogle Sheets
    Create Spreadsheet Row

    Create a new row in a specific spreadsheet.

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
  • Personio triggers, actions, and search

    New Absence

    Triggers when a new absence is created.

    Trigger
    Scheduled
    Try It
  • Personio triggers, actions, and search

    New Employee

    Triggers when a new employee is created.

    Trigger
    Scheduled
    Try It
  • Personio triggers, actions, and search

    New Open Position

    Triggers when a new open position is created.

    Trigger
    Scheduled
    Try It
    • Job PositionRequired

    • First NameRequired

    • Last NameRequired

    • EmailRequired

    • Gender

    • Phone

    • Location

    • Salary Expectations

    • Available From

    • Message

    • Birthday

    • Recruiting Channel ID

    • File

    • Desired File Name

    • File Category

    Action
    Write
  • Personio triggers, actions, and search

    New Attendance

    Triggers when an employee or manager logs an attendance record for the day.

    Trigger
    Scheduled
    Try It
  • Personio triggers, actions, and search

    Employee Updated

    Triggers when an employee is updated.

    Trigger
    Scheduled
    Try It
  • Personio triggers, actions, and search

    Updated Attendance

    Triggers when an attendace record is updated.

    Trigger
    Scheduled
    Try It
    • EmployeeRequired

    • Absence typeRequired

    • Start dateRequired

    • End dateRequired

    • Half-day Off Start DateRequired

    • Half-day Off End DateRequired

    • Comment

    • Skip Approval

    Action
    Write
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn moreHelp

Related categories

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
personio logo
personio logo

About Personio

Personio is a holistic HR software for companies from 10 - 2000 employees.
Learn moreHelp

Related categories

  • Human Resources