n8n - 💡(How to fix) Fix Credentialing error causing workflow to run twice [1 comments, 2 participants]

<!-- Please follow the template below. Skip the questions that are not relevant to you. -->

Describe the problem/error/question

When running my automated script, I receive an error message on both the Slack and google sheets nodes stating the below, but the automation finishes. For some reason (likely because of this triggered error) the automation runs twice.

What is the error message (if any)?

"Credentials with name Google Sheets account 30 do not exist for Google Sheets OAuth2 API. You can create credentials with the exact name and then they get auto-selected on refresh"

{ "nodes": [ { "parameters": { "select": "channel", "channelId": { "__rl": true, "value": "=C02NJQGB8N6", "mode": "id" }, "text": "={{$json["MESSAGE"]}}", "otherOptions": { "includeLinkToWorkflow": false } }, "type": "n8n-nodes-base.slack", "typeVersion": 2.4, "position": [ 608, -112 ], "id": "c6308f64-caaa-4dc3-99c2-5c1b9a72ceee", "name": "Send a message", "webhookId": "7180693c-d858-4db1-94c9-1242c5a767f6", "credentials": {} } ], "connections": {}, "pinData": {}, "meta": { "instanceId": "4da11cc2e9914af64b45ca76bdbfb358991b8218f5650fc4e047bd3284630461" } }

Please share your workflow/screenshots/recording

(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.) ⚠️ WARNING ⚠️ If you have sensitive data in your workflow (like API keys), please remove it before sharing. `{ "name": "DEIBA Holiday Workflow", "nodes": [ { "parameters": { "rule": { "interval": [ { "triggerAtHour": 6 } ] } }, "type": "n8n-nodes-base.scheduleTrigger", "typeVersion": 1.3, "position": [ 0, 0 ], "id": "3feca5c6-ce1a-46ae-abe2-1bc13d77ba7f", "name": "Schedule Trigger", "alwaysOutputData": true }, { "parameters": { "documentId": { "__rl": true, "value": "https://docs.google.com/spreadsheets/d/1RCUitY0zfOwsJEnyUjCo9uTY34QpOjC9WkntcXOXHnM/edit?usp=sharing", "mode": "url" }, "sheetName": { "__rl": true, "value": "gid=0", "mode": "list", "cachedResultName": "Sheet1", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RCUitY0zfOwsJEnyUjCo9uTY34QpOjC9WkntcXOXHnM/edit#gid=0" }, "filtersUI": { "values": [ { "lookupColumn": "DATE", "lookupValue": "={{ $now.toFormat('M/d/yyyy') }}" } ] }, "options": { "dataLocationOnSheet": { "values": { "rangeDefinition": "detectAutomatically", "readRowsUntil": "firstEmptyRow" } } } }, "type": "n8n-nodes-base.googleSheets", "typeVersion": 4.7, "position": [ 208, 0 ], "id": "032dceeb-6326-4596-8a1b-936cf8ad12cd", "name": "Get row(s) in sheet", "alwaysOutputData": false, "credentials": { "googleSheetsOAuth2Api": { "id": "41yg9Q98Cgaciznb", "name": "Google Sheets account 30" } } }, { "parameters": { "jsCode": "const today = new Date().toLocaleDateString();\n\nreturn $input.all()\n .filter(item => {\n const messageDate = new Date(item.json.DATE).toLocaleDateString();\n return messageDate === today && !item.json.STATUS;\n })\n .map(item => ({\n json: {\n DATE: item.json.DATE,\n MESSAGE: item.json.MESSAGE,\n CHANNEL: item.json.CHANNEL?.startsWith('#') ? item.json.CHANNEL : '#' + item.json.CHANNEL,\n STATUS: item.json.STATUS,\n row_number: item.json.row_number\n }\n }));\n\n" }, "type": "n8n-nodes-base.code", "typeVersion": 2, "position": [ 416, 0 ], "id": "65c9a648-587b-4a1f-83b1-5382706e2c8a", "name": "Code in JavaScript", "alwaysOutputData": false }, { "parameters": { "select": "channel", "channelId": { "__rl": true, "value": "=C02NJQGB8N6", "mode": "id" }, "text": "={{$json["MESSAGE"]}}", "otherOptions": { "includeLinkToWorkflow": false } }, "type": "n8n-nodes-base.slack", "typeVersion": 2.4, "position": [ 608, -112 ], "id": "c6308f64-caaa-4dc3-99c2-5c1b9a72ceee", "name": "Send a message", "webhookId": "7180693c-d858-4db1-94c9-1242c5a767f6", "credentials": { "slackApi": { "id": "v6by8RBmuz3DZel1", "name": "DEIBA bot" } } }, { "parameters": { "operation": "update", "documentId": { "__rl": true, "value": "1RCUitY0zfOwsJEnyUjCo9uTY34QpOjC9WkntcXOXHnM", "mode": "list", "cachedResultName": "DEIBA Holiday Automation", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RCUitY0zfOwsJEnyUjCo9uTY34QpOjC9WkntcXOXHnM/edit?usp=drivesdk" }, "sheetName": { "__rl": true, "value": "gid=0", "mode": "list", "cachedResultName": "Sheet1", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RCUitY0zfOwsJEnyUjCo9uTY34QpOjC9WkntcXOXHnM/edit#gid=0" }, "columns": { "mappingMode": "defineBelow", "value": { "row_number": "={{$json.row_number}}", "STATUS": "TRUE" }, "matchingColumns": [ "row_number" ], "schema": [ { "id": "DATE", "displayName": "DATE", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "MESSAGE", "displayName": "MESSAGE", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "CHANNEL", "displayName": "CHANNEL", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "STATUS", "displayName": "STATUS", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "row_number", "displayName": "row_number", "required": false, "defaultMatch": false, "display": true, "type": "number", "canBeUsedToMatch": true, "readOnly": true, "removed": false } ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {} }, "type": "n8n-nodes-base.googleSheets", "typeVersion": 4.7, "position": [ 608, 96 ], "id": "5d4c3ecf-b8a5-4db8-b9fb-4a2836364b7e", "name": "Update row in sheet", "credentials": { "googleSheetsOAuth2Api": { "id": "41yg9Q98Cgaciznb", "name": "Google Sheets account 30" } } } ], "pinData": { "Schedule Trigger": [ { "json": { "timestamp": "2026-05-05T04:00:57.007-04:00", "Readable date": "May 5th 2026, 4:00:57 am", "Readable time": "4:00:57 am", "Day of week": "Tuesday", "Year": "2026", "Month": "May", "Day of month": "05", "Hour": "04", "Minute": "00", "Second": "57", "Timezone": "America/New_York (UTC-04:00)" }, "pairedItem": { "item": 0 } } ] }, "connections": { "Schedule Trigger": { "main": [ [ { "node": "Get row(s) in sheet", "type": "main", "index": 0 } ] ] }, "Get row(s) in sheet": { "main": [ [ { "node": "Code in JavaScript", "type": "main", "index": 0 } ] ] }, "Code in JavaScript": { "main": [ [ { "node": "Send a message", "type": "main", "index": 0 }, { "node": "Update row in sheet", "type": "main", "index": 0 } ] ] } }, "active": true, "settings": { "executionOrder": "v1", "availableInMCP": false }, "versionId": "ec895aa3-69e2-4d92-a4e2-874e7b6cda53", "meta": { "templateCredsSetupCompleted": true, "instanceId": "4da11cc2e9914af64b45ca76bdbfb358991b8218f5650fc4e047bd3284630461" }, "id": "zLxKvmKR3wWcXZru", "tags": [] }

Share the output returned by the last node

<!-- If you need help with data transformations, please also share your expected output. -->

"type": "rich_text_section",

"elements": [

{

"type": "text",

"text": "The DEIBA committee would like to recognize Cinco de Mayo "

},

{

"type": "emoji",

"name": "flag-mx",

"unicode": "1f1f2-1f1fd"

},

{

"type": "text",

"text": "\n\nCinco de Mayo commemorates Mexico’s victory at the Battle of Puebla in 1862. While a relatively minor holiday in Mexico, it has become a celebration of Mexican culture and heritage in many communities.\n\nThe day offers an opportunity to appreciate the history and cultural contributions of Mexican and Mexican American communities.\n\n"

},

{

"type": "emoji",

"name": "speech_balloon",

"unicode": "1f4ac"

},

{

"type": "text",

"text": " Ways to engage today:\n• Learn about the historical origins of Cinco de Mayo\n• Explore Mexican culture through food, music, or art\n• Celebrate the diversity of Latin American traditions"

}

]

}

]

}

]

},

"message_timestamp": "1777968058.111239"

} ]

Debug info

core

• n8nVersion: 2.9.0
• platform: docker (self-hosted)
• nodeJsVersion: 24.13.1
• nodeEnv: production
• database: postgres
• executionMode: regular
• concurrency: -1
• license: enterprise (production)

storage

• success: all
• error: all
• progress: false
• manual: true
• binaryMode: filesystem

pruning

• enabled: true
• maxAge: 336 hours
• maxCount: 10000 executions

client

• userAgent: mozilla/5.0 (windows nt 10.0; win64; x64) applewebkit/537.36 (khtml, like gecko) chrome/147.0.0.0 safari/537.36
• isTouchDevice: false

Generated at: 2026-05-05T12:59:38.508Z}