Microsoft Excel + Personio

Create new rows in Microsoft Excel for each new attendance in Personio

Streamline your attendance record management with this seamless workflow. When a new attendance record is logged in your Personio app, it triggers the addition of a new row to your selected Microsoft Excel table. This integration ensures all data is accurately tracked and updated in real-time, enhancing efficiency and accuracy in managing attendance records.

When this happens...
New Attendance
Triggers when an employee or manager logs an attendance record for the day.
TriggerPolling
automatically do this!
Add Row to Table
Adds a new row to the end of a specific table.
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
Polling
Try It
New Candidate
Triggers when a new Candidate is created.
Trigger
Polling
Try It
- Owner IDRequired
- Category ID
- Created On or After
- Created Before
Trigger
Polling
Try It
Employee Updated
Triggers when an employee is updated.
Trigger
Polling
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
Polling
Try It
- Job PositionRequired
- First NameRequired
- Last NameRequired
- EmailRequired
- Gender
- Phone
- Location
- Salary Expectations
- Available From
- Message
- Birthday
- Recruiting Channel ID
- File
- File Name Info
- 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
- 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
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write

New Attendance
Triggers when an employee or manager logs an attendance record for the day.
Trigger
Polling
Try It
- Person ID
- Legal Entity ID
Trigger
Polling
Try It
New Employee
Triggers when a new employee is created.
Trigger
Polling
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
Polling
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
- Person ID
- Email
- First Name
- Last Name
- Include Absence Information
Action
Search
- Employee IDRequired
- Include Pending
- Project ID
- EmployeeRequired
- DateRequired
- Start TimeRequired
- End TimeRequired
- BreakRequired
- CommentRequired
Action
Search or write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write

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.

Learn more