Why Does My Email AI Agent Process Only the First Row from Google Sheets Input?

Below is an explanation for why your workflow processes only the first row and how to solve it:

The Issue

Even though your Code node returns all rows by mapping through the input items, many n8n nodes – including those used for AI or email actions – by default only process a single item (typically the first in the list). In your case, the AI Agent node is receiving the entire array but only picks up the first item.

What's Happening

• Your Code node uses the following logic to return multiple items:

  JAVASCRIPTCopied
  return $input.all().map(row => ({
      json: row.json // Ensures each row is processed  
  }));

  Although this returns an array of objects, downstream nodes like the AI Agent may be designed to work on a single input item.

• Without additional handling, n8n nodes generally work on the first item in the received array unless you enable explicit looping or splitting.

How to Fix It

To ensure that the AI Agent processes every row from your Google Sheet, you need to split the array so that each row is passed as an individual execution item. You can achieve this by using a SplitInBatches node or by enabling the "Split Out Items" option (if available) in the node’s settings.

For example:

1. Insert a SplitInBatches node after the Code node.
   • Set the Batch Size to 1 so that it outputs a single row per execution.
2. Connect the output of the SplitInBatches node to your AI Agent node.
   • Doing this ensures that for each iteration, the AI agent receives one row, and it processes it separately.

Example Workflow Snippet

Below is an example of how your workflow might be adjusted:

JSONCopied
{
  "nodes": [
    {
      "id": "709fc11b-02bb-4ebf-8fd0-8bde5d667ab6",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [220, 0],
      "parameters": {
        "jsCode": "return $input.all().map(row => ({\n    json: row.json // Ensures each row is processed\n}));"
      }
    },
    {
      "id": "split-1234",
      "name": "Split Items",
      "type": "n8n-nodes-base.splitInBatches",
      "typeVersion": 3,
      "position": [400, 0],
      "parameters": {
        "batchSize": 1
      }
    },
    {
      "id": "agent-5678",
      "name": "AI Agent",
      "type": "<your-agent-node-type>",
      "typeVersion": 1,
      "position": [600, 0]
    }
  ],
  "connections": {
    "Code": {
      "main": [
        [
          {
            "node": "Split Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Items": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Summary

The issue isn’t with your Code node but with how the subsequent AI Agent node handles its input: it’s only processing the first item in the array. By splitting the array into individual executions (using a SplitInBatches node with a batch size of 1), each row will be processed by the AI Agent individually.

This approach should resolve your issue and allow your Email AI agent to handle all rows from the Google Sheet.