Google Sheets + TalentHR
Add new TalentHR employees to Google Sheets rows
Track and manage your employee details effortlessly with this Zap. Once active, this Zapier integration will automatically add each new TalentHR employee to a Google Sheets row.
Track and manage your employee details effortlessly with this Zap. Once active, this Zapier integration will automatically add each new TalentHR employee to a Google Sheets row.
- When this happens...
New EmployeeTriggers when a new employee is created.
TriggerInstantThis event starts a Zap instantly. - 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
Time Off Request Approved
Triggers when a time off request is approved.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deleted Employee
Triggers when an employee is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Time Off Request
Triggers when an employee requests time off.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Time Off Request Rejected
Triggers when a time off request is rejected.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Employee
Triggers when an employee is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Absence Info
Start DateRequired
End Date
Employee
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DepartmentRequired
NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmployeeRequired
Basic Info
First NameRequired
Last NameRequired
Employee Number
Date of Birth
Gender
Marital Status
Citizenship
Address
City
Country
Postal Code
Contact Info
E-mailRequired
Personal Email
Phone
LinkedIn (URL)
Emergency Contact
Full Name (Emergency Contact)
Address (Emergency Contact)
Phone (Emergency Contact)
Relationship Type (Emergency Contact)
Other
Secondary Address
Secondary City
Secondary Postal Code
Secondary Country
Twitter (URL)
Facebook (URL)
Instagram (URL)
Pinterest (URL)
Github (URL)
Behance (URL)
Skype Name
Allergies
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LocationRequired
NameRequired
AddressRequired
RemoteRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Get Summary of Who's Out
Retrieve a list of employees who are out of the company the following days.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
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
New Employee
Triggers when a new employee is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New ATS Application
Triggers when a new job application is submitted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Job Published in ATS
Triggers when an ATS job position is published.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Job Unpublished From ATS
Triggers when an ATS job position is unpublished.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
Last NameRequired
E-mailRequired
Date of HireRequired
Employee Reports to
Employment StatusRequired
Location
Division
Job Title
Department
Payment
Payment Schedule
Payment period
Overtime Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
AddressRequired
RemoteRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Time Off Request IDRequired
AcceptRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DivisionRequired
NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Job TitleRequired
NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmployeeRequired
FilenameRequired
DocumentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SearchRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNo 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
