Hi, I’m experiencing a problem where a node send me an “undefined” error but whenever I refresh the page the previous node seem to trigger correctly.
Before executing the https request node, it shows green and with data. When I try to execute it turns red.
</>
{
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “2585abe1efb938917d28de49b9d3e9c5a474780662015cadd3f33854df4f952a”
},
“nodes”: [
{
“parameters”: {
“rule”: {
“interval”: [
{
“triggerAtHour”: 8
}
]
}
},
“id”: “f2ece678-3d15-4290-95b6-88bcb037c76e”,
“name”: “Daily Client Stats Scheduler”,
“type”: “n8n-nodes-base.scheduleTrigger”,
“typeVersion”: 1,
“position”: [
40,
660
]
},
{
“parameters”: {
“resource”: “boardItem”,
“operation”: “getByColumnValue”,
“boardId”: “4347525293”,
“columnId”: “status”,
“columnValue”: “Active”,
“returnAll”: true
},
“id”: “c9c46e71-7d55-460d-a17a-195be302545f”,
“name”: “Get monday item | Daily Client Stats”,
“type”: “n8n-nodes-base.mondayCom”,
“typeVersion”: 1,
“position”: [
260,
660
],
“credentials”: {
“mondayComApi”: {
“id”: “2”,
“name”: “Monday.com account”
}
}
},
{
“parameters”: {
“content”: "Monday dashboard stats ",
“height”: 279.83697234352246,
“width”: 969.2518195050947
},
“id”: “e80f3b58-c8f6-4ec8-a754-326fc95de37d”,
“name”: “Sticky Note”,
“type”: “n8n-nodes-base.stickyNote”,
“typeVersion”: 1,
“position”: [
500,
600
]
},
{
“parameters”: {
“method”: “POST”,
“url”: “https://api.monday.com/v2”,
“authentication”: “predefinedCredentialType”,
“nodeCredentialType”: “mondayComApi”,
“sendBody”: true,
“specifyBody”: “json”,
“jsonBody”: “={\n "query": "mutation($column_values: JSON) { create_item (board_id: 6585490956, group_id: \"{{ $(‘Get monday item | Daily Client Stats’).item.json["column_values"][25]["text"] }}\", item_name: \"{{ $(‘Get todays row FB Sheets stats | Google Sheets’).item.json[‘Date’] }}\", column_values: $column_values) {id name } }",\n "variables": {\n "column_values": "{\"date4\":{\"date\":\"{{ \n $(‘Get todays row FB Sheets stats | Google Sheets’).item.json[‘Date’].split(‘.’).reverse().join(‘-’)\n}}\"}, \"numbers__1\":\"{{ $(‘Get todays row FB Sheets stats | Google Sheets’).item.json["Impressions"] }}\", \"numbers5__1\":\"{{ $(‘Get todays row FB Sheets stats | Google Sheets’).item.json["Frequency"] }}\", \"dup__of_frequency__1\":\"{{ $(‘Get todays row FB Sheets stats | Google Sheets’).item.json["Amount spent"] }}\", \"numbers8__1\":\"{{ $(‘Get todays row FB Sheets stats | Google Sheets’).item.json["Unique link clicks"] }}\", \"numbers53__1\":\"{{ $(‘Get todays row FB Sheets stats | Google Sheets’).item.json["CPM"] }}\", \"numbers6__1\":\"$(‘Get todays row FB Sheets stats | Google Sheets’).item.json["CPC (link)"]\", \"numbers2__1\":\"$(‘Get todays row FB Sheets stats | Google Sheets’).item.json["Links CTR"]\", \"numbers4__1\":\"{{ $(‘FB Get 1st row Sheets stats | Google Sheets1’).item.json["Yesterday leads"] || 0 }}\"}"\n }\n}\n”,
“options”: {}
},
“id”: “2cacde96-c0d3-42ef-9c2d-acd3324ea6c9”,
“name”: “Update stats | Monday.com1”,
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4,
“position”: [
1280,
660
],
“credentials”: {
“mondayComApi”: {
“id”: “2”,
“name”: “Monday.com account”
}
}
},
{
“parameters”: {
“batchSize”: 1,
“options”: {}
},
“id”: “fead6bed-bcc2-4bfd-b88f-7dcd5468e79c”,
“name”: “Batches for Discord”,
“type”: “n8n-nodes-base.splitInBatches”,
“typeVersion”: 2,
“position”: [
580,
660
]
},
{
“parameters”: {
“documentId”: {
“__rl”: true,
“value”: “1jf80OsnLIppDsiFq17jOZCaZkUuF2FG0KuWVJxvnoiI”,
“mode”: “list”,
“cachedResultName”: “Clients FBads Stats”,
“cachedResultUrl”: “Clients FBads Stats | Byggvekst - Google Tabellen”
},
“sheetName”: {
“__rl”: true,
“value”: “={{ $(‘Batches for Discord’).item.json["column_values"][21]["text"] }}”,
“mode”: “id”
},
“filtersUI”: {
“values”: [
{
“lookupColumn”: “=Date”,
“lookupValue”: “={{ new Date(new Date().setDate(new Date().getDate() - 1)).toLocaleDateString(‘no-NO’, { day: ‘2-digit’, month: ‘2-digit’, year: ‘numeric’ }) }}”
}
]
},
“options”: {
“dataLocationOnSheet”: {
“values”: {
“rangeDefinition”: “specifyRangeA1”,
“range”: “A:AB”
}
},
“outputFormatting”: {
“values”: {
“general”: “UNFORMATTED_VALUE”,
“date”: “FORMATTED_STRING”
}
}
}
},
“id”: “6e2c1b0f-ef7e-4312-b69c-1f81d27d1585”,
“name”: “Get todays row FB Sheets stats | Google Sheets”,
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 3,
“position”: [
800,
660
],
“alwaysOutputData”: true,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “1”,
“name”: “Yorads Google API”
}
},
“onError”: “continueErrorOutput”
},
{
“parameters”: {
“documentId”: {
“__rl”: true,
“value”: “1jf80OsnLIppDsiFq17jOZCaZkUuF2FG0KuWVJxvnoiI”,
“mode”: “list”,
“cachedResultName”: “Clients FBads Stats”,
“cachedResultUrl”: “Clients FBads Stats | Byggvekst - Google Tabellen”
},
“sheetName”: {
“__rl”: true,
“value”: “={{ $(‘Batches for Discord’).item.json["column_values"][21]["text"] }}”,
“mode”: “id”
},
“options”: {
“dataLocationOnSheet”: {
“values”: {
“rangeDefinition”: “specifyRangeA1”,
“range”: “AB1:AB2”
}
},
“outputFormatting”: {
“values”: {
“general”: “UNFORMATTED_VALUE”,
“date”: “FORMATTED_STRING”
}
}
}
},
“id”: “57986350-21c2-4bbf-919a-d38c01ec7995”,
“name”: “FB Get 1st row Sheets stats | Google Sheets1”,
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 3,
“position”: [
1040,
660
],
“alwaysOutputData”: true,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “1”,
“name”: “Yorads Google API”
}
},
“onError”: “continueErrorOutput”
}
],
“connections”: {
“Daily Client Stats Scheduler”: {
“main”: [
[
{
“node”: “Get monday item | Daily Client Stats”,
“type”: “main”,
“index”: 0
}
]
]
},
“Get monday item | Daily Client Stats”: {
“main”: [
[
{
“node”: “Batches for Discord”,
“type”: “main”,
“index”: 0
}
]
]
},
“Update stats | Monday.com1”: {
“main”: [
[
{
“node”: “Batches for Discord”,
“type”: “main”,
“index”: 0
}
]
]
},
“Batches for Discord”: {
“main”: [
[
{
“node”: “Get todays row FB Sheets stats | Google Sheets”,
“type”: “main”,
“index”: 0
}
]
]
},
“Get todays row FB Sheets stats | Google Sheets”: {
“main”: [
[
{
“node”: “FB Get 1st row Sheets stats | Google Sheets1”,
“type”: “main”,
“index”: 0
}
]
]
},
“FB Get 1st row Sheets stats | Google Sheets1”: {
“main”: [
[
{
“node”: “Update stats | Monday.com1”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {}
}
</>