Error while Connecting Google sheets with n8n

[swapreneur]

Describe the problem/error/question

I am getting “This site can’t be reached” Error while connecting Google Sheets with n8n. I have added oAuth test users email to cloud and added localhost callback URL on cloud too. Still I am facing an issue. I have tried this with 2 different google cloud Accounts but still facing same.
In addition I have done :

1. Disabled Firewall for Private + Public
2. Proxy settings were disabled
3. Tried to login with different browser (As I am using brave browser)
   All together, My assumptions are localhost URL is different then OAuth Redirect URL
   Localhost URL : http://localhost:5680/ & OAuth Redirect URL : localhost:5678
   This is because I followed one youtube video on how to connect docker with n8n their they’ve changed port (Screenshot attached)

PLEASE HELP ME TO RESOLVE THIS ISSUE.

Thanks in advanced

What is the error message (if any)?

Please share your workflow

{
“nodes”: [
{
“parameters”: {},
“name”: “Trigger Every 6 Hours”,
“type”: “n8n-nodes-base.cron”,
“typeVersion”: 1,
“position”: [
-120,
100
],
“id”: “910c2b91-60e8-4544-aae0-4f770f051c05”
},
{
“parameters”: {
“url”: “Husky Tool Chest for sale | eBay”,
“responseFormat”: “string”,
“options”: {}
},
“name”: “Scrape eBay Page”,
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 1,
“position”: [
80,
100
],
“id”: “f4f51e05-3828-4d2e-9c3e-7137103b00d1”
},
{
“parameters”: {
“functionCode”: “// Extract and clean data from eBay HTML response\n// You’ll replace this with cheerio/css-selector parsing\nreturn [\n { json: { title: ‘Husky Tool Chest 52"’, ebayUrl: ‘https://ebay.com/itm/123’, priceEbay: 349.99, sold: 12, seller: ‘toolsupply’ } },\n { json: { title: ‘Husky Rolling Cabinet 41"’, ebayUrl: ‘https://ebay.com/itm/456’, priceEbay: 279.99, sold: 5, seller: ‘homehardware’ } }\n];”
},
“name”: “Parse eBay Listings”,
“type”: “n8n-nodes-base.function”,
“typeVersion”: 1,
“position”: [
280,
100
],
“id”: “95d8314a-6518-4153-9128-8ebcc9d8a6fc”
},
{
“parameters”: {
“sheetId”: “your-google-sheet-id-here”,
“range”: “eBay-HD Product Tracker!A2”,
“options”: {}
},
“name”: “Save to Google Sheet”,
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 2,
“position”: [
480,
100
],
“id”: “8d874b0e-3641-41f1-b123-7243aa9ccc83”,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “V2DQK0H9EnxWnXnd”,
“name”: “Google Sheets account”
}
}
}
],
“connections”: {
“Trigger Every 6 Hours”: {
“main”: [
[
{
“node”: “Scrape eBay Page”,
“type”: “main”,
“index”: 0
}
]
]
},
“Scrape eBay Page”: {
“main”: [
[
{
“node”: “Parse eBay Listings”,
“type”: “main”,
“index”: 0
}
]
]
},
“Parse eBay Listings”: {
“main”: [
[
{
“node”: “Save to Google Sheet”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “97b6815fe1622b93e7aef1271af35591b5a89a908c0bc142fd8cda2dc7cec12b”
}
}

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Problem in node ‘Save to Google Sheet‘

Unable to sign without access token

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:

[cutecatcode]

Hi @swapreneur, you cannot using localhost for connecting with Google Sheets.
You can do port forwarding using ngrok if you want to make your n8n can be connected to the Google Sheets

[swapreneur]

@cutecatcode Actually, I have seen bunch of YouTube video where people are linking google accounts to n8n using localhost URLs. how is that possible ?

[cutecatcode]

they’re using ngrok maybe, cause there’s no possible way you can link your google account with localhost actually