Can the AI agent reuse the same $fromAI() variable to create distinct Google Sheets?

Below is an explanation and a workaround:

---

What's Happening

When you use an expression like:

PYTHONCopied
{{ $fromAI("username") }}

it fetches the value from the AI agent’s current context. In a multi-iteration workflow, the internal memory of the AI agent might retain the previous value if it isn’t specifically cleared between iterations. This means that—even though the agent cycles through its internal list—the same value can be reused when the variable isn’t refreshed properly. In effect, Google Sheets receives the same sheet name every time.

---

Possible Workarounds

1. Clear or Reset the Memory Between Iterations
   If you want different values per iteration, ensure that the AI memory context is cleared after each operation. For example, you could add a node (or a sub-workflow) that resets or splits the data so that each call to the AI agent starts with a fresh set of parameters. Instead of relying solely on the persistent internal context (using $fromAI), consider extracting the member name from a node that explicitly reads each row.

2. Use a “SplitInBatches” or “Split Out” Node
   Rather than looping entirely within the AI agent, use a node that splits your member list into individual items. Then, in each split branch, refer directly to the individual member’s property (for example, using an expression like:

   JAVASCRIPTCopied
   {{ $json.username }}

   )—instead of pulling it from the AI context. This approach avoids any issues with the agent’s cached memory because each iteration will use the row’s direct data.

3. Use a “Set” or “Code” Node to Reassign Variables
   You might add a node immediately before your Google Sheets node that extracts and sets the member’s name to a new variable. This “Set” node forces the individual value into a new context so that when the sheet is created, it is definitely picking up the fresh value each time.

---

Example Workaround Using a Set Node

Assuming you have already split the array of members, you might add a Set node with the following configuration:

JSONCopied
{
  "nodes": [
    {
      "parameters": {
        "values": {
          "string": [
            {
              "name": "memberName",
              "value": "={{ $json.username }}"
            }
          ]
        }
      },
      "name": "Set Member Name",
      "type": "n8n-nodes-base.set",
      "typeVersion": 1,
      "position": [
        600,
        400
      ]
    }
  ]
}

Then, in your Google Sheets node, you can reference the new variable like so:

PYTHONCopied
{{ $json.memberName }}

This ensures that each iteration clearly uses the individual value rather than a potentially stale value stored in the AI agent’s context.

---

Summary

Yes—the issue you’re seeing may occur because the AI agent does not automatically clear its context between iterations, leading to the reuse of the same variable value. To work around this, either reset the memory between iterations or use nodes like “SplitInBatches” and “Set” to ensure you are explicitly dealing with fresh data on each run.

Let me know if you have any further questions or need additional details!