In addition to the good advice from others, you may find this helpful:
Link to a post of a simple Google docs spreadsheet I made that leverages the intervals.icu API to output what I think you are after.
I made a local copy of the spread sheet, entered athlete ID: and API Key: but nothing has happened.
also import data botton at “Daily Record” tab is inoperante.
Appreciate any help.
Tks
What device did you try this on? Unfortunately those buttons (and scripts) can not be triggered on mobile devices - a limitation of Google sheets.
Solution I found for mobile use was to initially set up on a computer, and then set up a regular time-based trigger to run the script that the button initiates.
1 Like
Regular notebook w11
Local copy using Excel
Running it in Excel is why it’s falling over. The script which calls the data from the API is Google Sheets specific, it will not run as an Excel macro.
3 Likes
Can you click the “dispensar” / details dialog and share what that says?
There is some github code this calls to which you need to provide permissions for in order for the sheet to function / receive data from the intervals api. That’s the only thing that I can think of that might be causing a problem now without more info about the specific error you are getting.
1 Like
no further info in that…
thinking broadly 
Can’t it be due to date format or any other unit?
I live in Brazil.
date is DD/MM/YYYY
and the units are metric sistem.
Your sheet is view only and doesn’t allow to edit the red blocks, Athlete ID and API key.
Should those cells not be unprotected to allow the data to be changed?
The Import data button also is inactive.
1 Like
Hi Gerald, you should be able to take a copy and then put in that info in your own version. Probably not a good idea to be putting that personal intervals.icu account info in a widely shared Google doc!
Ah that’s tricky. When I’ve had that dialog the details/dispensar bit has provided a bit more info as to what went wrong. Hard for me to troubleshoot further since the version with my intervals.icu account details in works fine…
That shouldn’t be an issue - since I understand you are getting the issue with the API call rather than any subsequent calcs.
It has “kind of” worked.
Tab “intervals_activities-export” has been populated but all others don’t show anything.
tks,
1 Like
Glad to hear it’s at least pulling data from intervals.icu for you now! Did you do anything different from your previous attempts?
I’ve figured out why the other sheets are not populating - I was a bit over-zealous when clearing out my data to share the file. As you can see in your first screen shot Column A is blank, but this should have dates in it which are then used as references to pull data across to the other sheets. I have updated the shared file now with the formulae that should be in that column, If you go back to the shared file you need to copy across column A from the sheet “intervals.icu_activities-export”. Or copy the whole updated shared file and re-enter your details in the red boxes.
2 Likes
All sorted.
I saved a copy in my Google Drive, but I see I was trying to open your file, not the copy I made.
I will test and give my objective feedback.
2 Likes
Now it’s working. Tks to you and to @Andrii_Magalich.
I might have missed the explanation of the rational behind the “Potential Next Activity with training load of”.
What is it trying to accomplish? to keep you in the “optimal” Form(TSB) zone? any periodization ( going to fresh)?
Any possible input of Fitness CTL ramp rate?
Appreciate your work.
Best regards,
PS:
I’m confused:
I had a load yesterday but it shows zero for status as "Next activity Tomorrow and gives me a load for Next Activity Load.
If I choose status as Next activity Today it shows my today’s load and gives zero as load for Next Activity.
The way I understand it, the next load is 58; look a few rows below.
The workout suggestion is then shown below:
25min of VO2 work down to 58m of Endurance (L2, or Z2 as some refer to it).
Me too but look right bellow on “Prior daily Load”. It shows zero but I do have a load of 25 from yesterday.
And, If I change to “Next activity Today” “Prior daily Load” we get my today’s load of 109 and no prescription for the next activity.
I’m trying to understand “Next Activity Tomorrow” vs “Next Activity Today”.
Also, what is this recommendation based on?
William should answer the first part of your question, as I do see a Prior daily load if I have done something on the same day. The lookup is in row 5, when I believe it should be row 6.
The recommendation is based on the load needed to get to green. Load is dependent on the intensity and duration, which is what the table below the recommendation. The higher the intensity, the shorter the duration.
(1) The load from the last workout, providing it’s the same day
(2) The next activity load is the shortfall from keeping the form in green
(3) The various workout durations will give different loads.
1 Like