Sometimes it's helpful to supplement existing People data with data from a Google sheet.
To do this, you need to first publish your sheet by going to Share > Publish to web:
Choose Comma-separated values (.csv) as the format, select the sheet to publish and optionally check Automatically republish when changes are made:
You will then be shown the published URL which you will need to cut and paste into Trelica:
Trelica will synchronise the following column names:
|Employee Id||Employee Ref|
|Name||Full Name, Employee Name|
|Location||Office, Place of Employment, Work Address|
|Start Date||Hire Date, Date of Employment|
|Leaving Date||Termination Date, Termination|
|Person Type||Type, Employee Type|
|Line Manager Email||Manager Email|
Trelica accepts different capitalization or spacing.
Please sign in to leave a comment.