Get Content from a Sheet Grouped and added back to the sheet

[Simon_Dunne]

I successfully created a scenario that pulls data from a set of profiles. The content populates to the sheet as planned.

I now want to utiize chat GPT to create groupings for each row of content.

utilizing the video URL, the Caption, and the display URL as guidance on the grouped decision

I want to groups to be one of these:

Funny Meme
Featured Product
Tag a Friend
Promotion
Other

Below is the setup of the Open AI create a completion module.

I think the grouping is working, but I want to be able to take a one word answer from the answer, and add this to a column on the sheet.

here is the Input

and the subsequent output

In this instance, I would like to add “Promotion” to the THEME Column.

The rationale for this is create theme for the analysis I am running.

[Stoyan_Vatov]

Hey Simon,

ask it to provide shorter answers inside the prompt. You can specifically tell it to start with the answer on row one then give you the short justification after. So in the following module you can just grab the first line of the answer using first(split(‘answer’;newline))