ChatGPT completion <-> Google Sheet

[Romain_Forestier]

Hi all,

I am trying to: read a call transcript to search for some data points like name, availability, reason for calling, etc. I set-up a module with a GPT completion, see below:

I would like the prompt to retrieve the data and then past it into columns of my excel sheet. The next module is the google sheet:

Question: How can I set this up using only a single GPT completion with a prompt? What data should I put into the columns B) C) and E) ? The goal would be that the model fetches the right data and parses it into these columns → How can I do that?

Thanks in advance,
best

[Msquare_Automation]

Hi @Romain_Forestier

You can ask gpt to give the output as json structure with name, availability, reason for calling

Go to advance setting and create a setup like this:

Output:

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation