BigQuery: Permission denied while getting Drive credentials

Questions
1

Describe the problem/error/question

I use Big Query node and all is working fine. But if the table is connected to a Google Sheet I get above error.

My credentials I use Google Service Account API and I ticked the
Set up for use in HTTP Request node
My scope contains https://www.googleapis.com/auth/drive

And I shared the Google sheet with my service accounts email.

What is the error message (if any)?

BigQuery: Permission denied while getting Drive credentials.

Any hint?

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3
  • n8n version: latest
  • Database (default: SQLite): Postgres
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: debian
4

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