Skip to main content
Question

Workato Integration? Anyone setup before?


andreammelde
Forum|alt.badge.img+3

Has anyone setup a connection with Workato integration? It is on GS’s website that it does an integration, but I am having a difficult time finding information on it. Any help would be appreciated!

anirbandutta
Forum|alt.badge.img+2

@jean.nairon do you have any tips about this?


gracefacex
  • Contributor ⭐️⭐️
  • December 16, 2024
andreammelde wrote:

Has anyone setup a connection with Workato integration? It is on GS’s website that it does an integration, but I am having a difficult time finding information on it. Any help would be appreciated!

Curious if you found success with Workato?


alexander.mahan
Forum|alt.badge.img+1

We use Workato for data integration to/from Gainsight. We don’t use any native Gainsight actions though, mostly just things like querying SQL, transforming the data to create a CSV and pushing that to the Gainsight hosted S3 bucket. What’s the use case you’re trying to implement Workato for?


Forum|alt.badge.img+1
  • Helper ⭐️⭐️
  • December 18, 2024

Hey ​@andreammelde 

 

What are you trying to do exactly?
We have the connection setup in Workato. Happy to talk through the connection part if’d you like! We are recently new to CS, so have not done much on that one, but we are using it daily for CC.

 

Thanks,

Anthony


gracefacex
  • Contributor ⭐️⭐️
  • December 18, 2024

Hi ​@ahamburg9 ​@alexander.mahan Thanks for replying! So, I am new to Gainsight and new to Customer Communities (help!). Our customer database runs on Salesforce, which is connected to Gainsight, but we are generally not yet able to easily connect the data from SF to CC. (like user profiles) Or, in a more specific instance, we want to see if our customer account managers be notified if their customer posts something in Product Ideas. We are open to various use cases, and are still trying to figure things out. Our company has Workato, and not Zapier, which seems to be more commonly used to create workflows between platforms. 


alexander.mahan
Forum|alt.badge.img+1

I’d say Zapier and Workato are very similar automation tools. They’re capable of the same things (for the most part) and really only differ in how you set them up. We don’t use CC in our org so I’m not familiar with how that data should natively integrate with CS or how it’s stored but Workato is pretty flexible and can likely adapt to what you need it to do.

For example, if the Product Idea data can be exported, either with a recurring report or possibly API integration, you could have workato do something like this;

  1. Workato job executes every afternoon.
  2. ​​SQL Query/API Call to pull Product Idea data.
  3. Transform data as necessary (CS can import CSVs from S3 via data designer or rules).
  4. Upload transformed data to Gainsight’s S3 bucket.
  5. (optional) Monitor series for errors to send email alerts to an Admin if the job fails repeatedly.

Then on the CS side you would set up that data design or rule to pull from S3 and store it in CS to report on or generate JO email alerts for your team.

I’d be happy to talk over specifics sometime. It’s hard to say exactly how it should be set up without knowing what the source data looks like. But it should be doable.


Forum|alt.badge.img+1
  • Helper ⭐️⭐️
  • December 18, 2024

@gracefacex

Welcome to Gainsight!

You should be able to see information in SF about community posts/ideas via standard Reporting in your SF instance.

Specifically to Workato:

Subscribe to a webhook in community (https://api2-us-west-2.insided.com/docs/community/#tag/Webhooks/operation/subscribeWebhook). Based on your question you would subscribe to 

Form here you would set up to Workato instance to listen to the event. The even will give user information such as email, and then you can go through the dance of finding the users SF Account Name, and then Account Manager, and finally send a slack message to that user.

Here is an example we use at my company:

Users in SF submits an idea post a slack message.

And then you can configure the slack message as followed.
 

 

Hopefully this is somewhat helpful.

Thanks,

Anthony


gracefacex
  • Contributor ⭐️⭐️
  • December 22, 2024

@alexander.mahan ​@ahamburg9  Thank you both so much for responding so quickly! 😃 I’ll go back to the team with this, so we can explore the most useful workflows and integrations. 


Forum|alt.badge.img+1
  • Helper ⭐️⭐️
  • December 22, 2024

You can alway PM me or we can talk further here, if you have more questions. I tend to geek out on this stuff, so happy to share more info as wanted!

 

Thanks,

Anthony


Forum|alt.badge.img+1
  • Helper ⭐️⭐️
  • December 22, 2024

@andreammelde - similar to what is talked about with Workato and Customer Community.
My company has set up a couple of External Action APIs, which essentially post data to Workato in the form of a webhook.

 

From here you can manipulate data and send it to where you would like.


alexander.mahan
Forum|alt.badge.img+1
ahamburg9 wrote:

​… My company has set up a couple of External Action APIs, which essentially post data to Workato in the form of a webhook. From here you can manipulate data and send it to where you would like.

 

That’s brilliant! I’ve used the external action APIs for writing to custom fields GS in system objects but never thought of using it to trigger… well.. external actions.


Forum|alt.badge.img+1
  • Helper ⭐️⭐️
  • December 27, 2024

We are knew to CS, but we recently did this to Google Sheets. Once you get it to Workato, obviously you can pretty much do anything.

 

Glad I stumbled upon this question! Love all this kind of stuff.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings