ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Time ZoneEurope/London
DO NOT EDIT GREY CELLS BELOW
2
Default Days to Load300
<< Change this to pull this number of days worth of history
3
Last Updated
4
Record Count
5
Username
6
Whoop User ID
7
Access Token
8
Token Expiry
9
Refresh Token
10
Last Token Refresh
11
Day of Week Setting2
See also: https://support.google.com/docs/answer/3092985?hl=en
12
13
2 Very important notices:
DO NOT MODIFY ANY CELL EXCEPT THE TimeZone or the Default Days to Load
DO NOT SHARE THIS SPREADSHEET ONCE YOU USE IT - It will contain your Whoop Tokens which can be used to access your Whoop data as you.

Changing Timezone
TimeZone should be something like America/New_York, Asia/Jerusalem, or Europe/London (standard timezones from the TZ Database - use the 'TZ Database Name' here: https://en.wikipedia.org/wiki/List_of_tz_database_time_zones

INSTRUCTIONS FOR BASIC SETUP: (Make sure you're using Google Chrome)
0) Make a copy of this sheet into your own Google Drive
1) using the Whoop Menu item above, select 'Login' and a sidebar will appear)
2) Enter email and password for whoop as prompted (PASSWORD IS NOT STORED!)
3) This will show you your tokens and populate the gray bars above
4) Click 'Reload Data (legacy) or (V1/new) in the Whoop Menu' once you've done this. - This will populate the 'Whoop Worksheet'
5) You can reload data (fully or incremental) whenever you like.
6) Click 'Load Incremental' to only load data since the last load (This relies on the last valid date in the spreadsheet's Date Column)

HOW TO MAKE THIS AUTOMATICALLY REFRESH:
6) Go to 'Extensions->Apps Script' in the above menu
7) In the left hand sidebar, click the 'Clock' to show/edit triggers
8) You should see an empty list of 'triggers' on a new tab. On the bottom right corner, there's a blue '+ Add Trigger' button. Click that to create a new trigger.
A) Choose function 'v1_get_incremental_history' for the new functionality, or 'whoop_get_incremental_history' for the legacy one. This will populate the WhoopV1 or Whoop sheets accordingly.
B) deployment can be 'Head'
C) event source should be 'Time Driven'
D) Type of time based trigger should be 'Hour Timer' or 'Day Timer' depending on frequency'
E) Day interval you can just choose the time of day to import. Hour interval should be every 8-12 hours - Don't do this too frequently!
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