After create google sheet credential unable access my file?

[Paul_Yeo]

Hi All

My workflow have a google sheet module , therefore i need to apply for goggle sheet credential.

Upon created the google credential , i am unable to access the google sheet file.

Remark :- I am very sure my google credential procedure is correct . As i good experience in set up credential.

Hoe some one can advise me where go wrong ?
Paul

[mohamed3nan]

Hi @Paul_Yeo, are you sure the GCP app is in production?

Google Gmail credentials error

Because the app’s Publishing status is set to Testing, simply change it to Production. [image] Also, you can ignore the verification alert like the one in my screenshot—no action is needed. If you don’t want to change the status to Production, just re-authenticate (sign in with Google again), and it will work for another week.

Also, did you try reconnecting after that?

[Paul_Yeo]

@mohamed3nan Thank you for your sharing.
i have already set to production.

i also ensure that credential is connected :

Hope you can still provide me more info to trouble shoot.
Thank
Paul

[mohamed3nan]

“Sign in with Google” again and see if the issue still exists

[Paul_Yeo]

@mohamed3nan I have already sign in google sheet.
Still the same , the file not appear.

Paul

[mohamed3nan]

I mean reconnect

[Paul_Yeo]

@mohamed3nan
when i try to re-connect again , i see the below msg , first time i see that :

Now it can see the book price , which is default link , as my google sheet directory does not have such file , and i can access to sheet directory to change to the file i want.

Bow is my workflow , which i download from n8n site :

Paul

[mohamed3nan]

Ok so the issue in http node now, can you show me the error?

[Paul_Yeo]

@mohamed3nan
When i download the workflow from n8n , at first most of the module got error : -

After i click open the module and close the module , i think it is because , the credential is auto turn ( this happen when previously i already setup the credential ) , the error dis-appear.

Now all module no more error , except the google sheet unable to link to my personal sheet file.
I have try to delete the sheet module , and insert the new sheet also the same
Paul

[Paul_Yeo]

Below Just to summarize my issue encount on google sheet credential :-

My issue is when I Create a new Google Sheets credential from scratch, when it come to n8n google sheet module is it unable to access all the file . As i have many google sheet file. See the image below :-

Q: In the Google Cloud Console, confirm that the API for Google Sheets is enabled and that the OAuth consent screen is properly configured.

A: I had already set all to production ( Not in testing mode ) , did for Gmail , Contact , Task , Drive , Sheet.

[email protected],-I eq

Q: Review Google Cloud Permissions:

A: I set permission for google sheet :

I already try to reconnect to google :-

I also able create credentials for google drive , gmail , task , contact all working fine , except sheet I encounter issue :-

[mohamed3nan]

Hi @Paul_Yeo,

Could you please confirm that you’re working with your own sheet and not one shared by others?

To verify this, try creating a new workflow with only a Google Sheet node and attempt to perform any task.

[Paul_Yeo]

@ @mohamed3nan
Thank you very much for your help .
I just create a video to demo to show you how I create a new workflow only google sheet , and how I create google sheet .

Thank

[mohamed3nan]

Hi, did you do this step?

N8n selfhosted on vps with own domain

It looks like you’re almost there! One extra step is to add the required OAuth scopes before clicking “Sign in with Google” Here’s a simple breakdown: First: Enable the needed API (for example, Google Drive): [image] [image] Then: Click here to check which scopes are needed: [image] After that: The “Sign in with Google” window will show the required scopes. You can search for and add each of them: [image] Finally: Continue with the “Sign in with Google” process.

also, please delete the video; you’re sharing very critical keys!
delete the entire project from GCP please!

[Paul_Yeo]

@mohamed3nan
Finally i can view all my file now. Thank you very much .

In conclusion i need to turn on below : -

[mohamed3nan]

You’re welcome!

Please be careful when sharing videos and screenshots next time. You don’t have to share the entire screen, just focus on the important part

[Paul_Yeo]

@mohamed3nan thank you for your advise . I will keep in mind .