# n8n Google Sheets Errors: Sheet Not Found and 5 More > Fix n8n Google Sheets errors: "Sheet with ID gid=0 not found", "At least one value has to be added under Values to Send", permissions and columns. Source: https://learn.ynteractive.com/content/blog/n8n-google-sheets-errors · Updated 2026-10-20 · Free from Stepthrough (https://learn.ynteractive.com) Quick answer Most n8n Google Sheets errors come from three settings: the **Credential** (wrong Google account), the **Sheet** (a tab code that isn't in your spreadsheet) and the [column mapping](https://learn.ynteractive.com/content/glossary/field-mapping) (nothing mapped, or names that don't match). "Sheet with ID gid=0 not found" means the node points at a tab that doesn't exist, so pick the tab from the list again. The free [n8n Google Sheets lesson](https://learn.ynteractive.com/content/n8n-google-sheets-read-append-update) hit and fixed this error in a real test. Last updated October 20, 2026 [Take the free module →](https://learn.ynteractive.com/courses/n8n-jump-start/12)Module 12 of the free [n8n Jump Start](https://learn.ynteractive.com/courses/n8n-jump-start) course, about 12 minutes. No account needed. By [Robert Breen](https://learn.ynteractive.com/content/about) · Published October 20, 2026 · Updated October 20, 2026 · 4 min read n8n · Google Sheets · Troubleshooting ## "Sheet with ID gid=0 not found" The node has a tab ID that isn't in the chosen spreadsheet. It happens most with templates, which ship with the tab code from the author's own sheet. Fix: open the node, click the **Sheet** box and pick your tab from the list (for example **Sheet1** or **Content Requests**). Don't type an ID or paste a URL. In the lesson's test, choosing the tab from the list cleared the error at once. ## "At least one value has to be added under Values to Send" The node is set to **Map Each Column Manually** and every column is empty. Fix: map at least one column, or switch **Mapping Column Mode** to **Map Automatically** if your incoming field names equal the sheet's headers. In the [Meeting to Action lesson](https://learn.ynteractive.com/content/meeting-notes-to-action-items-sheet-and-deck-chatgpt-n8n-gamma) the test run failed with this message until the mode was changed to Map Automatically, which matched Meeting, Owner, Task, Due date and Status to the same-named columns. ## The spreadsheet isn't in the Document list The credential belongs to a different Google account than the one that owns or can open the file. Fix: click the **Credential** box and pick the one for your own account. n8n may pre-fill a credential; the lessons say not to trust it and to check. On [n8n Cloud](https://learn.ynteractive.com/content/glossary/n8n-cloud) a new credential just asks you to sign in with Google and click Allow. ## "The caller does not have permission" Google refused the request. The account behind the credential can view but not edit, or can't open the file at all. Fix: share the spreadsheet with that Google account as an editor, or reconnect with the account that owns it. View-only access is enough for [Get row(s)](https://learn.ynteractive.com/content/glossary/get-rows) but not for Append or Update. ## Columns are empty or in the wrong place Row 1 isn't a clean header row, or the field names don't match the headers. - Row 1 must hold one column name per cell. In the Meeting to Action lesson, the headers are typed with the Tab key between them so each lands in its own cell. - Map Automatically needs exact names. The meeting notes lesson uses lowercase task, owner and due because the AI's fields are lowercase. - If headers changed after you set up the node, reopen it so n8n reloads the column list. ## Get row(s) returns no items The tab is empty below the header, the node has a filter that matches nothing, or it points at the wrong tab. Click **Execute step** and read the OUTPUT: the lessons expect a specific count (8 items, 5 items, 2 items), which is a quick sanity check. ## Try it free, step by step **n8n: Read, Add and Update Google Sheets Rows with an AI Step**. Learn n8n's three core Google Sheets moves on a made-up request list: read the rows, add a new one without duplicates, then let an AI step write a description and update each row. 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/n8n-google-sheets-read-append-update) [Or read the full step-by-step guide](https://learn.ynteractive.com/content/n8n-google-sheets-read-append-update) ## Rows are added twice That isn't an error message, but it's the most common sheet problem. Plain Append row adds a row on every run. Use **Append or update row** with a **Column to match on**; see [n8n Append or Update Row](https://learn.ynteractive.com/content/blog/n8n-append-or-update-row). ## A checklist before you publish 1. Credential is your own Google account. 2. Document and Sheet were picked from the lists. 3. Row 1 has clean, unique headers. 4. Every needed column is mapped, or names match for Map Automatically. 5. Append vs Append or update is a deliberate choice. 6. You ran it twice and counted rows. ## Key takeaways - gid=0 not found means a tab ID that isn't in your spreadsheet; pick the tab from the list. - "At least one value has to be added" means nothing is mapped; map a column or use Map Automatically. - A missing spreadsheet or a permission error points at the credential's Google account. - A clean header row prevents most mapping problems. ## Frequently asked questions **What does "Sheet with ID gid=0 not found" mean in n8n?** The node is looking for a tab ID that isn't in the selected spreadsheet. Open the Sheet box and choose the tab from the list. **Why can't n8n see my Google Sheet?** The credential is signed in to a different Google account, or that account has no access to the file. Pick or create a credential for the owning account. **Do I need a Google Cloud project for n8n Google Sheets?** On n8n Cloud, no: the credential signs in with Google directly. Self-hosted n8n needs your own OAuth client. **Where do I learn more?** The [n8n Google Sheets Node Cheat Sheet](https://learn.ynteractive.com/content/blog/n8n-google-sheets-node-cheat-sheet), the n8n warnings and red nodes guide, and the free [n8n Jump Start](https://learn.ynteractive.com/courses/n8n-jump-start) course. ## Free lessons in this post - [n8n: Read, Add and Update Google Sheets Rows with an AI Step](https://learn.ynteractive.com/content/n8n-google-sheets-read-append-update): Learn n8n's three core Google Sheets moves on a made-up request list: read the rows, add a new one without duplicates, then let an AI step write a description and… - [Meeting to Action: Recap, Tracker Rows and a Kickoff Deck (ChatGPT, n8n, Gamma)](https://learn.ynteractive.com/content/meeting-notes-to-action-items-sheet-and-deck-chatgpt-n8n-gamma): Turn rough meeting notes into a checked recap in ChatGPT, four action-item rows in a Google Sheet through n8n, and a five-slide kickoff deck in Gamma. - [n8n: Turn Meeting Notes into Action Items in a Google Sheet](https://learn.ynteractive.com/content/meeting-notes-to-action-items-google-sheets-ai-n8n): Build an n8n workflow that reads your meeting notes from a sheet, has AI pull out who agreed to do what by when, and adds one row per task to an Action Items sheet. ## Watch it in a free lesson: n8n AI Agent Tutorial: Save Social Media Ideas to Google Sheets ### AI Social Media Idea Agent: video walkthrough Full walkthrough · 8:07 · with captions 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, memory, and the Sheets tool. 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/n8n-ai-agent-tutorial-google-sheets#watch) From the free lesson [n8n AI Agent Tutorial: Save Social Media Ideas to Google Sheets](https://learn.ynteractive.com/content/n8n-ai-agent-tutorial-google-sheets) ## Related terms Plain-English definitions, each with an example from a free lesson. [Field mapping](https://learn.ynteractive.com/content/glossary/field-mapping) · [n8n Cloud](https://learn.ynteractive.com/content/glossary/n8n-cloud) · [Get rows (reading a sheet)](https://learn.ynteractive.com/content/glossary/get-rows) · [Coda](https://learn.ynteractive.com/content/glossary/coda) · [JSON array](https://learn.ynteractive.com/content/glossary/json-array) · [Manual trigger](https://learn.ynteractive.com/content/glossary/manual-trigger) · [Miro](https://learn.ynteractive.com/content/glossary/miro) · [n8n data store node (Data table)](https://learn.ynteractive.com/content/glossary/data-store-node) [The full AI glossary](https://learn.ynteractive.com/content/glossary) ## Keep reading - [n8n Append or Update Row: Stop Duplicate Sheet Rows](https://learn.ynteractive.com/content/blog/n8n-append-or-update-row): Why n8n adds the same Google Sheets row on every run, and how Append or update row with Column to match on fixes it, with a test that proves it. - [n8n Google Sheets Node Cheat Sheet: Get, Append, Update](https://learn.ynteractive.com/content/blog/n8n-google-sheets-node-cheat-sheet): Every n8n Google Sheets operation on one page: Get row(s), Append row, Append or update row, Update row, Column to match on and Map Automatically. - [n8n OpenAI Node Errors: 401, Empty Model List, Raw Braces](https://learn.ynteractive.com/content/blog/n8n-openai-node-errors): Fix n8n OpenAI node problems: "401 Authorization failed", a Model list that won't load, {{ }} sent as plain text, long answers and costs per item. [All blog posts](https://learn.ynteractive.com/content/blog) · [All free tutorials](https://learn.ynteractive.com/content)