# How to Connect Google Sheets and Gmail to n8n > Connect Google Sheets to n8n step by step: Sign in with Google, the permission boxes, a separate Gmail credential, picking your sheet, and the usual snags. Source: https://learn.ynteractive.com/content/blog/connect-google-sheets-and-gmail-to-n8n · Updated 2026-11-01 · Free from Stepthrough (https://learn.ynteractive.com) Quick answer To connect Google Sheets to n8n, open the Credential dropdown on any Google Sheets node, choose Create new credential, click Sign in with Google, pick your account, allow access and click Continue; n8n saves the connection for every workflow after that. This guide is for anyone setting up their first [n8n workflow](https://learn.ynteractive.com/content/glossary/workflow) with Google, and you can practice the whole thing free in the [Find and Use n8n Templates](https://learn.ynteractive.com/content/find-and-use-n8n-templates) lesson, which connects both Google Sheets and Gmail. Last updated November 1, 2026 [Take the free module →](https://learn.ynteractive.com/courses/n8n-jump-start/3)Module 3 of the free [n8n Jump Start](https://learn.ynteractive.com/courses/n8n-jump-start) course, about 9 minutes. No account needed. By [Robert Breen](https://learn.ynteractive.com/content/about) · Published November 1, 2026 · Updated November 1, 2026 · 6 min read n8n · Google Sheets · Gmail ## Watch: the idea in 0:50 ### Connect Google Sheets to n8n Explainer · 0:50 · with captions Connect Google Sheets to n8n step by step: Sign in with Google, the permission boxes, a separate Gmail credential, picking your sheet, and the usual snags. **Transcript** You probably copy rows from a sheet into ChatGPT by hand. n8n can read the sheet itself. First, you connect Google, once. Open the Credential dropdown. Click Create new credential, then Sign in with Google. Allow access, and click Continue. n8n saves it for every workflow after that. Google lists what n8n may do. Allow Sheets, and allow Drive too. n8n needs Drive to find your spreadsheets by name. Gmail needs its own credential and sign-in. Emails go out from the account you connect, so pick the office inbox, not a personal one. If your sheet isn't in the list, you probably signed in with a different account. Create and name the sheet first, so you can find it in the list. Connect it free in Find and Use n8n Templates. Nothing real is connected. Gmail is a separate credential with its own sign-in. The steps below cover both, plus the two places people get stuck: picking the right Google account and finding the right spreadsheet. ## How do you connect Google Sheets to n8n? Create a Google Sheets credential from the node's **Credential** dropdown and sign in with Google. On [n8n Cloud](https://learn.ynteractive.com/content/glossary/n8n-cloud) there's no Google developer setup: n8n handles it through **Managed OAuth2**. The steps from the lessons: 1. Open a Google Sheets node and click the **Credential** dropdown. 2. Click **Create new credential**. 3. Leave it on **Managed OAuth2** and click **Sign in with Google**. 4. Pick the Google account that owns the spreadsheet. 5. Allow access. Google lists what n8n may do in Sheets. Depending on the screen, tick **Select all**, or check the three boxes: **See, edit, create, and delete all your Google Sheets spreadsheets**, **See, edit, create, and delete all of your Google Drive files** and **Connect to an external service**. 6. Click **Continue**. Google hands the connection back to n8n, and you see **Account connected** (or "connection successful"). The Drive permission matters even though you only want Sheets. The lessons explain that n8n needs Drive access to find your spreadsheets by name. ## Do you have to connect Google again for every workflow? No. n8n saves the credential, so every later workflow can pick it from the list. In the [Daily Job Alerts](https://learn.ynteractive.com/content/n8n-daily-job-alerts-google-sheets-gmail) lesson, the Google Sheets step simply chooses **Google Sheets account** from the Credential dropdown, the one created earlier, and n8n already has permission. The same goes for [OpenAI](https://learn.ynteractive.com/content/glossary/openai) and Gmail credentials. Create each one once, give it a name you'll recognize, and reuse it. ## Why does Gmail need its own credential? Gmail and Google Sheets are separate Google services, so n8n asks for separate permission for each. In the job alerts lesson, the Gmail step needs "its own permission": **Credential**, **Create new credential**, **Sign in with Google**, then you pick the account the emails should come from (for a business, usually the office account) and click **Continue**. Two things to know about the Gmail sign-in: - **Pick the sending account on purpose.** Emails go out from whichever Gmail account you connect. In the lessons, that's the office inbox, not a personal one. - **The permission list is longer.** Google lists broad email permissions. In the AI Email Responder lesson, the narration points out that what actually happens is decided by the nodes you add, such as creating drafts instead of sending. Once connected, the credential shows up as **Gmail account** and can be reused, for example by a Gmail trigger and a Gmail Tool in the same workflow. ## How does an n8n template connect your accounts? An imported template opens with a **Set up template** window that lists every account it needs, and you create each credential from there. In the template lesson, the booking-request workflow for Hillside Pet Grooming (a made-up business) needs two: 1. Under **1. Google Sheets**, click **Create new Google Sheets credential**, sign in with Google, tick **Select all**, click **Continue**, then close the window. 2. Under **2. Gmail**, click **Create new Gmail credential** and do the same. 3. When both have a green check, click **Continue**. n8n puts each credential into the right step. [How to Use n8n Templates](https://learn.ynteractive.com/content/blog/how-to-use-n8n-templates) covers the rest of the template, from finding it in the gallery to publishing it. ## Try it free, step by step **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 entry and publish it. 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-templates) [Or read the full step-by-step guide](https://learn.ynteractive.com/content/find-and-use-n8n-templates) ## How do you point n8n at the right spreadsheet? After the credential, choose the spreadsheet in the **Document** dropdown and the tab in the **Sheet** dropdown. The template can't know which spreadsheet is yours, so its Google Sheets step shows a warning until you pick one. 1. Click **Document** and choose your spreadsheet by name (in the lesson, **Hillside Booking Requests**). 2. Click **Sheet** and choose the tab (**Sheet1**, or **Jobs** in the job alerts lesson). 3. Check the **Operation**. **Get row(s) in sheet** reads rows; **Append Row** adds a new row at the bottom. Name the spreadsheet before you go looking for it. The [AI Receipt Extractor](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets) lesson renames the new file to **Invoices** first, "so you can find it in n8n's list." Put the column headers in row 1, too. The template expects Name, Email, Pet name and Submitted; the receipt sheet uses Date, Category, Vendor and Amount. ## What goes wrong when connecting Google to n8n? Most problems come from the wrong Google account, a spreadsheet n8n can't see yet, or a missed permission box. Check these in order: - **The wrong Google account.** The Document list only shows spreadsheets the connected account can reach. If your sheet is missing, you probably signed in with a different account. Create a new credential with the account that owns the sheet. - **A spreadsheet that doesn't exist yet.** Create the sheet first. The receipt lesson builds it in a **Bookkeeping** folder shared with an accountant, where Google asks you to confirm with **Create and share** before making the file. If your folder isn't shared, you won't see that step. - **An unchecked box.** If a permission was left unticked, the node can fail later. Reconnect and allow every box the lesson shows. - **Headers that don't match.** n8n reads the header row to list your columns, so typos in row 1 become mismatched fields. - **A self-hosted n8n.** The lessons use n8n Cloud, where Sign in with Google works out of the box. Self-hosted n8n usually needs extra Google setup first, so check n8n's own documentation. ## What does it cost to connect Google to n8n? The Google connection itself is just a sign-in: the lessons use a regular Google account with Sheets and Gmail. n8n Cloud is a paid service after a free trial, or you can self-host n8n. AI steps add an OpenAI API key, which is pay-as-you-go and billed separately from ChatGPT plans. The Stepthrough lessons are free and run in a practice copy, so nothing is connected, sent or billed. [Email Each Tech Their Jobs Every Morning](https://learn.ynteractive.com/content/blog/n8n-daily-job-emails-google-sheets) puts both credentials to work in one workflow, and the [n8n tool page](https://learn.ynteractive.com/content/tool/n8n) lists every n8n lesson. If you would rather have the connections and the workflow set up for you, see [n8n consulting](https://ynteractive.com/hire-an-n8n-developer) with Robert Breen. ## Key takeaways - On n8n Cloud, Google Sheets connects through Credential, Create new credential and Sign in with Google, with Managed OAuth2 and no Google developer setup. - The Google Sheets credential needs Sheets and Drive permissions, because n8n uses Drive access to find spreadsheets by name. - Gmail is a separate credential, and emails are sent from whichever Gmail account you connect. - n8n saves each credential, so later workflows pick it from the Credential dropdown instead of signing in again. - If a spreadsheet is missing from the Document list, the connected Google account usually can't see it. ## Frequently asked questions **Do I need a Google Cloud project to connect Google Sheets to n8n?** Not on n8n Cloud. Leave the credential on Managed OAuth2 and click Sign in with Google. Self-hosted n8n usually needs extra setup, so check n8n's documentation. **Can one Google credential cover Sheets and Gmail?** In the lessons, no. Google Sheets and Gmail each get their own credential, created with their own Sign in with Google. **Why can't I find my spreadsheet in the Document dropdown?** The connected Google account probably can't see it, or the file doesn't exist yet. Check which account you signed in with and name the sheet first so it's easy to find. **Which Gmail account should I connect?** The account the emails should come from. For a business, the lessons use the office inbox rather than a personal account. ## Free lessons in this post - [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… - [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. - [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… ## Watch it in a free lesson: Find and Use n8n Templates ### Find and Use n8n Templates: video walkthrough Full walkthrough · 3:32 · with captions 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 entry and publish it. 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/find-and-use-n8n-templates#watch) From the free lesson [Find and Use n8n Templates](https://learn.ynteractive.com/content/find-and-use-n8n-templates) ## Related terms Plain-English definitions, each with an example from a free lesson. [Workflow](https://learn.ynteractive.com/content/glossary/workflow) · [n8n Cloud](https://learn.ynteractive.com/content/glossary/n8n-cloud) · [OpenAI](https://learn.ynteractive.com/content/glossary/openai) · Accounts payable · [AR aging report](https://learn.ynteractive.com/content/glossary/ar-aging-report) · [Audit trail](https://learn.ynteractive.com/content/glossary/audit-trail) · [Automation](https://learn.ynteractive.com/content/glossary/automation) · [Autoresponder](https://learn.ynteractive.com/content/glossary/autoresponder) [The full AI glossary](https://learn.ynteractive.com/content/glossary) ## Related prompts - [Appointment reminder text prompt and examples](https://learn.ynteractive.com/content/prompts/appointment-reminder-text-prompt): Appointment reminder text examples and a ChatGPT prompt that writes day-before reminders: time window, who is coming, one prep… - [Automation candidates prompt](https://learn.ynteractive.com/content/prompts/automation-candidates-prompt): Rank your repetitive tasks by which to automate first, using only your own counts and minutes, with a first workflow sketched… - [Automation time savings estimate prompt](https://learn.ynteractive.com/content/prompts/automation-time-savings-estimate-prompt): Estimate what one automation saves from your own numbers only: minutes before and after, setup and upkeep, costs you look up… - [Customer intake form questions prompt](https://learn.ynteractive.com/content/prompts/customer-intake-form-questions-prompt): Design the questions for a booking or intake form: only what you need to do the job, each with a field type, help text and a… [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. - [What is automation, really?](https://learn.ynteractive.com/content/visual/term-automation): AI term of the day: automation. - [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. - [How to use n8n templates without the red warnings](https://learn.ynteractive.com/content/visual/n8n-templates-myth): Most people copy an n8n template, see a canvas full of red warnings and give up. The warnings just mean the template can't know your accounts or your data. [All visual guides](https://learn.ynteractive.com/content/visual) ## Keep reading - [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. - [Mail Merge from Google Sheets to Gmail with n8n](https://learn.ynteractive.com/content/blog/mail-merge-google-sheets-gmail): Mail merge from Google Sheets to Gmail with n8n: one personalized email per row, with a filter, safe test sends and the settings that matter. - [Google Sheets as a Database for Automation: Set It Up](https://learn.ynteractive.com/content/blog/google-sheets-as-a-database): Use Google Sheets as a database for automation: exact headers in row 1, one row per item, a lookup tab, a review column, and reading vs appending in n8n. [All blog posts](https://learn.ynteractive.com/content/blog) · [All free tutorials](https://learn.ynteractive.com/content)