I can’t connect my google sheets credentials to N8N. I have followed all steps but every time i try to log in to connect the credential it gives an error. I’m now trying to get the document added throuogh URL but in column im getting the error " * There was a problem loading the parameter options from server: “Unable to sign without access token”.
I have my sheet open to anyone with a link, I have Google Sheets, and Google Drive connected to N8N and dont know how to continue.
Thanks in advanced!
What is the error message (if any)?
{
“nodes”: [
{
“parameters”: {
“documentId”: {
“__rl”: true,
“value”: “TC Email List - Google Sheets”,
“mode”: “url”
},
“sheetName”: {
“__rl”: true,
“value”: “Sheet1”,
“mode”: “name”
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.5,
“position”: [
660,
0
],
“id”: “496d0299-6aea-4c7d-b26f-e6f5e888e271”,
“name”: “Google Sheets”,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “5fdcR8oOBaxMOzjD”,
“name”: “Google Sheets account”
}
}
}
],
“connections”: {},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “db5617f297745af7690c88efe0d95e83365a5829c66c9a831feb3fe32e9f73f2”
}
}
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:**Preformatted text