Google Cloud Project

Step 1: Set Up Google Cloud Project

Go to Google Cloud Console:

  1. Navigate to: https://console.cloud.google.com/
  2. Sign in with your Google account
  3. Create a new project:
    • Click the project dropdown (top left)
    • Click “New Project”
    • Project name: n8n-integrations
    • Click “Create”

Step 2: Enable Google Sheets API

  1. Go to APIs & Services → Library
  2. Search for: “Google Sheets API”
  3. Click on “Google Sheets API”
  4. Click “Enable”

Step 3: Create Service Account

  1. Go to APIs & Services → Credentials
  2. Click “Create Credentials” → “Service Account”
  3. Service account details:
    • Service account name: n8n-sheets-access
    • Description: Service account for n8n Google Sheets integration
  4. Click “Create and Continue”
  5. Skip role assignment (click “Continue”)
  6. Click “Done”

Step 4: Generate Service Account Key

  1. Click on your new service account (n8n-sheets-access)
  2. Go to the “Keys” tab
  3. Click “Add Key” → “Create new key”
  4. Select “JSON” format
  5. Click “Create”
  6. The JSON file will download automatically – save it securely!

The downloaded JSON file contains all the credentials you need. It should look something like this:

{
  "type": "service_account",
  "project_id": "n8n-integrations-...",
  "private_key_id": "abc123...",
  "private_key": "-----BEGIN PRIVATE KEY-----\n...",
  "client_email": "n8n-sheets-access@n8n-integrations-....iam.gserviceaccount.com",
  "client_id": "123456789...",
  ...
}
Scroll to Top