Google Sheets
Google Sheets
Section titled “Google Sheets”Integrate with Google Sheets to perform operations on spreadsheets and data.
What it does
Section titled “What it does”Reads, writes, and manages data in Google Sheets spreadsheets.
When to use it
Section titled “When to use it”Use this node to automate spreadsheet operations, log data, or sync information with Google Sheets.
Inputs and settings
Section titled “Inputs and settings”| Setting | Notes |
|---|---|
| Resource | Source-backed field from the node schema. |
| Spreadsheet Operation | Source-backed field from the node schema. |
| Worksheet Operation | Source-backed field from the node schema. |
| Data Operation | Source-backed field from the node schema. |
| Spreadsheet | Source-backed field from the node schema. |
| Worksheet | Source-backed field from the node schema. |
| Range | Source-backed field from the node schema. |
| Title | Source-backed field from the node schema. |
| Sheet Title | Source-backed field from the node schema. |
| Index | Source-backed field from the node schema. |
| Rows | Source-backed field from the node schema. |
| Columns | Source-backed field from the node schema. |
| Sheet Definition | Source-backed field from the node schema. |
| Data | Source-backed field from the node schema. |
| Value Input Option | Source-backed field from the node schema. |
| Include Values In Response | Source-backed field from the node schema. |
Outputs
Section titled “Outputs”Returns the service response or a success object from the selected operation.
Dependencies and credentials
Section titled “Dependencies and credentials”- Credential type: OAuth2.
Example workflow
Section titled “Example workflow”Connect prepared data into Google Sheets, select the credential, choose the operation, then map previous node values into the operation fields.
Troubleshooting
Section titled “Troubleshooting”- Check that required settings are present before running the node.
- If the node uses browser page data, run it on the target tab after the page has loaded.
- If it calls an external service, verify credentials, permissions, and rate limits.
- No dedicated source test was found next to this node; verify behavior manually when changing this page.