I am not a developer so I don't know what the best way to do this is.
Basically, I need someone to code or at least tell me how to implement an API that will allow me to pull data from a website automatically and have it update on excel.
The way I have done this before for bitcoins price on coinmarketcap is by going to DATA- Webpage.
However this API looks like it might be harder as it needs some code since it is a password protected webpage.
Here are the developer's notes from the site:
https://www.samsara.com/api , look it over and if it is something you can get to automatically update on excel, then PM me.