thanks everyone for your helps on this forum
please I self hosted n8n on hostinger and have tried many times to connect n8n to google sheet but it keeps giving me error. please how do I fix this permanently
Refer to the Google Credentials Documentation:
You have to either add the email address of the Google account as tester to your app in the cloud console, set the mode to internal, or go through the verification process.
Did you setup this?
I believe this is missing
You must also setup Google Cloud Project as well as Google Sheets API
faced the same issue , this should solve, you can add your email to the list of testers for the app: go to the Audience page and add the email you’re signing in with to the list of Test users.