Hey everyone,
I’m having a tough time getting Google Sheets to work with my N8N setup on localhost. I’ve been trying for hours but no luck so far. Has anyone else run into this issue before?
I’ve double-checked my credentials and followed the setup guide, but something’s not clicking. When I try to connect, I keep getting an error message. It’s driving me crazy!
If anyone has some tips or tricks for troubleshooting this connection problem, I’d really appreciate it. Maybe there’s a step I’m missing or a common pitfall?
Thanks in advance for any help you can offer!
I’ve been there, John. One thing that saved me when I was banging my head against the wall with this exact issue was realizing I needed to enable the Google Sheets API in the Google Cloud Console. It’s easy to overlook, but crucial. Also, make sure your N8N instance is running on the default port 5678, or if you’ve changed it, update your redirect URI accordingly. And don’t forget to check your system’s date and time settings - mismatched times can cause authentication failures. If all else fails, try setting up a new Google Cloud project from scratch. Sometimes starting fresh is the quickest way to success with these finicky integrations.
hey john, i had this problem too. make sure ur using the right google account and check ur firewall settings. sometimes it blocks the connection. also, try using a different browser. worked for me when chrome was being stubborn. good luck!
I encountered a similar issue when setting up Google Sheets with my local N8N instance. The problem was related to OAuth2 redirect URIs. Make sure you’ve added ‘http://localhost:5678/rest/oauth2-credential/callback’ to the authorized redirect URIs in your Google Cloud Console project. Also, double-check that your OAuth consent screen is properly configured and published. If you’re still stuck, try clearing your browser cache and restarting N8N. Sometimes, a fresh start can resolve pesky connection issues. Hope this helps you get things working!