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 Row
Triggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!Create Training
Creates 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 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 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
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 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 foundJob 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