Look up values from 2 sheets for next action

Problem/error/question

I have to take data from 2 sheets for the next note (here is OpenAI)
So, the first one is the sheet of content brief, where we will take some key requirements and the brief for the content detail. And the AI need to read the content direction of that brief from another sheet.

Error

Currently, I sets the workflow like below, but when executing, the OpenAI run twice. But It doesn’t merge data from 2 sheets.

So as you see on the example, the output will run 4 batches from the Brief then 2 batches from the Direction. But it should be return with 4 batches.
Moreover, is there anyway that can reuse the OpenAI. Like, instead of each post the AI will read the content direction again, it should read the content direction one timeline then use it for many brief later. Because when reading again and again like this, it will spend a lot of token.
Could you please suggest me some related article or easy example to start practicing. Cuz I really don’t know about coding. And nodes now are different a lot from 2-3 months ago, that make me hard to understand the old langchain articles

  • n8n version: 1.22.4
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own
  • Running n8n via (Docker, npm, n8n cloud, desktop app): npm
  • Operating system: Windows

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

@mivtool , that is not how merging is done. Try this instead.

2 Likes