Credentials and API keys

Questions
1

Hello, I am learning how to set up credentials but this is frustrating. I follow AI suggestions to the letter and troubleshooted left to right. Keep getting the same problem over and over. I can use n8n until I get the basics down. Someone please help.

OAuth Authorization Error There was a problem generating the authorization URL Request failed with status code 431

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 need to write clearly if you want to get help.

What was that? Are you having issue with Google OAuth setup?

Remember, vague questions get vague responses

3

I apologize, I am literally that new to this. But yes Google Sheets specifically. It wont let me upload attachments, it says it is because I am a new user, or i would attach my workflow. I will do my best to relay as much information as possible on the matter. I am what you would call desperate.

4

Perhaps these would help?

https://community.n8n.io/tags/c/tutorials/english/29/google-sheets/26

6

Access blocked: This app’s request is invalid

You can’t sign in because this app sent an invalid request. You can try again later, or contact the developer about this issue. Learn more about this error

If you are a developer of this app, see error details.

Error 400: redirect_uri_mismatchDid that. No dice. I get this message popping up on a separate page. incognito or not. No more 431 in the workflow though.

8

Okay guys. One problem solved and another arises. So i started from scratch with the whole process made sure to only sign in with one email. Even used incognito mode just to be safe. Not sure what the root problem was but credentials creation and connection was finally a success. Thank everyone for their support. Now despite being connected it isn’t accessing the google sheet i created it won’t pull down from the list of documents.

9

Yes. Make sure both account and email tally.

The ClientID and API key must be for the email account that you intend to use.

Also make sure to setup Authorised redirect URIs

image
image523×191 2.11 KB

11

good day @meadorsean231
The different email account is unlikely to be the root cause, because redirect_uri_mismatch happens before Google completes account authorization. I would copy the exact OAuth redirect URL shown in n8n and add that exact value to the Authorized redirect URIs of the same Google OAuth client ID used in your n8n credential.

12

Okay guys. One problem solved and another arises. So i started from scratch with the whole process made sure to only sign in with one email. Even used incognito mode just to be safe. Not sure what the root problem was but credentials creation and connection was finally a success. Thank everyone for their support. Now despite being connected it isn’t accessing the google sheet i created it won’t pull down from the list of documents.

13

Please share your workflow

15

Thank you. Everyone. Just completed my first automation successfully. Im about to do a more advanced test run before i build a fully automated marketing campaign, designed to gather intel on all important concepts, generate content and post it, analyze repeat, and repeat until traffic is generated to a certain point then it prompts me to plug in a sales site that it will almost fully operate on its own. Product selection the whole nine yards. I will share the automation to this community once it is fully operational. I will start a new thread if i need help along the way.