Actions11
Sheet → Get All
AI-generatedOverview
This node allows interaction with Google Sheets using a Google Service Account for authentication. It supports various operations on spreadsheets, sheets, and rows, such as creating, retrieving, appending, updating, deleting, and clearing data. This node is useful for automating workflows that require reading or modifying Google Sheets data programmatically, for example, syncing data between apps, generating reports, or managing spreadsheet content without manual intervention.
Use Case Examples
- Automatically retrieve all sheets within a spreadsheet to process their data.
- Append new rows to a specific sheet based on incoming data from another source.
- Clear data ranges in a sheet to reset content before new data import.
Properties
| Name | Meaning |
|---|---|
| Authentication | Choose the authentication method: use saved credentials or enter service account details manually. |
| Service Account Email | The email address of the Google service account used for authentication (required if manual authentication is selected). |
| Private Key | The private key from the service account JSON used for authentication (required if manual authentication is selected). |
| Impersonate Email (Optional) | Email of the user to impersonate, requires domain-wide delegation (optional, manual authentication only). |
| Spreadsheet ID | The ID of the Google spreadsheet to operate on (required for sheet and row resources). |
Output
JSON
json- Contains the response data from the Google Sheets API for the requested operation, such as sheet details, appended data confirmation, or retrieved rows.
Dependencies
- Google Sheets API via googleapis library
Troubleshooting
- Ensure that the service account has the necessary permissions to access the target spreadsheet.
- If using manual authentication, verify that the private key is correctly formatted and includes proper newline characters.
- When impersonating a user, confirm that domain-wide delegation is enabled and the impersonated user has access to the spreadsheet.
- Common errors include missing credentials, invalid spreadsheet ID, or insufficient permissions, which can be resolved by checking credentials and spreadsheet sharing settings.
Links
- Google Sheets API Documentation - Official documentation for the Google Sheets API used by this node.
- Google Cloud Service Accounts - Information on creating and managing Google Cloud service accounts for authentication.