A Google App-Script library to use the MyGeotab API directly from within your Google Sheets as custom functions.
It allows you to easily add a formula in your Google Sheet, such as
=MGTRIPS("Company Van")
This function will return the recent Trips for the vehicle named Company Van.
Google sheets will provide you with help if you type the function name inside the cell. For example =MGTRIPS(
If you want to use this in a Google Spreadsheet - open the script editor and add all the files in the scr folder to the project. Note that you should rename the .js files to .gs.