ABCDEFGHIJKLMNOPQ
1
To get started, make your own copy of this sheet by going to File > Make a copy
2
3
First, go to File > Make a copyUsing this sheet...Loading your current user list...
4
That'll save a personal, editable copy of this sheet for you to use.
Then, enter your Guru Username and API Token below.
You can find your API token on the API Access page.
Once you've saved your own personal copy of this sheet, user data is entered in the User and Group columns below. No changes are applied until you select an action from the Action column.

Check out this Guru Card for more details on how to use this sheet!
You may find it helpful to load your current user list from Guru into this sheet. Click the Load Users button to the right and it'll load your users and fill in the area below with your user data.

Note: this gives you a copy of the user list, but changes to your roster inside Guru will cause this sheet to become out of sync.
5
6
7
Username (email)
8
9
API Token
10
11
Action Are you sure? StatusUser (email address)Group 1Group 2Group 3Group 4Group 5Group 6Group 7Group 8Group 9Group 10Group 11Group 12
12
Invite and Add User to GroupsPlease enter your Username above.
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
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