Google Sheets + Personio
Create Google Sheets rows for new Personio employees
Google Sheets is a popular app for employee management. If you find updating spreadsheets tedious, then this is the Zapier template for you. Every time a new employee is created in Personio, the employee will be added to a row in a selected Google Sheets spreadsheet.
Google Sheets is a popular app for employee management. If you find updating spreadsheets tedious, then this is the Zapier template for you. Every time a new employee is created in Personio, the employee will be added to a row in a selected Google Sheets spreadsheet.
- When this happens...
New EmployeeTriggers when a new employee is created.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Absence
Triggers when a new absence is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Candidate
Triggers when a new Candidate is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planOwner IDRequired
Category ID
Created On or After
Created Before
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planEmployee Updated
Triggers when an employee is updated.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planEmployment Terminated
Triggers when an existing employment is terminated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Open Position
Triggers when a new open position is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planJob 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project ID
EmployeeRequired
DateRequired
Start TimeRequired
End TimeRequired
BreakRequired
CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Attendance IDRequired
Date
Start Time
End Time
Break Time
Comment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee IDRequired
Category IDRequired
FileRequired
Desired File NameRequired
File Comment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee IDRequired
Include Pending
ActionThis is an event a Zap performs.SearchFind existing data in your appEmailRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEmployee IDRequired
EmployeeRequired
Absence typeRequired
Start dateRequired
End dateRequired
Half-day Off Start DateRequired
Half-day Off End DateRequired
Comment
Skip Approval
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundEmailRequired
File
File Title
Category ID
File Comment
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Attendance
Triggers when an employee or manager logs an attendance record for the day.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Employee
Triggers when a new employee is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Employment Created
Triggers when one or more Employment details of a Person are created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Employment Updated
Triggers when one or more Employment details of a Person are updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Attendance
Triggers when an attendace record is updated.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planEmployeeRequired
Absence typeRequired
Start dateRequired
End dateRequired
Half-day Off Start DateRequired
Half-day Off End DateRequired
Comment
Skip Approval
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.File
File Title
Category ID
File Comment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.File
File Title
Category ID
File Comment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOwner IDRequired
Document Name
Document Type
Category ID
Created On or After
Created Before
ActionThis is an event a Zap performs.SearchFind existing data in your appPerson ID
Email
First Name
Last Name
Include Absence Information
ActionThis is an event a Zap performs.SearchFind existing data in your appEmployee IDRequired
Include Pending
Project ID
EmployeeRequired
DateRequired
Start TimeRequired
End TimeRequired
BreakRequired
CommentRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Related categories
Related categories
Related Zap Templates
- Update Google Sheets rows for new absences in Personio
- Update Google Sheets rows when employees are updated in Personio
- Create Personio applicants from new Google Sheets rows
- Update Personio employees with new or updated rows in Google Sheets
- Update Google Sheets spreadsheets when employees are updated in Personio