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!

When this happens...
New Absence
Triggers when a new absence is created.
TriggerScheduled
automatically do this!
Update Spreadsheet Row
Update a row in a specific spreadsheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

New Absence
Triggers when a new absence is created.
Trigger
Scheduled
Try It
- Person ID
- Legal Entity ID
Trigger
Scheduled
Try It
New Employee
Triggers when a new employee is created.
Trigger
Scheduled
Try It
New Employment Created
Triggers when one or more Employment details of a Person are created
Trigger
Instant
Try It
Employment Updated
Triggers when one or more Employment details of a Person are updated
Trigger
Instant
Try It

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

- File
- File Title
- Category ID
- File Comment
Action
Write
- File
- File Title
- Category ID
- File Comment
Action
Write
- Employee IDRequired
Action
Search
- Owner IDRequired
- Document Name
- Document Type
- Category ID
- Created On or After
- Created Before
Action
Search
- Employee IDRequired
- EmployeeRequired
- Absence typeRequired
- Start dateRequired
- End dateRequired
- Half-day Off Start DateRequired
- Half-day Off End DateRequired
- Comment
- Skip Approval
Action
Search or write
- EmailRequired
- File
- File Title
- Category ID
- File Comment
Action
Search or write
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

New Attendance
Triggers when an employee or manager logs an attendance record for the day.
Trigger
Scheduled
Try It
- Owner IDRequired
- Category ID
- Created On or After
- Created Before
Trigger
Scheduled
Try It
Employee Updated
Triggers when an employee is updated.
Trigger
Scheduled
Try It
Employment Terminated
Triggers when an existing employment is terminated.
Trigger
Instant
Try It
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
- Project ID
- EmployeeRequired
- DateRequired
- Start TimeRequired
- End TimeRequired
- BreakRequired
- CommentRequired
Action
Write
- Attendance IDRequired
- Date
- Start Time
- End Time
- Break Time
- Comment
Action
Write
- Employee IDRequired
- Category IDRequired
- FileRequired
- Desired File NameRequired
- File Comment
Action
Write
- Employee IDRequired
- Include Pending
Action
Search
- EmailRequired
Action
Search
- Employee IDRequired
- Include Pending
- Project ID
- EmployeeRequired
- DateRequired
- Start TimeRequired
- End TimeRequired
- BreakRequired
- CommentRequired
Action
Search or write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write

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

Similar apps

About Personio

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

Learn more

Related categories

Human Resources

Google Sheets + Personio

Update Google Sheets rows for new absences in Personio

New Absence

New Employee Compensation Record (Starts Today)

New Employee

New Employment Created

Employment Updated

Updated Attendance

Create Absence

Create Employee

Update Employee

Find Absence

Find Document

Find or Create Absence

Find or Create Employee

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Copy Worksheet

Create Worksheet

Format Spreadsheet Row

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Many Spreadsheet Rows (Advanced)

Find or Create Worksheet

New Attendance

New Document

Employee Updated

Employment Terminated

New Open Position

Create Applicant

Create Attendance

Update Attendance

Upload File to Employee

Find Attendance

Find Employee

Find or Create Attendance

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Create Spreadsheet

Clear Spreadsheet Row

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

About Personio

Related categories

Related Zap Templates

Related Zap Templates