Google Sheets + MyHR
Create spreadsheet rows in Google Sheets for newly activated persons in MyHR
Easily manage your employee data with this workflow for MyHR to Google Sheets. When a new person becomes active on MyHR, this automation creates a row in Google Sheets, which helps keep your employee database up-to-date. It's a practical solution for HR professionals to track personnel updates and maintain accurate records without manual input.
Easily manage your employee data with this workflow for MyHR to Google Sheets. When a new person becomes active on MyHR, this automation creates a row in Google Sheets, which helps keep your employee database up-to-date. It's a practical solution for HR professionals to track personnel updates and maintain accurate records without manual input.
- When this happens...Person Has Been Activated
Triggers when person is made active.
- automatically do this!Create Spreadsheet Row
Create a new row in a specific spreadsheet.
- Free forever for core features
- 14 day trial for premium features & apps
Person Signed Their Employment Agreement
Triggers when an employment agreement is signed by a person.
Try ItLeave Has Been Cancelled
Triggers when leave is made cancelled.
Try ItPerson Has Been Deactivated
Triggers when person is made inactive.
Try ItFirst NameRequired
Last NameRequired
EmailRequired
Gender
Title
Phone number
Street address
Suburb
City
Postcode
New or existing
Start date
Contract start date
Visa type
Work visa expiry date
Birth date
Job title
Job purpose
Job specific duties
Job education
Job description
Department
Manager name
Manager title
Type of employment
End date
Reason for fixed term
Maximum weekly hours of work
Weekly hours of work
Pay type
Pay rate
Pro-rata
Pay period
Pay day
Other pay or benefits
Notice period
Primary work location
Collective agreement
Trading name
Bank name
Bank account number
Bank account name
Emergency contact name
Emergency contact relationship
Emergency contact daytime phone
Emergency contact after hours phone
Additional information
Self service
Performance reviews
Leave enabled
IRD number
Tax code
Leave Has Been Approved
Triggers when leave is made approved.
Try ItPerson Has Been Activated
Triggers when person is made active.
Try ItFirst NameRequired
Last NameRequired
EmailRequired
Gender
Title
Phone number
Street address
Suburb
City
State
Postcode
New or existing
Start date
Contract start date
Visa type
Work visa expiry date
Birth date
Job title
Job purpose
Job specific duties
Job education
Job description
Department
Manager name
Manager title
Type of employment
End date
Reason for fixed term
Maximum weekly hours of work
Weekly hours of work
Pay type
Pay rate
Pro-rata
Pay period
Pay day
Other pay or benefits
Notice period
Primary work location
Collective agreement
Trading name
Bank name
Bank account number
Bank account name
Emergency contact name
Emergency contact relationship
Emergency contact daytime phone
Emergency contact after hours phone
Additional information
Self service
Performance reviews
Leave enabled
Employment stateRequired
Tax file number
Tax scale
Contractor business number
Services
Tax-free threshold claimed
Person Unique IdRequired
