Hi guys!
I have a problem that should be solved quite easily, sadly i am a complete beginner. I am trying to use the Google Cloud Speech to text API and i would like to somehow write the output in an excel/csv file. The speech to text part works seamlessly, but the output is always written in the console and not in the cells that I designated.
Would really appreciate your help. Thanks in advance 
Kind regards,
Markus Eisl
Additionally I cannot create variables. Would appreciate a solution.!
Unbenannt|690x130
Hi @markuseisl,
can you share a picture of workflow or a sample of workflow on which you are working on so I can check it out?
It is a bit abstract to debug with you when I don’t know what are you doing.
I think that API always returns something in JSON form which you can parse and extract a text, there is a lot of JSON parsing techniques available in UiPath Studio.
Cheers,
Dino
Well, I know that the API works, as I recieve the correct transcript in the console but I have no idea how to export it into a file 
This is my workflow, I appreciate the help
@markuseisl,
thank you for sharing, I have recreated your workflow and I solved your problem, you can check solution here:
https://github.com/dinofilipovic/GoogleCloudSpeechtotextAPI
Best solution for CSV and EXCEL is to create a DataTable and then you can fill row that you want to fill specified in Add Data Row activity.
https://docs.uipath.com/activities/docs/add-data-row
In my project I have removed credentials for Google API so you need to put your JSON file in file path.
Cheers,
Dino
Thanks for your effort! Sadly I cannot open the project
Oh, sorry @markuseisl I didn’t create it in Studio X.
This new repository is made in Studio X, it is problematic to append something in CSV which is not in DataTable format so I had to use Excel to solve this problem.
https://github.com/dinofilipovic/StudioXSpeechToTextGoogleAPI
I didn’t want to use any code to create DataTable and only to use native functionality.
Cheers,
Dino
The speech recognition works flawlessly, the problem is that the program still does not write the output into the file. It does not even write it in the message box you added…
@markuseisl,
I can see that it is a probably a problem with an activity I had to test it in Studio not in Studio X to see that as you can see from picture that nothing is returned even though I got a message in debugging window (image 2).
I will test it out a little bit.
Cheers,
Dino
Hello @markuseisl,
I found out that a problem is because of latency since I have 50 Mbit/s download and 10 Mbit/s so my computer had a problem with uploading recording of my voice to API.
After testing it a little, free version of Google API for Speach to Text has it limits:
“message”: “Quota exceeded for quota metric ‘Requests’ and limit ‘Requests per minute’ of service ‘speech.googleapis.com’ for consumer ‘project_number:292824132082’.”,
I will try later and post my results back.
Cheers,
Dino
