[PUBLIC] Ethena Google Sheets Integration Template

	A	B	C	D
1	Ethena Google Sheets Integration Instructions
2	1. Make a copy of this Google Sheet
3	2. Fill out the 'User List' tab with your employee list. Delete any columns you don't plan on using (e.g. delete 'name' and 'preferred_name' if you plan on using 'first_name' and 'last_name' instead.
4	3. Click 'Share' and add ethena-hris-sync@symbolic-math-469114-c1.iam.gserviceaccount.com as a Viewer.
5	4. Go to https://app.goethena.com/settings/integrations/hris and select Google Sheets > Connect.
6	5. Choose 'No Override' then 'Continue.'
7	6. Click 'I've Shared My Spreadsheet With Ethena.'
8	7. Enter the spreadsheet ID found in the Google Sheets URL. The spreadsheet ID is the long string between /spreadsheets/d/ and /edit.
9	8. If you make no changes to our template spreadsheet, the Sheet Range should be User List!A:O. If you make any changes to the sheet name or columns, adjust the sheet range accordingly.
10	9. Select 'Connect Spreadsheet.'
11
12	Column Instructions
13	Column Name	Required?	Example Value	Details
14	id	Yes	5234	This identifier should be unique for each worker. Having a unique ID allows Ethena to track workers even if names or emails change.
15	name	Must include either name, preferred name, or first name/last name	Joseph Jones	Employee's full name.
16	preferred_name		Joe Jones	Employee's full preferred name.
17	first_name		Joseph	Employee's first name.
18	last_name		Jones	Employee's last name.
19	email	No	jjones@acmecorp.com	Employee's email address. Not required for users without emails.
20	country	Yes	USA	Ethena will attempt to match full country names, but using the 3 letter ISO code is preferred.
21	state	Yes (if country is USA)	NY	Two-letter state code
22	manager_id	No (recommended)		This column will allow you to establish appropriate supervisory relationships within Ethena. The values in this column should match what’s provided in the ID field and represent who the worker in a given row reports to.
23	is_manager	Yes	Yes	Set this field to “Yes”, “true”,“Y”, or “1” if the worker in a given row is a manager.
24	department	No	Sales	This optional field will be used to identify a user's department.
25	office	No	HQ	This optional field will be used to identify a user's office. Many customers also use this spot to store any 'extra' fields other than the standard ones, that may be valuable for reporting.
26	employee_type	No	Full Time	This optional field will be used to identify a user's worker type.
27	start_date	No	9/18/2022	If filled, Ethena will only sync workers where the date in this field is today or in the past.
28	employment_status	No	Active	If filled, Ethena will only sync workers that have one of “active”, “current” “employed” or “working” in this field (case insensitive). To terminate users, you can either remove them from the report altogether, or mark their status as something like "terminated" or "inactive."
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100