Microsoft Excel + Personio

Add rows in Microsoft Excel for new employees in Personio

Streamline your new hire process with this seamless integration of Personio and Microsoft Excel. When a new employee is added in Personio, a row is immediately created in your Microsoft Excel spreadsheet. This smooth workflow keeps all essential employee information in one easily accessible place, saving you precious time and ensuring a consistent data entry process.

When this happens...
New Employee
Triggers when a new employee is created.
TriggerScheduled
automatically do this!
Add Row(s)
Adds one or more rows to the end of a worksheet (with line item support).
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
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
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
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Related categories

Similar apps

About Personio

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

Learn more

Related categories

Human Resources

Related Zap Templates

Add new rows to Microsoft Excel for new absences in Personio

Microsoft Excel + Personio

Add rows in Microsoft Excel for new employees 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 Row in Table

Updated Row

Add Row(s)

Create Spreadsheet

Find Row

Find or Create Row

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 Row

New Worksheet

Add Row

Add Row to Table

Update Row

Find Row(s)

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet

Quip

About Personio

Related categories

Related Zap Templates

Related Zap Templates