Multiple GPT Requests To Single G-Sheet Row

[GunnerJnr]

Hi @mr-oodler,

I’m not at a PC right now, I’m on my mobile. But I think I can still point you in the right direction.

—-

@mr-oodler

Issue 1 - see image below.
Q: What Row Number must I add here for Update Row? I mean it should just update the row number that the Brand-Name row its pulling data from.
EG if we add a new row and run this, it will update each new row.

—-

@mr-oodler

Issue 2 - see image below.
In our report, other than About-Brand, we are looking to ask gpt to create 5 x product titles and associated descriptions and populate the 5 x title fields and 5 x description fields with the response.
I understand from your breakdown that I could add 5 x GPT steps to create the 5 x titles, then 5 x GPT steps to create the 5 x descriptions.
Assuming there is a way for the 2nd, 3rd, 4th, 5th title requests can reference the last request and ensure its different.
However… I am hoping to make this easier with 1 x query.
EG I can make a GPT query to make 5 x titles with 5 x description responses and have them seperated in the response, which it does, but when I get to Update Row, there is no way to separate the response to each field.
I tried asking the prompt to separate the responses into json format, but it didn’t. (having no idea if that would help)
Do u have any method to get 1 response and then utilize different sections of the response into different fields on the row?

You have two options:

1. As you stated you could create multiple ChatGPT requests to have it output them separately, currently there is no way to track chat history, so you could simply in your next prompt reference the previous one by adding the result from the previous one

(e.g., inside the prompt where it pops up the options to insert previous pieces, click the little arrows beside the ChatGPT piece and reference that result, (assuming you only output the title and no system message)).

I believe you could also achieve the same result using Put/Get inside storage pieces, although, I feel that is overkill if doing the separately.

2. You mentioned you are asking ChatGPT to output it in JSON format, after this you will need to add a code piece. In the key:value boxes at the top of the code piece you can enter title as the key, then for the value, the ChatGPT result, then you can parse it via code. Then there is also a piece that allows you to convert JSON to CSV and vice versa, in theory, Sheets uses CSV, so on pasting it should import correctly in multiple cells. You would likely also need a loop to iterate those values.

Note: if you take the separate approach you can output multiple Chat GPT results into the same output box. By this I mean the arrow pointing to the title in the second screenshot for the update row, you could put the result of each separate chat in here and separate them by commas, new lines, or even add your own text (these boxes work the same way as adding your prompt in the ChatGPT piece).

However, see the below reply, I think it will solve that part for you along with issue 2.

@ashrafsam made a great example flow demonstrating this part:

JSON to Variables to Loop to Google Sheets

Hi @KyleBehrend I’ve created this flow for you: Activepieces It generates a JSON array with ChatGPT of the JSON object you posted. Since the generation is textual, I used a Code step to parse it into an actual JSON object. Then, I passed the array to a Loop step and I added a Google Sheets → Insert Row step to add some info from each of the items to a sheet.

Hopefully, this helps, if not I can take a look when I get back from work this evening.

Kind regards