# What is a header row in a spreadsheet?

> The header row is the first row of a sheet, holding the column names. Why automations and AI agents depend on it, and how to set one up well.

Source: https://learn.ynteractive.com/content/glossary/header-row · Updated 2026-10-01 · Free from Stepthrough (https://learn.ynteractive.com)

[Data, Sheets and Gmail](https://learn.ynteractive.com/content/glossary#topic-data-sheets-and-gmail) · [AI glossary](https://learn.ynteractive.com/content/glossary)

Updated October 1, 2026 · By [Robert Breen](https://learn.ynteractive.com/content/about)

A header row is the first row of a spreadsheet, where each cell names the column below it, like Customer, Service or Status. Tools like n8n read the header row to learn what columns exist, so those names become the labels your automation fills in.

## Why it matters for a small business

To a person, a sheet with no headers is just untidy. To an automation, it is unreadable. n8n treats the header row as the field names for every row: when it reads a sheet, each row comes out as an item labeled with those names, and when it writes, it lists the headers as the places a value can go. Rename a header and any step pointing at the old name quietly stops working.

With an AI agent, headers do even more. When you let the model fill the columns, the header names are a large part of how it decides what goes where. A clear header like "Follow-Up Message" tells it what to put there; "Col C" tells it nothing. Plain, specific headers are the cheapest instruction you'll ever write.

## In a real lesson: Build an AI Customer Follow-Up Agent for Plumbers

In the [AI Customer Follow-Up Agent lesson](https://learn.ynteractive.com/content/plumber-customer-follow-up-ai-agent-n8n), you build an agent for Blue Maple Plumbing, a made-up plumbing company, that writes follow-up texts after service calls. Before configuring the Google Sheets tool, you create a spreadsheet called **Customer Follow-Ups** and type the headers: **Customer** in A1, **Service** in B1, **Follow-Up Message** in C1, **Next Step** in D1 and **Status** in E1.

The voice-over stresses that these must match what the system prompt tells the agent to return: Customer, Service, Follow-Up Message, Next Step and Status. Back in n8n, you pick the sheet and the five headers appear under **Values to Send**, each with a **✦** button. After you click them all, the voice-over sums it up: the agent reads your column headers and figures out what goes where.

When you ask the agent to write follow-ups for Linda, Tom and Maria and then say "Yes, save those messages to the sheet", each message becomes a row under those headers.

[Try this lesson free](https://learn.ynteractive.com/modules/n8n-ai-agent-plumbing) or [read the step-by-step guide](https://learn.ynteractive.com/content/plumber-customer-follow-up-ai-agent-n8n).

## Common confusions

### Header row vs field mapping

The header row defines which columns exist. [Field mapping](https://learn.ynteractive.com/content/glossary/field-mapping) decides which value goes into each one. You need the headers first; the mapping is built on them.

### Header row vs frozen row

Freezing row 1 in Google Sheets only keeps it visible while you scroll. What makes it a header for n8n is that it holds the column names, frozen or not.

## Tips

- Type headers before you connect the sheet in n8n, or the node has nothing to list.
- Keep header names stable once a workflow uses them; add new columns instead of renaming old ones.
- Match the header names to the labels in your prompt or form, word for word.
- Avoid merged cells and blank columns in the header row.

## Related terms

[Google Sheets (as an automation database)](https://learn.ynteractive.com/content/glossary/google-sheets) · [Field mapping](https://learn.ynteractive.com/content/glossary/field-mapping) · [Append row](https://learn.ynteractive.com/content/glossary/append-row) · [Structured output](https://learn.ynteractive.com/content/glossary/structured-output) · [Item (n8n)](https://learn.ynteractive.com/content/glossary/item)

## Where you use it: free lessons

- [Build an AI Customer Follow-Up Agent for Plumbers](https://learn.ynteractive.com/content/plumber-customer-follow-up-ai-agent-n8n) (n8n, 12 min)
- [AI Receipt Extractor: Receipts to Google Sheets with n8n](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets) (n8n, 12 min)
- [Find and Use n8n Templates](https://learn.ynteractive.com/content/find-and-use-n8n-templates) (n8n, 9 min)

## Frequently asked questions

**Does the header row have to be row 1?**

By default, n8n's Google Sheets node treats the first row as the header row. Keeping your headers in row 1, with data starting in row 2, avoids surprises.

**Can column headers have spaces?**

Yes, but in n8n expressions you then write them with square brackets and quotes, like `$json["Tech Email"]`. Short names without spaces are easier.

[All AI glossary terms, A to Z](https://learn.ynteractive.com/content/glossary) · [Free prompt templates](https://learn.ynteractive.com/content/prompts)