Skip to content

Google Sheets + intelliHR

Google Sheets + intelliHR

Google Sheets + intelliHR integrations

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.

When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this!
Create TrainingCreates a new Training
ActionWrite

Start free with email

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Google Sheets and intelliHR

Discover other triggers and actions you can use with Google Sheets and intelliHR

- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write

- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Source Range
  Required
- Destination Range
  Required
- Paste Type
Action
Write

- Drive
- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Validation Type
  Required
- Input Message
- Strict Validation
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row count
  Required
- Output format
- First row
Action
Search
- Spreadsheet ID
  Required
- Include Grid Data
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
Job Remuneration Update Scheduled
Triggers when a Job Remuneration update is scheduled via the job update screen.
Trigger
Instant
Try It
New Job
Triggers when a new Job is created.
Trigger
Instant
Try It
New Training
Triggers when a new training record is created.
Trigger
Instant
Try It
- Company Start Date
  Required
- Company End Date
- Job Title
  Required
- PersonDescription
- ID
- Name
- Primary Email Address
- Employee Number
- Auto Incrementing intelliHR ID
- BusinessEntityDescription
- ID
- Name
- Legal Name
- Number
- BusinessUnitDescription
- ID
- Name
- LocationDescription
- ID
- Name
- Address
- SupervisorPersonDescription
- ID
- Name
- Primary Email Address
- Employee Number
- Auto Incrementing intelliHR ID
- SupervisorJobDescription
- ID
- Name
- WorkTypeDescription
- ID
- Name
- WorkClassDescription
- ID
- Name
- PayGradeDescription
- ID
- Code
- Name
- FTE
- RecruitmentSourceDescription
- ID
- Name
- Recruitment Cost
- Recruitment Currency
- Type
- Pay Cycle
- Currency
- Hours Per Cycle
- Base Annual Salary
- Base Hourly Rate
- AdditionsToBaseDescription
- AdditionsToBaseNames
- AdditionsToBaseTypes
- AdditionsToBaseValues
- AdditionsToBaseCurrencies
- AdditionsToBaseDefaultRemunerationComponentIds
- AdditionsToBaseDefaultRemunerationComponentNames
- AdditionsToTotalDescription
- AdditionsToTotalNames
- AdditionsToTotalTypes
- AdditionsToTotalValues
- AdditionsToTotalCurrencies
- AdditionsToTotalDefaultRemunerationComponentIds
- AdditionsToTotalDefaultRemunerationComponentNames
- BreakdownsDescription
- BreakdownsNames
- BreakdownsTypes
- BreakdownsValues
- BreakdownsCurrencies
- BreakdownsDefaultRemunerationComponentIds
- BreakdownsDefaultRemunerationComponentNames
- EmploymentConditionDescription
- ID
- Name
- Award Name
Action
Write
- Employee Number
- First Name
- Preferred Name
- Middle Name
- Last Name
  Required
- Primary Email Address
- Primary Phone Number
- Gender
- Date of Birth
- Emergency Contact Email
- Emergency Contact Name
- Emergency Contact Phone Number
- Emergency Contact Relationship
- UserDescription
- Is Enabled
- Username
- Send Welcome Email
Action
Write
- Completion Date
  Required
- Name
  Required
- PersonDescription
- ID
- Name
- Primary Email Address
- Employee Number
- Auto Incrementing intelliHR ID
- Job ID
- CoordinatorPersonDescription
- ID
- Name
- Primary Email Address
- Employee Number
- Auto Incrementing intelliHR ID
- ProviderDescription
- ID
- Name
- TypeDescription
- ID
- Name
- Hours
- Cost
- Currency
Action
Write
- JobRecordSearchDescription
- 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
Action
Write
- JobRecordSearchDescription
- Job ID
- Position Title
- Person ID
- Person Name
- Primary Email
- Employee Number
- Auto Incrementing intelliHR ID
- Effective From
  Required
- Effective To
- BusinessEntityDescription
- ID
- Name
- Legal Name
- Number
- BusinessUnitDescription
- ID
- Name
- Position Title
- LocationDescription
- ID
- Name
- Address
- WorkTypeDescription
- ID
- Name
- WorkClassDescription
- ID
- Name
- FTE
- PayGradeDescription
- ID
- Code
- Name
- SupervisorPersonDescription
- ID
- Name
- Primary Email Address
- Employee Number
- Auto Incrementing intelliHR ID
- SupervisorJobDescription
- ID
- Name
- Type
- Pay Cycle
- Currency
- Hours Per Cycle
- Base Annual Salary
- Base Hourly Rate
- AdditionsToBaseDescription
- AdditionsToBaseNames
- AdditionsToBaseTypes
- AdditionsToBaseValues
- AdditionsToBaseCurrencies
- AdditionsToBaseDefaultRemunerationComponentIds
- AdditionsToBaseDefaultRemunerationComponentNames
- AdditionsToTotalDescription
- AdditionsToTotalNames
- AdditionsToTotalTypes
- AdditionsToTotalValues
- AdditionsToTotalCurrencies
- AdditionsToTotalDefaultRemunerationComponentIds
- AdditionsToTotalDefaultRemunerationComponentNames
- BreakdownsDescription
- BreakdownsNames
- BreakdownsTypes
- BreakdownsValues
- BreakdownsCurrencies
- BreakdownsDefaultRemunerationComponentIds
- BreakdownsDefaultRemunerationComponentNames
- EmploymentConditionDescription
- ID
- Name
- Award Name
Action
Write
- User ID
  Required
- Username
- Is Enabled
Action
Write
- PersonDescription
- ID
- Name
- Primary Email Address
- Employee Number
- Auto Incrementing intelliHR ID
Action
Search

- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Condition Type
  Required
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to Copy
  Required
- Worksheet to Copy
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Confirm Deletion
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Format Type
  Required
Action
Write
- Spreadsheet
  Required
- Worksheet
  Required
- New Sheet Name
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Sort by Column
  Required
- Sort Order
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- A1 Range
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row ID
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
Job Update Scheduled
Triggers when a new Job update is scheduled via the job update screen.
Trigger
Instant
Try It
New Person
Triggers when a new person is created.
Trigger
Instant
Try It
- Identifier
- Business Unit Name
  Required
- Notes
- Parent ID
- Is Enabled
Action
Write
- Name
  Required
- Address
- parentId
Action
Write
- PersonDescription
- ID
- Name
- Primary Email Address
- Employee Number
- Auto Incrementing intelliHR ID
- File
  Required
Action
Write
- UserCopy
- Username
  Required
- Is Enabled
- PersonDescription
- ID
- Name
- Primary Email Address
- Employee Number
- Auto Incrementing intelliHR ID
Action
Write
- BusinessUnitDescription
- ID
- Identifier
- Name
- Identifier
- Business Unit Name
  Required
- Notes
- Parent ID
- Is Enabled
Action
Write
- PersonDescription
- 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
- EmailAddressesDescription
- EmailAddressesEmail
- EmailAddressesIsPersonal
- EmailAddressesIsPrimary
- PhoneNumbersDescription
- PhoneNumbers
- PhoneNumbersIsPersonal
- PhoneNumbersIsPrimary
- AddressesDescription
- AddressTypes
- FullAddresses
- Countries
- Postcodes
- States
- Streets
- Suburbs
Action
Write
- Field to Search
  Required
- Value to Search For
  Required
Action
Search

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn moreLearn moreHelpHelp

Related categories

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

About intelliHR

All-in-one people management system with configurable HR automation and analytics

Related categories

HR Talent & Recruitment

Related Zap Templates

Track updated jobs in intelliHR by creating rows in a Google Sheets spreadsheet

Related Zap Templates

Track updated jobs in intelliHR by creating rows in a Google Sheets spreadsheet