Google Sheets + Personio

Update Google Sheets rows for new absences in Personio

This Zap will automatically update the value in a row in a specified Google Sheets spreadsheet as soon as any new absence is reported in Personio. Track and manage your absences with no added clicks or keystrokes!

This Zap will automatically update the value in a row in a specified Google Sheets spreadsheet as soon as any new absence is reported in Personio. Track and manage your absences with no added clicks or keystrokes!

  1. When this happens...
    PersonioPersonio
    New Absence

    Triggers when a new absence is created.

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

    Update a 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 more

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 more

Related categories

  • Human Resources