I run Google Sheets in a tab in my Chrome browser, and I find that after running the macro to download the wellness data it helps to refresh the Google Sheets tab. If you haven’t tried that already try it and see if it helps.
FWIW my version downloaded the other day works exactly as expected, as does one I bodged together myself, based on Olly’s earlier file.
I’m finding the graph display to be quite helpful in deciding what training to do - many thanks to all involved in this.
Robert
@Olly_Thomas confirmed that this is working, so here we go:
From now on, the Import script will run every 2 hours (or what you set) and it will run server-side. This means that you don’t have to do anything and your data will be updated every 2 hours. Just open the sheet on any device and you will see the values from the last update.
Don’t ask millions of questions, I don’t know anymore about it 
. Just Google if you have other wishes.
Does it show today’s data in the columns A, B, C, etc?
Nice job!
I’ve set to “immediately” so I take my morning HRV and right after I can open the sheet at the mobile and get the prescribed action.
Thank you all,
I have the same problem not getting a graph result for today. I think I know why this happens. There is a bug in the code.
If you try to show the graph when the data for today is still empty, you get a row on the HRV calc tab with only todays date. The data sorting, further right on that page, sets the points to plot and is updating when new data comes in. But the graph isn’t updating.
Unfortunately this isn’t working…
Back to the desktop …
After running the import macro, I don’t see values in the HRV_Calc sheet until I’ve reloaded the spreadsheet (I have the spreadsheet in my Google Drive).
It’s been working well for me after data import and reloading.
Robert
Is there any update so we can have the background colors for the cells RHR Z-Score and HRV Z-Score so i dont need to change between sheets to see what day i was tired or needed recovery?
Thanks
In the google sheets version? Do you mean these columns coloured to reflect the colours on the main graph?
Yes, is it possible? Does anyone else feel the need of that future or just me? 
Conditional formatting will sort that. Let me me know if assistance is required.
Hi, I’m new to codes… I’d like to use the google sheet I downloaded from excel but when I enter my data (about 35 days: date, RHR and HRV) I don’t have any points showing on the graph. What am I doing wrong? thanks all
Is it the Google sheets file you’re having issue with or the Excel file?
I don’t understand this bit - I’d like to use the google sheet I downloaded from excel
I don’t use the Google sheets version at all but might be able to assist if it’s the excel sheet you’re having issue with
Désolé, j’ai fait une erreur dans ma phrase, j’ai téléchargé le fichier Excel à partir de votre feuille Google (Intervals_API_Tools_Office365_v1.5). J’ai un problème avec les points qui ne s’affichent pas dans mon fichier excel. Merci
Ah. I understand now. You downloaded the Excel from from Google Drive?
What is the issue exactly with the excel sheet? I can try to help. My French is very limited though.
You shouldn’t have to enter data on the excel sheet. It should automatically refresh. I will post screenshots detailing what to do
Enter AthleteID in ‘ReadMe’ sheet
Data > Get Data > From Web
Enter this url - https://intervals.icu/api/v1/athlete/xxxxxx/wellness.csv (xxxxx is your athlete id )
Then go to
Data > Get Data > Data Source Settings > Global Permissions > Edit Permissions > Edit > Basic
username is API_Key. password is your api number
Set privacy levels to none
That should be it I think. There are a couple of errors that might pop up the first time you login. These are covered in the ReadMe sheet
Thanks lot, i send you a message. Have you see ?
