Writing BetterCloud Audit Logs to a Google Sheet

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

1. Make a copy of this Sheet: https://docs.google.com/spreadsheets/d/1L1cst1jwEmrQms0JvOOrMzFQDJ3yZ_3rhtY_7IfJXrQ/edit#gid=0
2. Navigate to Tools > Script Editor
3. Replace the sheetId variable in Line 1 with your Sheet ID
   This will look something like: 1J8w43QDlUj6Lu3sRkFZEdswZYgTfSdsQIwU1xTxCM28
4. Save the script by clicking the ‘Save project’ floppy disk icon

5. On the top right of the script, click ‘Deploy’ > New Deployment

6. Set a Description (ie .. BetterCloud Logs) and set ‘Who has Access’ to ‘Anyone’

   

    

7. Click Deploy
8. Authorize this app to have access to your Google account
9. Copy the ‘Web App URL’

BetterCloud

1. Navigate to: Integration Center > Create a Custom Integration
2. Configure the Integration like so, and click Save:
    

   

    

3. In the Extensions section, click  Get Started > Send a Push Event > Next
4. Configure the Push Event like so:
    

   

5. In the Test your Push Event section, choose Event Log Written and click Run Test.
6. Check the Google Sheet and confirm that a test log was written
7. Click Save on the bottom right