Google Sheets
Turn Google Sheets into a lightweight database. This node allows you to bidirectionally sync data between your automated workflows and your spreadsheets. Perfect for logging events, creating automated reports, or fetching config tables directly from Google Drive.
What can you do with Google Sheets?
Automated Reporting
Instantly append new rows to a designated sheet. Perfect for aggressively tracking inbound leads from automated webhooks, or logging daily analytics summary metrics.
Relational Data Lookup
Search for specific rows matching an exact index value and update them in real-time, effectively functioning just like a transactional relational database.
OAuth2 Secure Sync
Connects securely directly through Google's native OAuth 2.0. No need to mess with complex Google Cloud Service Accounts or exposing public sheet links.
Detailed Usage & Configuration
The Google Sheets node acts as an instant database connector for non-technical teams. By plugging into Google's native API, you can seamlessly read tabular data or aggressively append new analytics rows.
1. Connection & Setup
Before configuring operations, securely authenticate the node by selecting your pre-configured Google OAuth2 Credential. Once authenticated, the node can interact with any Spreadsheet your account has access to.
2. Standard Operations
You can configure multiple distinct operations based on the automation goal:
- Read Rows: Retrieve an entire sheet (or distinct range) into your workflow. The node natively converts the row headers into strict JSON keys (e.g.,
[{"First Name": "John"}]), making it exceptionally easy to loop through. - Append Row: Push data linearly. When a new Webhook fires (like a Stripe Sale), map the variables to column headers and append the row instantly to the bottom of your designated spreadsheet.
- Update Row: Function dynamically. Define a unique lookup column (like
Customer ID). The node searches for the exact row matching the ID and updates only that specific row natively.
3. Important Limitations
Be aware of Google's API strict rate limits. Attempting to loop and "Append Row" 5,000 individual times rapidly will likely trigger a 429 Quota Exceeded block. When handling massive data flows, inject a Wait node (e.g., 500ms delay) within the loop iteration, or format data locally in the Code node before bulk pushing.