Hi everyone. I am trying to set up an automation. here is what I am trying to do.
I have a folder in my Google Drive, which contains 3 files. The first file “A” includes images, and the second file “B”, is an Excel sheet containing 25 prompts each on a row within a column. The third file C is also an Excel sheet, and it is empty. the purpose of this is to set up an automation using n8n, and here is the automation explanation. on the manual trigger, n8n picks up an image from file “A”, and then sends it to ChatGPT, using the first prompt from file “B”, after the result is generated, the second prompt from file “B” is sent again in the same chat, this is done until all the 25 prompts have been queried that particular image. After all the 25 prompts have been queried, the result of the 25th prompt, which is the last prompt, is then sent back to n8n, and then passed on to a new row in File C. This will then be repeated for all the images in File A.
Where I am having issues is the part where it has to query all 25 prompts for each image, in a chat. I would also love even anybody can provide resources and tips on how to set this up correctly. Thanks