This guide will walk you through how you can use BetterCloudâs API offering to push your BetterCloud Audit Logs to an external service. In this case, we are using Google Sheets, but this is applicable to any other system youâd like to push your Audit Logs (or other information) out to. We put this guide together based on the following conversation:Â
If you have any questions, suggestions, or issues leave a comment below.
Â
Google Sheet / Apps Script
- Make a copy of this Sheet:Â https://docs.google.com/spreadsheets/d/1L1cst1jwEmrQms0JvOOrMzFQDJ3yZ_3rhtY_7IfJXrQ/edit#gid=0
- Navigate to Tools > Script Editor
- Replace the sheetId variable in Line 1 with your Sheet ID
This will look something like: 1J8w43QDlUj6Lu3sRkFZEdswZYgTfSdsQIwU1xTxCM28 - Save the script by clicking the âSave projectâ floppy disk icon
-
On the top right of the script, click âDeployâ > New Deployment
-
Set a Description (ie .. BetterCloud Logs) and set âWho has Accessâ to âAnyoneâ
Â
- Click Deploy
- Authorize this app to have access to your Google account
- Copy the âWeb App URLâ
Â
BetterCloud
Note: you will need to have the BetterCloud API in order to access this
- Navigate to: Integration Center > Create a Custom Integration
- Configure the Integration like so, and click Save:
ÂÂ
- In the Extensions section, click  Get Started > Send a Push Event > Next
- Configure the Push Event like so:
 - In the Test your Push Event section, choose Event Log Written and click Run Test.
- Check the Google Sheet and confirm that a test log was written
- Click Save on the bottom rightÂ
Â