I’ve created an example using the Microsoft Text Analysis. The robot gets the message from the first column of the tickets.xlsx excel file and writes back the sentiment and the key phrases.
I’ve used a Get Password activity at the beginning of the process. Enter the key there and run the workflow.
Cognitive.zip (9.2 KB)
For those who are interested in cognitive services and those who may still lookup this post for support, even if it is already an older one: On https://ikava.ch/robolab you can download a custom UiPath activity that allows to consume also the Google Speech to Text API from within UiPath. The downloadable *.zip file also contains a manual with detailed instructions how to setup a Google Cloud Account and API key (english and german).
where did you downloaded the Uipath Cognitive Services Activities Pack?? thank you!
Hello @jgomez67
You can download the UiPath Cognitive Services Activities Pack from the manage packages dialog:
Regards,
Susana
I tried your workflow, however i keep getting error:

Any solution to this?
Edit: Getting the same error with the example from @Teodor_Hoaghea
Hi,
I think the variable (should be an array or a list) you’re trying to iterate through was not initialised and it has no elements.
Check this and let me know.
The variable keyPhrases only accepts IEnumerable string…
Any solutions to this one? @Teodor_Hoaghea, @Langdeel ![]()
It’s good if you’re using IEnumerable. The variable was not initialised. Add one element, like keyPhrases.Add(“test”) and run it again.
Ok. I can’t seem to get it right
. Anyway you can post an example thats working?
Edit: Also its a little bit alarming that the sentiment is always 0, no matter how negative or positive the text analyzed is.
Anyway you can post an example workflow @Teodor_Hoaghea?
You can find an example that I posted above. Check it and ping me if you have questions.
Hi Teodor…
I tried running your workflow. i am getting error “For each : Object reference not set to an instance of an object.”
Please can you help in this…
Hi,
Still works on my machine. Did you extract all the files from the archive before running the process?
Did you provide a key for Microsoft Cognitive activities in the Password activity before starting the process?
Thanks,
Teo
Yes… I have extracted all the files and also provided the key.
Also i tried initializing the value for “key phrases”. after initializing it is working but it is giving result ‘0’
for everything and not writing ‘;’ in key phrases row.
Please share with me the workflow you are using… We are missing something
@vreddy I have the same issue.
@Teodor_Hoaghea here is the workflow I am using:
Cognitive.zip (10.2 KB)
I had similar error in my workflow. Please print the ‘Raw’ output. It contains the error message of why the apis unable to return the values for sentiments or key-phrases. The basic issue which cause such issue is due to following reason -
Incorrect key
Incorrect service URL.
If both are correct, then workflow should return values for languages, sentiments and key-phrase.
Thanks
can u show the service URL and key passed?
Please refer above link for accessing the keys

