Do Service Accounts work when creating spreadsheets?

Questions
1

Describe the problem/error/question

When using the Create spreadsheet node with a service account, I am receiving a permission denied error. Could it be that it is not working with the service account?

What is the error message (if any)?

image
image580×926 72.7 KB

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.108.2
  • Database (default: SQLite): Postgresql
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker / Self-hosted
  • Operating system: Ubuntu
2

Hey @justmumu hope all is good. Welcome to the community.

Based on the documentation, Google Sheets node supports using service accounts.

Additionally, the error appears to be related to the permissions of your service account rather than service inaccessibility.

3

Hello @jabbson, thanks for your reply. Drive & Sheets API is enabled on GCP side. And we cannot configure any API-specific permissions for service accounts. I can read an existing sheet/document. I think that if there were a permission problem, I wouldn’t be able to read it. That’s why I don’t think it makes sense.

Additionally, when I manually use the HTTP Request node with API endpoints such as https://www.googleapis.com/drive/v3/files, I am getting quota error instead of a permission error. (btw, the account has quota and this is another frustrating issue.)

4

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