Google Sheets columns plan prompt: free ChatGPT template
Updated · By Robert Breen
Use this before you create the spreadsheet an automation will write to. In the n8n lessons, the headers in row 1 have to line up with what the agent returns or the form sends, and a column you forget on day one means editing the sheet and the node later. This prompt plans the headers from what the workflow produces and from what you will want to filter by a month from now.
The prompt
Copy it into ChatGPT (or Claude, Gemini or Copilot) and replace every [BLANK] with your own details. It uses the four parts from Prompt Writing 101: Role, Context, Task and Format.
Role: You are helping [BUSINESS] design a Google Sheet that an n8n workflow will add rows to. Context: The workflow [WORKFLOW]. The data arrives with these fields: [INCOMING FIELDS]. Once rows are in, people will use the sheet to [SHEET USE]. Keep it simple enough that a busy office will keep it tidy. Task: Propose the column headers in order. For each, say what goes in it, give an example value, say whether the workflow or a person fills it, and say whether its name must match an incoming field exactly. Point out any field that should be split or left out, and suggest at most two extra columns for tracking, such as a status a person updates. Format: A table with the columns: header, what goes in it, example, filled by, must match. Headers in plain words without symbols. Then the header row on one line, separated by tabs, so I can paste it into cell A1.
Fill in the blanks
[BUSINESS]- Your business name and what it does.
[WORKFLOW]- What the workflow does, finishing the sentence "The workflow...", such as "saves each demo request from our form".
[INCOMING FIELDS]- The exact field names the agent returns or the form sends. Copy them from your system message or form prompt.
[SHEET USE]- What people will do with the rows: follow up, count leads by type, see what's overdue.
Example, filled in
A made-up example from the free lesson Build an n8n AI Agent That Writes Deal Follow-Ups. Northwind Scheduling Software is the made-up company in the deal follow-up agent lesson. Its agent writes a follow-up for each open deal and saves them to a sheet, and the team wants to plan that sheet before building.
Role: You are helping Northwind Scheduling Software, which sells scheduling software to small service businesses, design a Google Sheet that an n8n workflow will add rows to. Context: The workflow is an AI agent that writes one follow-up message for each open deal I give it and, when I ask, saves each one with the Google Sheets tool. The data arrives with these fields: Prospect, Company, Stage, Follow-up Message and Next Step, which is what the system prompt tells the agent to return. Once rows are in, people will use the sheet to see which follow-ups have been sent, by whom, and which deals still need a next step this week. Keep it simple enough that a busy office will keep it tidy. Task: Propose the column headers in order. For each, say what goes in it, give an example value, say whether the workflow or a person fills it, and say whether its name must match an incoming field exactly. Point out any field that should be split or left out, and suggest at most two extra columns for tracking, such as a status a person updates. Format: A table with the columns: header, what goes in it, example, filled by, must match. Headers in plain words without symbols. Then the header row on one line, separated by tabs, so I can paste it into cell A1.
What a good answer looks like
- The five agent fields first, named exactly as the system prompt names them: Prospect, Company, Stage, Follow-up Message, Next Step. The lesson's sheet uses those same headers.
- Must match marked yes for those five, because the Sheets tool fills values by header.
- One or two human columns at the end, like Sent and Sent By, marked as filled by a person.
- A tab-separated header line that drops into row 1 in one paste.
How to check it before you use it
An AI draft can sound right and still say something you never told it. Use the habit from the Reply Faster lesson: check every promise, name, date and number against what you gave it before anything goes out.
- Compare every must-match header to your system prompt or form keys letter by letter. "Follow-up Message" and "Followup Message" are not the same header.
- Skip columns nothing will fill. A Date Sent column stays blank unless a person or another step writes it.
- Leave out personal details you don't need. Every extra column is more customer data sitting in a shared file.
- After building, run one test and read the new row before trusting the sheet.
Why this prompt works
Planning the sheet first is field mapping done on paper. When the headers match what the agent returns, the ✦ button next to each column in the Sheets tool has an obvious value to fill.
Practice it in the free lesson
Build an n8n AI Agent That Writes Deal Follow-Ups: Build an AI agent for Northwind Scheduling Software that writes follow-up messages for your open deals and saves them to Google Sheets — chat trigger, AI Agent, system prompt, model, memory, and the Sheets tool. You do every step yourself in a practice copy of n8n, and nothing touches your real accounts.
Also useful: n8n AI Agent Tutorial: Save Social Media Ideas to Google Sheets · AI Receipt Extractor: Receipts to Google Sheets with n8n
Terms used here
Related prompts
- n8n workflow documentation prompt: Document an n8n workflow so your team can live with it: what starts it, what each step does, which accounts it uses, signs it…
- Weekly leads summary prompt: Paste a week of form leads from your Google Sheet and get counts by type, who is still waiting, patterns with row numbers and…
- Lovable web form prompt: Write a Lovable prompt for a web form that posts to n8n: fields, validation, button states, a thank-you message, and a webhook…