Multiple issues: Google Sheets 429 Rate Limit, OAuth Client Deleted, and "reading disabled" error

Questions
1

{
“nodes”: [
{
“parameters”: {
“rule”: {
“interval”: [
{
“field”: “hours”
}
]
}
},
“type”: “n8n-nodes-base.scheduleTrigger”,
“typeVersion”: 1.3,
“position”: [
-832,
-32
],
“id”: “05bcbd08-b458-49f5-a8c8-3d18684d1370”,
“name”: “Schedule Trigger”
},
{
“parameters”: {
“url”: “https://www.ewdifh.com”,
“options”: {
“batching”: {
“batch”: {}
}
}
},
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4.3,
“position”: [
-624,
-32
],
“id”: “c76dafc4-f76d-47ea-8c46-415dbe0dc894”,
“name”: “HTTP Request”
},
{
“parameters”: {
“operation”: “extractHtmlContent”,
“extractionValues”: {
“values”: [
{
“key”: “job_title”,
“cssSelector”: “h3”,
“returnArray”: true
},
{
“key”: “job_link”,
“cssSelector”: “a”,
“returnValue”: “attribute”,
“attribute”: “href”,
“returnArray”: true
}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.html”,
“typeVersion”: 1.2,
“position”: [
-384,
-32
],
“id”: “72e0b265-8141-4aba-99cc-a129d9c4ee08”,
“name”: “HTML”
},
{
“parameters”: {
“fieldToSplitOut”: “job_title, job_link”,
“include”: “allOtherFields”,
“options”: {}
},
“type”: “n8n-nodes-base.splitOut”,
“typeVersion”: 1,
“position”: [
-160,
-32
],
“id”: “2f5fdd50-6394-4c4d-92b5-4db13a2ed61b”,
“name”: “Split Out”
},
{
“parameters”: {
“method”: “POST”,
“url”: “https://www.googleapis.com/blogger/v3/blogs/5965247702151556793/posts/”,
“authentication”: “genericCredentialType”,
“genericAuthType”: “oAuth2Api”,
“options”: {
“batching”: {
“batch”: {
“batchSize”: 1,
“batchInterval”: 5000
}
}
}
},
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4.3,
“position”: [
736,
-32
],
“id”: “86e7d0c3-7c63-43f7-bed0-93e982b8cfb9”,
“name”: “HTTP Request1”,
“credentials”: {
“oAuth2Api”: {
“id”: “s4sIduytfum5cYF6”,
“name”: “Unnamed credential”
}
}
},
{
“parameters”: {
“conditions”: {
“options”: {
“caseSensitive”: true,
“leftValue”: “”,
“typeValidation”: “strict”,
“version”: 3
},
“conditions”: [
{
“id”: “757f787b-fbf6-44a2-ab6f-61bf9e365f50”,
“leftValue”: “={{ $node["Create spreadsheet"].json["job_title"] }}”,
“rightValue”: “”,
“operator”: {
“type”: “string”,
“operation”: “empty”,
“singleValue”: true
}
}
],
“combinator”: “and”
},
“options”: {}
},
“type”: “n8n-nodes-base.filter”,
“typeVersion”: 2.3,
“position”: [
512,
-32
],
“id”: “b16d0dc5-b206-4e0e-9987-2da53e1ca30a”,
“name”: “Filter”
},
{
“parameters”: {
“amount”: 1,
“unit”: “minutes”
},
“type”: “n8n-nodes-base.wait”,
“typeVersion”: 1.1,
“position”: [
64,
-32
],
“id”: “13a1a422-bc9d-4a13-8689-bcf154902155”,
“name”: “Wait”,
“webhookId”: “ebafaa81-f160-44f0-9731-4eb9d6d6e711”
},
{
“parameters”: {
“operation”: “append”,
“documentId”: {
“__rl”: true,
“value”: “1Zxofmfy423wxtAar98nxszvHBldlJ8d4xGo5aebYkdo”,
“mode”: “list”,
“cachedResultName”: “ملف اكسل الوظائف”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/1Zxofmfy423wxtAar98nxszvHBldlJ8d4xGo5aebYkdo/edit?usp=drivesdk”
},
“sheetName”: {
“__rl”: true,
“mode”: “id”,
“value”: “gid=0”
},
“columns”: {
“mappingMode”: “defineBelow”,
“value”: {
“job_title”: “={{ $(‘HTML’).item.json.job_title }}”
},
“matchingColumns”: [
“job_title”
],
“schema”: [
{
“id”: “job_title”,
“displayName”: “job_title”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
}
],
“attemptToConvertTypes”: false,
“convertFieldsToString”: false
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.7,
“position”: [
960,
-32
],
“id”: “c5b9ea6a-3156-4a95-9b47-98ae317ffff8”,
“name”: “Append row in sheet”,
“alwaysOutputData”: true,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “2zt45EpuplLsj3z0”,
“name”: “Google Sheets account”
}
}
},
{
“parameters”: {
“resource”: “spreadsheet”,
“title”: “={{ $json.job_link }}”,
“options”: {}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.7,
“position”: [
288,
-32
],
“id”: “c03853be-1460-40a6-bf99-1bd532623306”,
“name”: “Create spreadsheet”,
“alwaysOutputData”: true,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “2zt45EpuplLsj3z0”,
“name”: “Google Sheets account”
}
},
“onError”: “continueRegularOutput”
}
],
“connections”: {
“Schedule Trigger”: {
“main”: [
[
{
“node”: “HTTP Request”,
“type”: “main”,
“index”: 0
}
]
]
},
“HTTP Request”: {
“main”: [
[
{
“node”: “HTML”,
“type”: “main”,
“index”: 0
}
]
]
},
“HTML”: {
“main”: [
[
{
“node”: “Split Out”,
“type”: “main”,
“index”: 0
}
]
]
},
“Split Out”: {
“main”: [
[
{
“node”: “Wait”,
“type”: “main”,
“index”: 0
}
]
]
},
“HTTP Request1”: {
“main”: [
[
{
“node”: “Append row in sheet”,
“type”: “main”,
“index”: 0
}
]
]
},
“Filter”: {
“main”: [
[
{
“node”: “HTTP Request1”,
“type”: “main”,
“index”: 0
}
]
]
},
“Wait”: {
“main”: [
[
{
“node”: “Create spreadsheet”,
“type”: “main”,
“index”: 0
}
]
]
},
“Create spreadsheet”: {
“main”: [
[
{
“node”: “Filter”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “74940c1363c33c02b560380441c269fc1930e4c301b50999865560d299a63155”
}
}

2

Hi @Raed

You are facing multiple independent issues, all expected based on Google APIs behavior and workflow design.

1) Google Sheets 429 (Rate Limit Exceeded)
Your workflow creates spreadsheets and appends rows inside a loop (Split Out). This results in too many Google Sheets API calls in a short time, triggering quota limits.

Fix:

  • Avoid creating a spreadsheet per item
  • Batch rows and append them in fewer requests
  • Increase delays (Wait node) or use batching properly

2) OAuth Client Deleted / Invalid Credentials
This happens when the OAuth client was deleted or changed in Google Cloud, but the credential still exists in n8n.

Fix:

  • Recreate the OAuth Client in Google Cloud or
  • Reconnect / recreate the Google Sheets credential in n8n

3) “Reading disabled” / Permission errors
This indicates the authenticated Google account does not have access to the spreadsheet or Drive resource.

Fix:

  • Ensure the spreadsheet is owned by or shared with the same Google account used in the credential
  • Verify Google Drive + Google Sheets APIs are enabled

Key takeaway

  • 429 errors = too many requests
  • OAuth errors = deleted or mismatched Google Cloud credentials
  • “Reading disabled” = missing permissions

All issues are configuration and flow-design related, not n8n bugs.