How can i fix Google Sheet Triggers error credentials?

[tuanvo1229]

I created Google Sheets Trigger account credentials, but I can’t find the credentials data section that includes the two fields: Client ID and Client Secret to input. Instead, it defaults to requiring signing in directly with a Google account. Although I successfully signed in, when testing the event, it shows the error:
‘Forbidden - perhaps check your credentials’

Has anyone encountered this situation before? Can you please guide me on how to fix this issue?

Thanks everyone!

[hrishikesh]

You can try deleting that credential and try adding a new one.

[HenryPuppet]

If I understand you correctly, you are asking where you can find your client ID and secret.

1. Login into Google Cloud Services, select API Services → Credentials.
2. From there, click on the OAuth Client ID you created to use Google Sheets.
3. You’ll see your OAuth 2.o Client ID’s.
4. Click on the client you created to use Google Sheets.
5. This will take you a page that shows your Client ID and Secret.
6. Copy/Paste them into the n8n credential you are creating for Google Sheets.

Make sure you have enabled the Google Sheets API:

1. Go to API Services->Library
2. Scroll down until you find Google Sheets
3. There will be a button that either says “Enable” (if it’s not enabled) or “Manage” if it’s already enabled.

That should do it. I hope this helps.