Airtable + Personio

Update and manage Airtable records effortlessly with new or updated employees from Personio

Keep your Airtable records up-to-date effortlessly with this efficient workflow. When an employee's details are modified in Personio, a corresponding record in Airtable is instantly created or updated. This automation ensures that your Airtable records always mirror the latest changes in Personio, saving you the time and effort of manual updating.

When this happens...
Employee Updated
Triggers when an employee is updated.
TriggerScheduled
automatically do this!
Create or Update Record
Updates an existing record if one exists, otherwise creates a new record.
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

What does this mean?

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
- BaseRequired
- TableRequired
- Help Text
- Which timestamp field should this Zap use to check for updates?Required
- Limit to View
- Include file contents?
Trigger
Scheduled
Try It
- Cache Copy
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
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
- BaseRequired
- TableRequired
- Limit to View
- Include file contents?
Trigger
Scheduled
Try It
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- Lookup FieldRequired
- Secondary Lookup Field
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
- Include file contents?
- Max Records
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
- Include file contents?
- Max Records
Action
Search or write

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Learn more