Question

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

W
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

mike-bc
Rank
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
W
Badge

I believe so - what do you have in mind?


Open Thread in Slack
mike-bc
Rank
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
mike-bc
Rank
Userlevel 5
Badge +2

that's if you prefer the format of a spreadsheet


Open Thread in Slack
mike-bc
Rank
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
W
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
mike-bc
Rank
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
mike-bc
Rank
Userlevel 5
Badge +2

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


Open Thread in Slack
mike-bc
Rank
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
W
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
W
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
mike-bc
Rank
Userlevel 5
Badge +2

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

 


Open Thread in Slack

 

dylanrabdau4
Badge

Nice!



Open Thread in Slack

Reply