• n8n version: 1.72.1 (generates the message “(node:9664) [DEP0040] DeprecationWarning: The punycode module is deprecated. Please use a userland alternative instead” when launching)
• Database (default: SQLite): N/A? (I have no idea - NONE of the tutorials I’ve seen over the last week have said anything about a Database being required.)
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app): npm installed to desktop so I could access the tunnel feature)
• Operating system: Windows 11
Hi everyone,
I’m new to the board - but I’ve been lurking for the last week or so trying to see if I can find a solution for my connection issues before making a nuisance of myself, but unfortunately this seems to be a bit beyond my pay-grade so to speak. 
Just so you have a better understanding of what I’m trying to do any why
A couple of years ago I built a smart garden that would upload data directly to a spreadsheet (using a NodeMCU)/ It worked for a couple of months, until google changed something on their side and the code stopped working. The project was shelved as I had more important things to worry about at the time. Fast Forward 2 years , and I decided it would be a good time to pick up on the project again as something fun to do over the holiday break (Ha ha ha) and started doing research on a better way to get my data uploaded using an Arduino wifi (instead of the NodeMCU) and found out about webhooks, which appear to be the solution I was looking for.
I installed n8n using “npm install n8n -g”, so I could launch it using the --tunnel (from what I understand the tunnel is the only way to connect to a google sheet, correct?).
Once installed I tried following the online docs for OAuth2 (generic) setup until it got to the point where n8n was going to log into google to finish the process. After confirming which account the credentials are for there is a bit of a wait followed by a 504 / Time out message.
For trouble shooting, I tried following the steps from this thread (Tunnel access not working for webhook nodes - #4 by djangelic) as the tunnel problem sounds similar to what I am experiencing; I’ll provide my results on each of the suggestions.
1. Check Logs for Errors
After reading that message thread, n8n was reinstalled using the “verbose log” instructions provided
I can’t find anything with the listed filename of “npm-debug.log” on my machine. (File search of C: Drive found nothing). Is there another way I should be looking for this?
2. Network Configuration
I checked the firewall and node.js was permitted for private networks, but not public.
The Setting was corrected to allow access to both, however the problem continued.
3. Check Tunnel Connection
When I pinged the tunnel service domain (***.hooks.n8n.cloud) using the computer I installed n8n on, I generated these results:
Ping statistics for 188.245.86.69:
- Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),*
Approximate round trip times in milli-seconds: - Minimum = 105ms, Maximum = 107ms, Average = 105ms*
When I tried pinging to tunnel service domain on my phone it could not connect.
When I pinged the IP address with my phone I generated these results:
PING 188.245.86.69 (188.245.86.69)
64 bytes from 188.245.86.69 (188.245.86.69): icmp_seq=1 ttl=47 time=111.0 ms
64 bytes from 188.245.86.69 (188.245.86.69): icmp_seq=2 ttl=47 time=106.0 ms
64 bytes from 188.245.86.69 (188.245.86.69): icmp_seq=3 ttl=47 time=106.0 ms
— ping statistics —
3 packets transmitted, 3 received, 0% packet loss, time 3683ms
rtt min/avg/max/mdev = 106/107/111/3 ms
I keyed the tunnel service domain address into the browser on my phone to see if I could connect to the tunnel that way, and it 504 timed out.
4. Environment Variables and Configuration
I found 2 files named “.env” (below) and both appear to by 0k / empty files when opened with notepad.
“C:\Users\forkl\AppData\Roaming\npm\node_modules\n8n\node_modules\psl.env”
“C:\Users\forkl\AppData\Local\npm-cache_npx\a8a7eec953f1f314\node_modules\psl.env”
5. Test Without Tunnel
Trying to do the final save in n8n without the tunnel generates the message:
Access blocked: authorisation error
The OAuth client was not found.
If you are a developer of this app, see error details.
Error 401: invalid_client
One thought I have had, in closing, is could this timeout be a result of trying to set up the OAuth2 for the sheet without first having the Outh2 for the Drive taken care of? (I see the comment in the n8n set up but none of the other online tutorials I’ve seen reference this step) Is it possible to include all the required APIs in a single request, or should I set up my APIs for Drive, Sheets and Mail individually.
Thank you in advance for any assistance you can provide.
If any further information or clarification is required please let me know.
Stay Groovy!
Cannabal
I really appreciate you taking the time to respond to me. I totally missed the courses, and I will be tearing through the intro course tomorrow with my morning coffee.