> ## Content Index
> Fetch the complete content index at: https://piotrkrzyzek.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Solving the n8n Google Sheets Credential Headache
- URL: https://piotrkrzyzek.com/solving-the-n8n-google-sheets-credential-headache/
- Published: 2025-06-05T20:36:30.000Z
- Updated: 2026-10-14T14:47:14.000Z
- Description: Hitting a wall with n8n Google Sheets credential errors? Newer versions require two new OAuth2 URLs to fix failing authentication. Get the simple, step-by-step solution here.
- Author: Peter Krzyzek
- Tags: Technology

### What's The Problem?

I hit a wall the other day. I was spinning up a new n8n workflow for a project, and it was time to connect to Google Sheets, a task I've done a hundred times. I grabbed my OAuth Client ID and Secret from the Google Cloud Console, plugged them in, and... nothing. The authentication would fail every single time.

After trying to reconnect, remaking my credentials, and checking my Google Cloud project settings, I was about to lose my mind. Everything looked right, but it was clearly broken. If you're here, you've probably felt that same frustration. It turns out the fix is simple, but it's buried in a recent n8n update that isn't widely documented.

---

### The Fix: New OAuth2 Fields

It turns out that with newer versions of n8n, the Google Sheets credential setup now requires two additional fields that weren't there before. Your old credentials might still work, but if you're setting up a new connection, you'll be met with this new screen without much explanation.

Thanks to a solution from the user **sfortus** on the n8n community forums, the missing pieces are now clear. You just need to provide the **Authorization URL** and the **Access Token URL**.

Here are the exact settings you need to get your Google Sheets connection working again.

- **Grant Type:** `Authorization Code`
- **Authorization URL:** `https://accounts.google.com/o/oauth2/auth`
- **Access Token URL:** `https://oauth2.googleapis.com/token`

---

### Step-by-Step Guide

To make it crystal clear, here’s exactly what you need to do:

1. In your n8n instance, navigate to the **Credentials** section and click **Add credential**.
2. Search for and select **Google Sheets**.
3. You'll see the familiar fields for **Client ID** and **Client Secret**. Go ahead and paste your values in from the Google Cloud Console.
4. Now, you'll see the new fields. Copy and paste the following URLs into their respective boxes:
  - In the **Authorization URL** field, enter: `https://accounts.google.com/o/oauth2/auth`
  - In the **Access Token URL** field, enter: `https://oauth2.googleapis.com/token`
5. Ensure the **Grant Type** is set to `Authorization Code`.
6. Click **Save**, and then sign in with your Google account to authorize the connection.

That's it. Your connection should now authenticate successfully. This small, undocumented change is all it takes to fix the issue. Hopefully, this quick guide saves you the hours of frustration I went through. Happy automating!