n8n-nodes-service-account-google-sheets

This is an n8n community node that provides comprehensive Google Sheets integration using Service Account authentication.

Features

Main Node Operations

Spreadsheet

• Create: Create a new spreadsheet
• Get: Get spreadsheet information

Sheet (Tabs)

• Create: Create a new sheet/tab
• Delete: Delete a sheet/tab
• Get All: List all sheets
• Append: Append data to a sheet
• Clear: Clear data from a sheet

Row

• Append: Append new rows
• Get: Read rows
• Update: Update rows
• Delete: Delete rows

Trigger Node (Webhook)

• Real-time monitoring of spreadsheet changes via Drive API
• Events: Spreadsheet Updated, Spreadsheet Shared

Authentication

Supports two authentication methods:

1. Saved Credential: Use credentials saved in n8n
2. Manual: Enter credentials for each execution

Both methods support:

• Service Account authentication
• Domain-Wide Delegation (user impersonation)

Installation

npm install n8n-nodes-service-account-google-sheets

Or install directly in n8n:

1. Go to Settings → Community Nodes
2. Search for n8n-nodes-service-account-google-sheets
3. Install

Setup

1. Create a Service Account in Google Cloud Console
2. Enable Google Sheets API
3. Download the JSON key file
4. Add credentials in n8n with:
   • Service Account Email
   • Private Key
   • (Optional) User email to impersonate

License

MIT

Author

Alexandre Jaques - alexandre@chatguru.com.br