Google Sheets Service Account Not available as an option

Questions
1

Hi I’m trying to create a trigger with google sheets. I have already added google service account credential. Unfortunately that is not an option for the trigger. I see the credential available for gmail but not for sheets.

I have checked here and sheet is supposed to be available.

For those of us self hosting, this is the only option available without using a tunnel since google won’t accept ‘localhost’ as a valid URI .

Information on your n8n setup

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

Oh, you don’t need a service credential for that.
I use Google Sheets OAuth2 API without any issues.

Check this video on how to get it:

If my reply answers your question, please remember to mark it as a solution.

3

Hey, I have the same problem: A service account is set up and works with other google nodes, but in gsheets it just doesn’t show up in the list of credentials.

I know OAuth2 API works but can’t use it in this project due to company policy.
Any ideas how we can get the gsheets node work with a service account?

We’re using the cloud version.

4

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