How do I exclude the header row from my Google Sheets node JSON output?

Below is a likely explanation to help you resolve the issue:

Explanation

The Google Sheets node can be configured to distinguish between the header row and data rows. In your case, the JSON output still contains the header because the node isn’t set to ignore the header row. By default, n8n treats the first row in your sheet as the header (column names) if you set up the node correctly.

What to Check

1. Data Location on Sheet
   Verify the node's Data Location on Sheet settings. You should check two specific values:

   • Header Row: Ensure that this value points to the row number that contains the column names.
   • First Data Row: Set this value to the row immediately following the header row. This tells n8n where your data starts.

2. Mapping Column Mode
   If you are using Mapping Column Mode > Map Automatically, the node will automatically interpret the first row as containing field names. If your configuration isn’t aligned with your sheet’s structure (for example, if the header row isn’t correctly specified), you may end up including header data in your output.

Steps to Fix It

1. Open the Google Sheet node settings on your canvas.
2. Locate the Data Location on Sheet section.
3. Set the Header Row value to the row number that contains your actual headers (for example, row 1).
4. Set the First Data Row to the row number that contains your first row of data (for example, row 2).
5. Save and run your workflow again.

After making these adjustments, the node should correctly ignore the header row when processing your data.

Let me know if you need further assistance with the Google Sheets node configuration in n8n!

Based on your description, nothing is wrong with your setup. The Google Sheets node in n8n automatically treats the first row in your sheet as the header row, using its values as the keys in the output JSON. So when your sheet has a header row like this:

header1 | header2

and you have a data row like:

value1 | value2

the node will output:

JSONCopied
{
  "response": [
    {
      "header1": "value1",
      "header2": "value2"
    }
  ]
}

If you intended to include the header row as part of the data output, you would need to adjust the Data Location on Sheet option within the node parameters. Otherwise, your current configuration is working as expected.