Tutorial: Quick Weekday Analysis with Oura Cloud and Google Sheets

This quick tutorial was originally published in the Oura Insider newsletter. If you want to be the first to get the latest news and tutorials like this, make sure you’re subscribed here.

Is Monday as bad as people say it is? Is your heart rate lower on certain days? In this quick tutorial we’ll be using a CSV export from Oura Cloud and a Google Sheets template to figure that out.

This is a step-by-step guide so it’ll be fairly lengthy, but the idea is simple. All you need is an Oura ring and a Google account. This is the type of chart you’ll be making, with your own data of course. The charts shows your average lowest heart rates by weekday.

1. Export a CSV from Oura Cloud

1. Log into Oura Cloud with your Oura account.
2. Navigate to Trends from the left-hand navigation.
3. Make sure Lowest Resting HR is the only metric.
4. Make sure you’ve chosen Daily in the top right corner.
5. Choose the time period you want to look at by dragging the selector.
6. Click Export Data and click Download

2. Duplicate a ready-made Google Sheet template

1. Open this Google Sheet
2. Log in to your Google account if you’re not logged in already. From the top navigation, choose File > Make a Copy… If it’s greyed out, you need to log in.
3. Save the new spreadsheet to someplace nice
4. The sheet will be empty except for a chart that says No data. That’s OK.

3. Import the CSV

1. In your copy of the Google Sheet, click File > Import…
2. Choose the last tab “Upload”. Drag and drop in the Oura Cloud CSV file you exported in step 1.5.

3. A dialog box will pop up. You’ll need to make sure these options have been chosen:
– Append to current sheet
– Detect automatically
​- Yes

4. Click Import data
5. You’ll see dates in column A and numbers in column B. We’re almost there, but we’ll need to do some formatting to make the chart easier to read.

4. Clean up the formatting

1. Choose everything in column A. You can do that by clicking on the header cell that says A.
2. Go to Format > Number > More Formats > More Date and Time Formats…

3. Click on the Day.

4. Choose the Day as abbreviation (Tue).

5. Delete all other metrics (such as Month or Year). Click on the name, then choose Delete. Click Apply.

6. The chart should look better now but it still has some unwieldy decimals that make it hard to read.
7. Choose everything in column B. Tap the Increase Decimals icon twice.

8. Done! The chart now shows you your average lowest resting heart rates per weekday. What differences can you see? If you want to see what affects your night-time heart rate, read this article.

Please note that the chart starts from whatever day is in cell A2. In the example the first day is a Monday, so the chart starts from Monday. For the fastest way to choose the starting day, remove rows from the top until whatever day you want to start with is in cell A2. (It may not be pretty, but it gets the job done.)

National Winner Nordic Startup Awards 2017 Reddot Award 2018 Winner European Union - European Regional Development Fund leverage from the EU 2014-2020