Samsara API Connect is a Google Sheets Add-On for accessing Raw Samsara Sensor Data.
To best use this API interface please reference SamsaraAPI reference Page.
Not all listed API Calls in the Samsara reference page are available through this interface. Only the most common GET calls are available. If you'd like a particular one added please contact me for a custom caller.
1): Run the "Add Core Sheets" to create the initial tabs needed to run this interface.
2). Edit the API Controller using the "API Call Control" option. Here you can enter the values your API will need to create a call. Fill in teh form adn select submit.
2.5). When calling /sensors/temperature and sensors/humidity you'll need to provide a list of sensor Id's and when using the sensors/history, you'll need to provide the sensors Id along with an additional variable (See API-Sensor Series Tab). Use the provided core forms for providing the values.
Note: You can create multiple SensorLists and SensorSeries Lists using the same format and simply update the fields at the bottom of the API Call Control with the name of the Tabs holding the lists.
3). Once you've filled in the information. Just select "Run API Call" and the API-Response tab will display the reply.
As a bonus, I've added the Epoch to Date to Epoch formulas In a reference window so as to make it easier when working with the raw data. Just select ' Epoch Formulas'
Any questions feel free to reach out: jvargas.sayuga@gmail.com
If you run into any troubles with the Interface, please feel free to email me at any time referencing the most recent error listed under your "Recorder" tab.