Able to choose a Document but not accees a Sheet

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

my API is active for Google Drive

Hi @JOduMonT, I am really sorry about this. Not seeing the sheets within a document would point towards a problem with the Google Sheets API, just like the “Missing permissions” error message.

Can you double check whether the Sheets API itself is enabled under https://console.cloud.google.com/apis/library/sheets.googleapis.com?

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.