Retrieve a dynamic range of excell colum numbers

Hi there,

I am setting up a process where AI retrieves initial input from an excel sheet and then fill out 5 more columns with content, before it goes into the next row of data to repeat the process.

My Issue is, that the content in Row2 is too similar to what was generated in Row1. But i want the content to be different each time. So my thought was to compare.

How can i retrieve the data from row1 to tell AI to look at it and based on this, generate different content for row2?

My questions is in regards to the excel mapping - not the prompt for AI. Which Excel Module do i need and how do i map “_current_Row -1” or a range “look at the last 5 outputs”?

Sorry - i am a pure frontend user, not a coder, hence the maybe stupid question

1 Like

Welcome, and you’ve a valid question, @fabian.roser.

You might consider using variables to recall prior output and then feed the current and prior output to OpenAI for the comparison and possible update of current.

Below are a couple of variable saving and recall examples.


blueprint (1).json (8.1 KB)


blueprint (2).json (6.6 KB)

Thank you @ImMichaelCannon !

Learned a lot looking into this!

Having said that (maybe someone else with the same question reading this later has value of it), the answer was to have openAI generate all answers in one prompt, compare the answers and make sure they are in fact different, but to then parse the output via a JSON string, which allows me to map all outputs individually it into the Excel module.

I am new to working with JSON, so thank you community for enabling my learning!

Have a great weekend y’all.

1 Like

Nice work, @fabian.roser, for solving this as you have.