I’m able to choose a Document but not a Sheet
The most explicit message I could get is
OUTPUT
1 item
ERROR: Missing permissions for Google Sheet
Please check that the account you're using has the right permissions. (If you're trying to modify the sheet, you'll need edit access.)
Details
Time
24/11/2022, 10:39:44
Stack
NodeApiError: Missing permissions for Google Sheet
at Object.apiRequest (/app/code/node_modules/n8n-nodes-base/dist/nodes/Google/Sheet/v2/transport/index.js:46:19)
at processTicksAndRejections (node:internal/process/task_queues:96:5)
at async GoogleSheet.spreadsheetGetSheetNameById (/app/code/node_modules/n8n-nodes-base/dist/nodes/Google/Sheet/v2/helpers/GoogleSheet.js:51:26)
at async Object.router (/app/code/node_modules/n8n-nodes-base/dist/nodes/Google/Sheet/v2/actions/router.js:65:33)
at async Object.execute (/app/code/node_modules/n8n-nodes-base/dist/nodes/Google/Sheet/v2/GoogleSheetsV2.node.js:20:16)
at async Workflow.runNode (/app/code/node_modules/n8n-workflow/dist/Workflow.js:658:28)
at async /app/code/node_modules/n8n-core/dist/WorkflowExecute.js:585:53
![](https://flow.sotthi.com/rest/node-icon/n8n-nodes-base.googleSheets)
Google Sheets
Execute node
Parameters
[
Docs
](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets/?utm_source=n8n_app&utm_medium=node_settings_modal-credential_link&utm_campaign=n8n-nodes-base.googleSheets)
Authentication
Fixed
Expression
Credential for Google Sheets OAuth2 API
Resource
Operation
Document
Fixed
Expression
Sheet
Fixed
Expression
Filters
Currently no items exist
Add Filter
Options
No properties
I wish this node would...
## Workflow has issues
**Google Sheets**: Not a valid Sheet ID
I have no workflow yet
(Select the nodes and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow respectively)
Information on your n8n setup
- n8n version: 0.203.1
- Database: PostgreSQL
- Running n8n via: Docker