Hi, I'm an experienced Google Apps Scripts developer. You can capture the data sent from anywhere, including Samsara to your Google Sheets by making it a web app. This will give you two endpoints (aka webhooks) to which you can send data. I know how this can be done and, I can code such functionality for you.
If you'd like to discuss your project with me then send me a message even when I appear offline. I typically reply within a few minutes when online otherwise in a few hours when offline.