# n8n Defined Automatically by the Model, Explained > What "defined automatically by the model" means in n8n tools, when to click the sparkle button, and when a fixed expression is the safer choice. Source: https://learn.ynteractive.com/content/blog/n8n-defined-automatically-by-the-model · Updated 2026-10-25 · Free from Stepthrough (https://learn.ynteractive.com) Quick answer In n8n, "defined automatically by the model" means the [AI Agent](https://learn.ynteractive.com/content/glossary/ai-agent) fills in that field itself each time it uses the tool, instead of you setting a fixed value; you turn it on with the small sparkle (✦) button next to the field. Use it for values the AI has to read or write, like a receipt's vendor or the body of a reply, and use a fixed expression for anything that must be exact, like an email address or a [thread ID](https://learn.ynteractive.com/content/glossary/email-thread). This guide is for anyone setting up tools on an n8n AI Agent, and the clearest example is the free [AI Receipt Extractor](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets) lesson. Last updated October 25, 2026 [Take the free module →](https://learn.ynteractive.com/courses/ai-for-accounting-firms/12)Module 12 of the free [AI for Accounting & Bookkeeping Firms](https://learn.ynteractive.com/courses/ai-for-accounting-firms) course, about 12 minutes. No account needed. By [Robert Breen](https://learn.ynteractive.com/content/about) · Published October 25, 2026 · Updated October 25, 2026 · 6 min read n8n · AI Agents · Google Sheets · Gmail ## Watch: the idea in 0:48 ### Defined automatically by the model Explainer · 0:48 · with captions What "defined automatically by the model" means in n8n tools, when to click the sparkle button, and when a fixed expression is the safer choice. **Transcript** In ChatGPT, the AI writes every word. In n8n, you choose which fields the AI fills in. That's the sparkle button. Click the sparkle next to a field, and the model fills it in each time. The receipt sheet has four columns. Date, Category, Vendor and Amount. All four get it. The system message never says where each value goes. The column names take care of that. So not Col1 or Info, but plain names, like Date and Vendor. In the email agent, only the message gets the sparkle. The subject, thread ID and To address stay fixed. They come straight from the email. After the first runs, check the real rows. Corner Mart, $31.57, Groceries. It matches. If a column keeps coming out wrong, rename it first. Try it yourself, free, in AI Receipt Extractor. ## What does "defined automatically by the model" mean in n8n? It means the field's value comes from the [AI model](https://learn.ynteractive.com/content/glossary/ai-model) at the moment the agent calls the tool. You don't write the value; the model decides it from the conversation, the email or the image in front of it. Tools like the **Google Sheets Tool** and the **Gmail Tool** hang under the AI Agent, and each tool has fields: the columns to fill, the subject, the message and so on. For each field you have a choice: - **Fixed:** you type a value or an expression, and it's the same logic every time. - **Defined automatically by the model:** you click ✦, and the AI fills it in. The lessons call it the sparkle, or the purple button. After you click it, the field shows that the model will define it. ## How do you let the model fill a Google Sheets column? Open the Google Sheets Tool, pick the spreadsheet and tab, then click ✦ next to each column under **Values to Send**. n8n reads the header row and lists your columns. In the receipt extractor, the **Invoices** sheet has four headers: Date, Category, Vendor and Amount. After setting **Operation** to **Append Row**, picking **Invoices** under **Document** and **Sheet1** under **Sheet**, you click ✦ next to all four. In the lesson's words, all four now say defined automatically by the model. The [AI Social Media Idea Agent](https://learn.ynteractive.com/content/n8n-ai-agent-tutorial-google-sheets) does the same with five columns: Platform, Post Topic, Hook, Description and Call to Action. The voice-over sums it up: the agent reads your column headers and figures out what goes where. ## Why do clear column names matter? Because the column name is most of what the model has to go on. The receipt agent's system message is three short lines and never says where each value goes. The lesson points that out directly: the column names in the sheet take care of that. So name columns the way you'd label them for a new employee: - **Good:** Date, Vendor, Amount, Category, Follow-up Message, Next Step. - **Risky:** Col1, Info, Notes2, or abbreviations only your team knows. Match the headers to what the system message asks for. The social media agent's system message asks for Platform, Post Topic, Hook, Short Description and Suggested Call to Action, and the sheet uses nearly the same names, so the mapping is obvious. ## Which Gmail fields should stay fixed? Keep the fields that must be exact as fixed expressions, and let the model write only the message. The [AI Email Responder](https://learn.ynteractive.com/content/ai-email-responder-gmail-drafts-n8n) sets up its **Gmail Tool**, with **Resource** set to **Draft**, like this: | Field | Set to | Why | | --- | --- | --- | | Subject | `Re: {{ $json.Subject }}` | Keeps the original subject so Gmail threads the reply | | Message | ✦ defined by the model | The reply can't be known ahead of time | | Thread ID (option) | `{{ $json.threadId }}` | Puts the draft in the same conversation | | To Email (option) | `{{ $json.From }}` | Addresses the draft to whoever wrote in | The lesson's reasoning for the message: it's the part we can't know ahead of time, so the agent writes it. Everything else comes straight from the incoming email, so there's nothing for the model to decide, and nothing for it to get wrong. ## Try it free, step by step **AI Receipt Extractor: Receipts to Google Sheets with n8n**. Drop a photo of a receipt into an n8n chat. An AI agent reads it, pulls out the date, vendor and amount, picks a category, and adds a row to Google Sheets. You do every step yourself in a practice copy of n8n, it checks your work as you go, and “Do it for me” finishes any step you get stuck on. Free, and nothing touches your real accounts. [Start the free lesson](https://learn.ynteractive.com/modules/receipt-extractor) [Or read the full step-by-step guide](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets) ## When should you use the model, and when a fixed value? Use a fixed value or expression when the field must be exact and you already have it; use the model when the field needs reading, judgment or writing. A simple rule of thumb: - **Fixed:** email addresses, thread IDs, record IDs, subjects built from the original, anything a typo would break. - **Model:** a reply's body, a summary, a category, values read from a photo or a message. - **Either:** a value that's in the input but needs a little cleanup. Start fixed if you can; switch to the model if the raw value isn't usable. The reason is simple. A model-filled field can vary from run to run. That's what you want for a written reply and exactly what you don't want for an address. ## How do you check what the model filled in? Look at the real output after the first runs: the row in the sheet, or the draft in Gmail. Don't trust the green checks alone. The receipt lesson models the habit. After the run, you click the receipt in the chat (Corner Mart, April 24, total $31.57), then switch to the **Invoices** tab and compare: Date, Groceries, Corner Mart, 31.57. It matches, and the agent picked Groceries without being told. Checking the first few rows by hand tells you whether the column names and instructions are doing their job. If a column keeps coming out wrong, try in this order: 1. Rename the column to something clearer. 2. Add one line to the system message about that column, such as a date format or a closed list of categories. 3. Switch the field to a fixed expression if the value already exists in the input. [Get Receipts into Google Sheets with AI and n8n](https://learn.ynteractive.com/content/blog/receipts-to-google-sheets-ai) walks through the full receipt build, and [How to Write an n8n AI Agent System Message](https://learn.ynteractive.com/content/blog/n8n-ai-agent-system-message) covers the instructions side. All three lessons are free and run in practice copies. A real build needs n8n (n8n Cloud is paid after a free trial, or self-host it), a Google account and an OpenAI API key, which is pay-as-you-go and billed separately from ChatGPT plans. More builds are on the [n8n tool page](https://learn.ynteractive.com/content/tool/n8n). ## Key takeaways - "Defined automatically by the model" means the AI Agent fills in a tool field itself each time it calls the tool. - You turn it on with the sparkle (✦) button next to a field, such as each column under Values to Send in the Google Sheets Tool. - Clear column headers like Date, Category, Vendor and Amount tell the model where each value goes. - In the email responder's Gmail Tool, only the Message is defined by the model; Subject, Thread ID and To Email stay fixed expressions. - Use fixed expressions for anything that must be exact, and check the first rows or drafts by hand. ## Frequently asked questions **What is the sparkle button in n8n?** The sparkle (✦) button next to a tool field sets it to be defined automatically by the model, so the AI Agent fills it in each time it uses the tool. **Should I let the model fill in the email address?** Usually not. If the address is in the incoming data, use an expression like `{{ $json.From }}`, as the email responder does. **How does the model know which value goes in which column?** Mostly from the column names in your sheet's header row, plus anything your system message says about the output. **Why is a model-filled column wrong or empty?** The column name may be unclear, or the model didn't have that information. Rename the column, add a line to the system message, or use a fixed expression. ## Free lessons in this post - [AI Receipt Extractor: Receipts to Google Sheets with n8n](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets): Drop a photo of a receipt into an n8n chat. An AI agent reads it, pulls out the date, vendor and amount, picks a category, and adds a row to Google Sheets. - [n8n AI Agent Tutorial: Save Social Media Ideas to Google Sheets](https://learn.ynteractive.com/content/n8n-ai-agent-tutorial-google-sheets): Build an AI agent for BrightPath Marketing that generates social media post ideas and saves them to Google Sheets — chat trigger, AI Agent, system prompt, model… - [n8n AI Email Responder: Draft Gmail Replies Automatically](https://learn.ynteractive.com/content/ai-email-responder-gmail-drafts-n8n): Build an n8n agent that watches your Gmail, reads each new customer email, and writes a reply as a draft in the same thread, ready for you to check and send. ## Watch it in a free lesson: AI Receipt Extractor: Receipts to Google Sheets with n8n ### AI Receipt Extractor: video walkthrough Full walkthrough · 5:35 · with captions Drop a photo of a receipt into an n8n chat. An AI agent reads it, pulls out the date, vendor and amount, picks a category, and adds a row to Google Sheets. The whole lesson narrated step by step, recorded in Stepthrough’s simulated practice environment. [Watch it with chapters and the full transcript](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets#watch) From the free lesson [AI Receipt Extractor: Receipts to Google Sheets with n8n](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets) ## Related terms Plain-English definitions, each with an example from a free lesson. [AI agent](https://learn.ynteractive.com/content/glossary/ai-agent) · [Email thread](https://learn.ynteractive.com/content/glossary/email-thread) · [AI model](https://learn.ynteractive.com/content/glossary/ai-model) · A/B testing · Accounts payable · [Action](https://learn.ynteractive.com/content/glossary/action) · [Agent memory](https://learn.ynteractive.com/content/glossary/agent-memory) · [AI Agent node](https://learn.ynteractive.com/content/glossary/ai-agent-node) [The full AI glossary](https://learn.ynteractive.com/content/glossary) ## Related prompts - [AI agent system message prompt](https://learn.ynteractive.com/content/prompts/agent-system-message-draft-prompt): An AI agent prompt template for the n8n System Message: who the agent is, what it knows, its rules and how it writes, plus a… - [Case study interview questions prompt](https://learn.ynteractive.com/content/prompts/case-study-interview-questions-prompt): Plan a client interview that gets a case study's before, during and after story in their own words, with follow-up probes and… - [Daily priorities plan prompt](https://learn.ynteractive.com/content/prompts/daily-priorities-plan-prompt): Paste your to-do list and fixed times and get a realistic plan for today: top three, time blocks, a buffer, and what to move to… - ["Do you service my area?" reply prompt](https://learn.ynteractive.com/content/prompts/service-area-question-reply-prompt): Answer "do you cover my town?" from your real service area list: a clear yes with how to book, a kind no, or a request for the… [All free prompt templates](https://learn.ynteractive.com/content/prompts) ## Visual guides The same ideas as quick visual guides: swipe through the slides, or read each one as text. - [Build your first AI agent in n8n](https://learn.ynteractive.com/content/visual/agent-can-act-quote): ChatGPT answers. An agent does something with the answer. - [Receipts to Google Sheets with an AI agent in n8n](https://learn.ynteractive.com/content/visual/receipt-extractor-spot-check): A box of paper receipts at the end of the month. Typing them in is slow and easy to get wrong. - [Automate Email Responses with AI: Drafts-Only System Message](https://learn.ynteractive.com/content/visual/email-agent-system-message): Automate email responses with generative AI without auto-sending: the system message from the AI Email Responder lesson that answers FAQs as drafts. [All visual guides](https://learn.ynteractive.com/content/visual) ## Keep reading - [n8n Simple Memory Explained for Beginners](https://learn.ynteractive.com/content/blog/n8n-simple-memory): n8n Simple Memory explained: what it keeps, why "save those ideas to the sheet" needs it, how email agents key it by thread, and when an agent needs none. - [Learn n8n for Beginners: 6 Free Projects in Order (2026)](https://learn.ynteractive.com/content/blog/learn-n8n-for-beginners): Learn n8n for beginners with six free, hands-on projects in a sensible order, from templates to AI agents to a web form, plus what you need for real. - [n8n AI Agent Tools: How the Agent Gets Things Done](https://learn.ynteractive.com/content/blog/n8n-ai-agent-tools): n8n AI agent tools explained: Google Sheets Tool and Gmail Tool vs regular nodes, naming tools in the system message, and limiting a tool to drafts. [All blog posts](https://learn.ynteractive.com/content/blog) · [All free tutorials](https://learn.ynteractive.com/content)