# n8n: Send Form Answers Straight to Google Sheets > Build a form in n8n (required field, email, dropdown), test it, and add every answer as a Google Sheets row with Append row in sheet. Free beginner lesson. Source: https://learn.ynteractive.com/content/n8n-form-to-google-sheets · Updated 2026-10-17 · Free from Stepthrough (https://learn.ynteractive.com) ## Practice it step by step [Start the free practice](https://learn.ynteractive.com/modules/n8n-form-trigger-to-sheet) [Take the free module: why it matters, practice and a quick check →](https://learn.ynteractive.com/courses/n8n-beginner/6) 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, about 10 minutes, and nothing touches your real accounts. [Open full screen](https://learn.ynteractive.com/modules/n8n-form-trigger-to-sheet) Free · Live now · [n8n Automation Toolkit](https://learn.ynteractive.com/content/course/n8n-automation-toolkit) · [n8n](https://learn.ynteractive.com/content/tool/n8n) · Google Sheets · ~10 min · 41 steps · Beginner Updated October 17, 2026. Built against the tool’s current screens and checked step by step. [How we check this lesson](https://learn.ynteractive.com/content/about#how-we-check) [n8n](https://learn.ynteractive.com/content/tool/n8n) can host a form for you and send every answer straight into a Google Sheet. In this free lesson a made-up bookkeeping firm builds a consultation request form with n8n's On form submission trigger: a required Name, an Email element and a Service dropdown. You send a test request, then add Google Sheets > [Append row](https://learn.ynteractive.com/content/glossary/append-row) in sheet, pick the document and sheet, and map each column by dragging. All of it happens in a practice copy of n8n, the form and the sheet. ## At a glance | Question | Answer | | --- | --- | | What you build | Build a consultation request form in n8n (required fields, email, dropdown), test it, and add every answer as a new row in Google Sheets. No webhook, no form tool to pay for. | | Tools | n8n | | Time | About 10 minutes, 41 steps in 3 parts | | Level | Beginner, no coding needed | | Cost | Free | | Ways to learn it | [Practice it step by step](https://learn.ynteractive.com/modules/n8n-form-trigger-to-sheet) | ### The 3 parts, in short 1. Build the form: Add the first step, On form submission, Form Title, First question, and 17 more steps. 2. Send a test request: Test the form, Name, Email, Open Service, and 4 more steps. 3. Add the row to a sheet: Add a step, Search for Sheets, Google Sheets, Append row in sheet, and 8 more steps. **Start here first:** [n8n: What Is n8n? Build Your First Workflow](https://learn.ynteractive.com/content/n8n-tutorial-for-beginners-first-workflow) (module 1 of n8n Automation Toolkit) **In the course:** [Part 9 · n8n Automation Toolkit](https://learn.ynteractive.com/content/course/part-9-n8n-automation-toolkit) (Module 75 of the [full course](https://learn.ynteractive.com/content/course)) **Part of:** [n8n for Beginners: Your First Automations](https://learn.ynteractive.com/content/paths/n8n-beginner) (step 5 of 9). Next up: [Find and Use n8n Templates](https://learn.ynteractive.com/content/find-and-use-n8n-templates) ## The sheet to make first Row 1 holds the headings n8n maps to. Add a Service column too if you want it, then use Refresh Column List in the node. | Name | Email | | --- | --- | | Priya Shah | priya@example.com | ## Build the form Start with On form submission, type a Form Title and use Add Form Element for each question. Element Type offers Text Input, Email, Number, Date, Dropdown, Checkboxes, File and more. + Add Attributes > Required Field adds a switch that makes the question compulsory; a Dropdown gets its choices under Field Options. ## Test it [Execute step](https://learn.ynteractive.com/content/glossary/execute-step) opens the test form in a new tab. Submit it and the trigger outputs 1 item with a field per question, plus submittedAt and formMode. ## Append the row Click the +, search sheets, choose Google Sheets and then Append row in sheet. Pick your Google credential (or create one with Sign in with Google), choose the Document and the Sheet, and n8n lists the sheet's headings under Values to Send. Drag each form field onto its column and click Execute step. ## Links - [n8n](https://n8n.partnerlinks.io/2a7wq6ej1z0t) (affiliate link): the workflow tool this lesson teaches (free trial, no credit card). - [n8n docs: Google Sheets node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets/): every Google Sheets action. Disclosure: links marked "affiliate link" are partner links. If you sign up through one, Stepthrough may earn a commission at no extra cost to you. The lesson is free either way and does not depend on it. ## Try it yourself, free Reading the steps is a start. Doing them is how it sticks. The interactive module walks you through every click in a practice copy of n8n, checks each step, and never touches your real accounts. [Start “n8n: Send Form Answers Straight to Google Sheets”](https://learn.ynteractive.com/modules/n8n-form-trigger-to-sheet) ## Step by step: n8n: Send Form Answers Straight to Google Sheets All 41 steps of the interactive module, in order. In the module you watch each one, then do it yourself in a practice copy that checks your work. ### 1. Build the form 1. **Add the first step.** Clearview Bookkeeping retypes every consultation request from email into a Google Sheet. You will make a form that adds the row by itself. Click **Add first step...**. Clearview Bookkeeping retypes every consultation request, from email into a Google Sheet. You'll make a form that adds the row by itself. 2. **On form submission.** Click **On form submission**. 3. **Form Title.** In **Form Title**, type **Request a consultation**. Give it a title. Request a consultation. 4. **First question.** Click **Add Form Element**. 5. **Name.** In **Label**, type **Name**. Label it Name. 6. **Add Attributes.** A request without a name is useless, so make it required. Click **+ Add Attributes**. A request with no name is no use. Make it required. 7. **Required Field.** The list has **Custom Field Name**, **Placeholder**, **Default Value** and **Required Field**. Choose **Required Field**. 8. **Turn it on.** A **Required Field** switch appears, off. Turn it on. A switch appears, and it's off. Turn it on. 9. **Second question.** Click **Add Form Element** again. Add another element. 10. **Email.** Label it **Email**. 11. **Element Type.** Open **Element Type** (it says **Text Input**). It says text input. 12. **Email.** The list runs from **Checkboxes** to **Text Input**. Choose **Email**, so the form checks it looks like an address. There's a type for everything. Dates, files, numbers, dropdowns. 13. **Third question.** Click **Add Form Element**. One more. Add Form Element. 14. **Service.** Label it **Service**. 15. **Element Type.** Open its **Element Type**. 16. **Dropdown.** Choose **Dropdown**: clients pick from your list instead of typing. Clients pick from your list, so the answers stay clean. 17. **First option.** Under **Field Options**, **Values 1**, type **Bookkeeping** in **Option**. Under field options, type Bookkeeping. 18. **Add Field Option.** Click **+ Add Field Option**. 19. **Second option.** Type **Tax preparation**. 20. **One more option.** Click **+ Add Field Option** again. And one more. 21. **Third option.** Type **Payroll**. ### 2. Send a test request 22. **Test the form.** Click **Execute step**. Your test form opens in a new tab. Test it. The form opens in a new tab. 23. **Name.** **Name** has a red star: required. Type **Priya Shah**. Name has a red star. It's required. 24. **Email.** Type **priya@example.com**. 25. **Open Service.** Open **Service** (it says **Select an option ...**). 26. **Tax preparation.** Choose **Tax preparation**. 27. **Submit.** Click **Submit**. Submit it. 28. **Back to n8n.** Switch back to the **n8n** tab. Go back to n8n. 29. **Close the node.** One item: **Name**, **Email**, **Service: Tax preparation**, **submittedAt** and **formMode**. Close the node. One item. Name, email, service, and the time. Close the node. ### 3. Add the row to a sheet 30. **Add a step.** Click the **+** after the trigger. Now send it to the sheet. 31. **Search for Sheets.** Type **sheets**. 32. **Google Sheets.** Click **Google Sheets**. 33. **Append row in sheet.** Ten actions, from **Create spreadsheet** to **Update row in sheet**. Click **Append row in sheet**: add one new row at the bottom. Ten actions. You want to add one new row at the bottom. 34. **Pick the spreadsheet.** **Credential** is already filled in: a saved Google login. (No credential yet? Pick **Create new credential** and **Sign in with Google**.) Open **Document**. Credential is already filled in. That's your saved Google login. If you don't have one yet, choose create new credential, and sign in with Google. 35. **Consultation requests.** Choose **Consultation requests**. Make this sheet first, with **Name** and **Email** in row 1. Make that sheet first, with Name and Email as the headings in row one. 36. **Pick the tab.** Open **Sheet**. 37. **Sheet1.** Choose **Sheet1**. 38. **Map the name.** n8n read row 1: **Values to Send** lists **Name** and **Email**. Drag **Name** from the INPUT onto the **Name** box (here, click it). n8n read your headings. Values to send lists Name and Email. Here, click it. 39. **Map the email.** Drag **Email** onto the **Email** box. Then Email onto Email. 40. **Add the row.** Click **Execute step**. This really adds the row to your sheet. This really adds the row to the sheet. 41. **Done.** OUTPUT: **1 item**, **Priya Shah**, **priya@example.com**: the row it wrote. Close the node. The output shows the row it wrote. Priya Shah, and her email. Close the node. ## Frequently asked questions **Does n8n have its own form builder?** Yes. The On form submission trigger hosts a form with the elements you add and passes each answer to the workflow. **How do I send n8n form data to Google Sheets?** Add Google Sheets > Append row in sheet after the form trigger, choose the document and sheet, and drag each form field onto its column. **Why is a column missing in Append row in sheet?** n8n reads the headings in row 1. Add the heading to the sheet, then choose Refresh Column List in the menu next to Values to Send. [Start this module free](https://learn.ynteractive.com/modules/n8n-form-trigger-to-sheet) - Previous in n8n Automation Toolkit: [n8n: Run a Workflow on a Schedule (Every Monday at 8am)](https://learn.ynteractive.com/content/n8n-schedule-trigger-tutorial) - Next in n8n Automation Toolkit: [n8n: Summarize Customer Emails with OpenAI](https://learn.ynteractive.com/content/n8n-openai-summarize-emails) ## More in n8n Automation Toolkit - [n8n: What Is n8n? Build Your First Workflow](https://learn.ynteractive.com/content/n8n-tutorial-for-beginners-first-workflow): What n8n is and how it thinks, then your first workflow: a client inquiry form that catches every request and writes a one-line summary. No code, no accounts to connect. - [n8n: Items, JSON and Expressions, Explained by Doing](https://learn.ynteractive.com/content/n8n-items-json-expressions-tutorial): See how n8n holds data: pin five fake invoices, read them as items, Table and JSON, then write one reminder per invoice and a late fee with drag-and-drop expressions. - [Find and Use n8n Templates](https://learn.ynteractive.com/content/find-and-use-n8n-templates): Skip the blank canvas. Find a ready-made workflow in the n8n template gallery, import it into your workspace, connect Google Sheets and Gmail, test it with a real form… - [Litescrape in n8n: Swap SerpApi for a Cheaper Search API](https://learn.ynteractive.com/content/litescrape-n8n-serpapi-alternative): Switch a weekly n8n competitor-price workflow from SerpApi to Litescrape's Google Shopping API: change the HTTP Request URL, move the key into a Bearer Auth credential… - [n8n: Execute Step, Execute Workflow and Publish](https://learn.ynteractive.com/content/n8n-execute-step-execute-workflow-publish): Learn the buttons in today's n8n editor: run one node with Execute step, pin test data, run everything with Execute workflow, then Publish and copy the Production URL. - [Webhooks and Forms in n8n: Capture Data from Anywhere](https://learn.ynteractive.com/content/n8n-webhook-and-form-trigger-tutorial): Stop losing quote requests between inboxes. Build a form n8n hosts for you, catch entries from your own website with a webhook, and save every request to one Google… [All 18 modules in n8n Automation Toolkit](https://learn.ynteractive.com/content/course/n8n-automation-toolkit) ## More n8n tutorials - [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… - [Lovable + n8n: Build a Web App with an AI Backend](https://learn.ynteractive.com/content/lovable-n8n-web-app-ai-backend): Build a contact form in Lovable and connect it to an n8n workflow — webhook trigger, AI Agent, Google Sheets, Gmail, and a Respond node that ties it all together. - [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 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. - [Daily Job Alerts: Email Each Tech Their Jobs from Google Sheets with n8n](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail): Every morning at 7, n8n reads a plumbing company's jobs sheet, skips anything not assigned yet, and emails each job to the tech it's assigned to — customer, address… - [Gmail AI Triage: Auto-Label Every Email and Draft Replies](https://learn.ynteractive.com/content/gmail-ai-triage-labels-drafts-n8n): Build an n8n workflow that reads each new email, sorts it as a lead, a client or an invoice with a Text Classifier, adds the matching Gmail label, and drafts a reply to… ## Free cheat sheet Print it or save the PDF: the key steps and checks from this lesson on one page, free. - [n8n Beginner Cheat Sheet: Triggers, Items, Expressions](https://learn.ynteractive.com/content/cheat-sheets/n8n-beginner): A free one-page n8n beginner cheat sheet: what n8n is, triggers vs actions, items and JSON, expressions, test vs production, schedules, forms and costs. [All free printable cheat sheets](https://learn.ynteractive.com/content/cheat-sheets) ## Terms in this lesson Plain-English definitions, each with an example from a free lesson. [Append row](https://learn.ynteractive.com/content/glossary/append-row) · [Webhook](https://learn.ynteractive.com/content/glossary/webhook) · [Execute step](https://learn.ynteractive.com/content/glossary/execute-step) [The full AI glossary](https://learn.ynteractive.com/content/glossary) ## Browse related tutorials [n8n Automation Toolkit (18)](https://learn.ynteractive.com/content/course/n8n-automation-toolkit) · [n8n tutorials (47)](https://learn.ynteractive.com/content/tool/n8n)