This article will help you establish an SFTP connection from your HRIS provider to Workshop, allowing you to sync your employee contacts and lists.
Workshop's SFTP (SSH File Transfer Protocol) integration will allow you to sync data from HRIS providers such as ADP, Oracle, Workday and UKG. By integrating in this way, your employee data and distribution lists will sync over to Workshop on a cadence of your choosing (we recommend every 24 hours).
In your HRIS provider, you will need to configure the data that you would like to send to Workshop. At a bare minimum, we require five data fields:
- Employee ID: This is a unique identifier tied to each employee in your HRIS provider.
- Email: Your employee's email. Make sure this is their work email ( firstname.lastname@example.org ) and not their personal email to ensure email deliverability.
- First name: Employee's first or given name
- Last name: Employee's last or surname
- Phone number: Employee's personal or work phone number
These column headers should be formatted in the data using lower_snake_case, shown below:
id, email, first_name, last_name, phone_number
Follow the steps below to configure your SFTP Integration
- Visit Workshop's App Library
- Select the SFTP App and click "Add App" if you haven't already
- Navigate to the SFTP Manage Tab, which will display your SFTP credentials
- Add this information to your provider's export settings.
- In your provider, configure your data export to include the five required columns listed above.
- Add any additional columns of data you'd like to sync over to Workshop.
Some of the more common additional columns include: title, department, location, start date, birth date, employment status/classification.
These additional columns will enable more advanced list creation with Automatic lists as well as filtering of engagement data within Workshop. Add any columns you think are relevant and you would like to be able to use as constraints within Automatic Lists. You don't have to worry about the column headers for any of these columns, whatever you set them as is how they will appear in Workshop.
If you'd like to see an example CSV containing some sample data you can find that here: