Google Sheets + intelliHR
Upload training information in intelliHR using Google Sheets
Upload bulk training information using Google sheets (make sure all training fields are created as separate columns e.g. Employee ID, employee name, course name, completion date, training type, provider, cost, hours, etc.) whenever a new spreadsheet row is added.
Upload bulk training information using Google sheets (make sure all training fields are created as separate columns e.g. Employee ID, employee name, course name, completion date, training type, provider, cost, hours, etc.) whenever a new spreadsheet row is added.
- When this happens...
New Spreadsheet RowTriggered when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create TrainingCreates a new Training
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier 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.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
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
Bottom-Up
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
Job Update Scheduled
Triggers when a new Job update is scheduled via the job update screen.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Person
Triggers when a new person is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Identifier
Business Unit NameRequired
Notes
Parent ID
Is Enabled
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Address
parentId
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Person Description
ID
Name
Primary Email Address
Employee Number
Auto Incrementing intelliHR ID
FileRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.User Copy
UsernameRequired
Is Enabled
Person Description
ID
Name
Primary Email Address
Employee Number
Auto Incrementing intelliHR ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Business Unit Description
ID
Identifier
Name
Identifier
Business Unit NameRequired
Notes
Parent ID
Is Enabled
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Person Description
ID
Name
Primary Email Address
Employee Number
Auto Incrementing intelliHR ID
First Name
Middle Name
Last Name
Preferred Name
Date of Birth
Gender
Employee Number
Title
Emergency Contact Email
Emergency Contact Name
Emergency Contact Phone Number
Emergency Contact Relationship
Email Addresses Description
Email Addresses Email
Email Addresses Is Personal
Email Addresses Is Primary
Phone Numbers Description
Phone Numbers
Phone Numbers Is Personal
Phone Numbers Is Primary
Addresses Description
Address Types
Full Addresses
Countries
Postcodes
States
Streets
Suburbs
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Field to SearchRequired
Value to Search ForRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
No 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 ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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 To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
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
Text Bold
Text Italic
Text Strikethrough
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
Bottom-Up
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundJob Remuneration Update Scheduled
Triggers when a Job Remuneration update is scheduled via the job update screen.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Job
Triggers when a new Job is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Training
Triggers when a new training record is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Company Start DateRequired
Company End Date
Job TitleRequired
Person Description
ID
Name
Primary Email Address
Employee Number
Auto Incrementing intelliHR ID
Business Entity Description
ID
Name
Legal Name
Number
Business Unit Description
ID
Name
Location Description
ID
Name
Address
Supervisor Person Description
ID
Name
Primary Email Address
Employee Number
Auto Incrementing intelliHR ID
Supervisor Job Description
ID
Name
Work Type Description
ID
Name
Work Class Description
ID
Name
Pay Grade Description
ID
Code
Name
FTE
Recruitment Source Description
ID
Name
Recruitment Cost
Recruitment Currency
Type
Pay Cycle
Currency
Hours Per Cycle
Base Annual Salary
Base Hourly Rate
Additions To Base Description
Additions To Base Names
Additions To Base Types
Additions To Base Values
Additions To Base Currencies
Additions To Base Default Remuneration Component Ids
Additions To Base Default Remuneration Component Names
Additions To Total Description
Additions To Total Names
Additions To Total Types
Additions To Total Values
Additions To Total Currencies
Additions To Total Default Remuneration Component Ids
Additions To Total Default Remuneration Component Names
Breakdowns Description
Breakdowns Names
Breakdowns Types
Breakdowns Values
Breakdowns Currencies
Breakdowns Default Remuneration Component Ids
Breakdowns Default Remuneration Component Names
Employment Condition Description
ID
Name
Award Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee Number
First Name
Preferred Name
Middle Name
Last NameRequired
Primary Email Address
Primary Phone Number
Gender
Date of Birth
Emergency Contact Email
Emergency Contact Name
Emergency Contact Phone Number
Emergency Contact Relationship
User Description
Is Enabled
Username
Send Welcome Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Completion DateRequired
NameRequired
Person Description
ID
Name
Primary Email Address
Employee Number
Auto Incrementing intelliHR ID
Job ID
Coordinator Person Description
ID
Name
Primary Email Address
Employee Number
Auto Incrementing intelliHR ID
Provider Description
ID
Name
Type Description
ID
Name
Hours
Cost
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Job Record Search Description
Job ID
Position Title
Person ID
Person Name
Primary Email
Employee Number
Auto Incrementing intelliHR ID
End Date
Should Not Finalise End Date
Should Retain User Account
Turnover Type
Turnover Reason
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Job Record Search Description
Job ID
Position Title
Person ID
Person Name
Primary Email
Employee Number
Auto Incrementing intelliHR ID
Effective FromRequired
Effective To
Business Entity Description
ID
Name
Legal Name
Number
Business Unit Description
ID
Name
Position Title
Location Description
ID
Name
Address
Work Type Description
ID
Name
Work Class Description
ID
Name
FTE
Pay Grade Description
ID
Code
Name
Supervisor Person Description
ID
Name
Primary Email Address
Employee Number
Auto Incrementing intelliHR ID
Supervisor Job Description
ID
Name
Type
Pay Cycle
Currency
Hours Per Cycle
Base Annual Salary
Base Hourly Rate
Additions To Base Description
Additions To Base Names
Additions To Base Types
Additions To Base Values
Additions To Base Currencies
Additions To Base Default Remuneration Component Ids
Additions To Base Default Remuneration Component Names
Additions To Total Description
Additions To Total Names
Additions To Total Types
Additions To Total Values
Additions To Total Currencies
Additions To Total Default Remuneration Component Ids
Additions To Total Default Remuneration Component Names
Breakdowns Description
Breakdowns Names
Breakdowns Types
Breakdowns Values
Breakdowns Currencies
Breakdowns Default Remuneration Component Ids
Breakdowns Default Remuneration Component Names
Employment Condition Description
ID
Name
Award Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.User IDRequired
Username
Is Enabled
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Person Description
ID
Name
Primary Email Address
Employee Number
Auto Incrementing intelliHR ID
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsAbout intelliHR
All-in-one people management system with configurable HR automation and analytics