Question

Is it possible to export BetterCloud Workflow Results to a Google Sheet?


Badge

Hiya! I’m currently working in a workflow and I’d like to either:
a) acquire a .csv of the results or
b) create an automation in order to have the results automatically populate a worksheet I’m working in.
Are either of these an option to me in BetterCloud?


13 replies

Userlevel 5
Badge +2

Oh, that's a cool idea. There's no way to export a csv of the results but there should be a way to feed them into a worksheet. Do you have access to the BetterCloud API by any chance? If so, we may be able to make something work


Open Thread in Slack
Badge

I believe so - what do you have in mind?


Open Thread in Slack
Userlevel 5
Badge +2

Cool, so we can potentially feed BetterCloud audit logs somewhere via a webhook (maybe a Google Sheet or SIEM tool)?


Open Thread in Slack
Userlevel 5
Badge +2

that's if you prefer the format of a spreadsheet


Open Thread in Slack
Userlevel 5
Badge +2

well, maybe a better question to ask is: what data would you like to see exactly? the steps of the Workflow? whether it complete successfully or not?


Open Thread in Slack
Badge

The data I’m trying to see are when the workflow is successfully completed, what it was successful in doing. Whether that is adding a new user or email accounts, etc into an environment that is already created. Feeding this data straight into a google sheet would be fantastic


Open Thread in Slack
Userlevel 5
Badge +2

another option -- we do have a Workflow Completion email that shows you every step the workflow took and whether or not it was successful


Open Thread in Slack
Userlevel 5
Badge +2

and it's likely a bit easier to digest than a dump into a CSV


Open Thread in Slack
Userlevel 5
Badge +2

so I've seen people send those emails into a dedicated BetterCloud Slack channel ... do you use Slack at your org?


Open Thread in Slack
Badge

We do use Slack in our org and we have some alerts setup so that we can see whether the workflow was successful


Open Thread in Slack
Badge

I’m more interested in what it was successful in doing - i.e.: if the workflow was to add a user to the org and it was done successfully, having a log of all of the users added to the org in a google sheet


Open Thread in Slack
Userlevel 5
Badge +2

I wrote up this guide for anyone looking to do this:
 

 


Open Thread in Slack

 

Badge

Nice!



Open Thread in Slack

Reply