How can I make Google Sheets Credential?

Questions
1

Describe the problem/error/question

image
image489×690 31.8 KB

What is the error message (if any)?

access_denied

Please share your workflow

OAuth 2.0 completed → Making Google Sheets Account → “access_denied”

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
2

You can follow instructions here

1 Like
3

Thank you so much. I try it but fail again haha..

image
image842×389 34.2 KB

4

Im not sure how to read your marking on the screenshot, but the steps you need are

  1. Login to google cloud console and create a credential (client id and secret)
  2. Enable the google sheets api
  3. Create a service account for the sheet api. This will give you a generated email address.
  4. In google drive share the parent folder with the service account email you received in the previous step

You should now be able to create and edit google sheets

I think you’re supposed to follow this one: