Google Cloud Speech to text API

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 :slight_smile:

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. :slight_smile:

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 :confused:
This is my workflow, I appreciate the help :slight_smile:

@markuseisl,
thank you for sharing, I have recreated your workflow and I solved your problem, you can check solution here:

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.

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 :confused:

image

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.

I didn’t want to use any code to create DataTable and only to use native functionality.

Cheers,
Dino

1 Like

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

1 Like

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

1 Like