hey! I have a merge node to merge two google sheets. but for some reason it cannot recognize one expression from input 2 only from input 1 I switched between them and it didn’t recognize the other again.
as you can see in the screenshot it doesn’t read any properties of the sheets that was input 2 (marked with circle is the expression it doesnt recognize)
Hello there,
Can you please provide an example workflow where you are experiencing this issue as JSON?
{
“name”: “טסט מחייה לידים”,
“nodes”: [
{
“parameters”: {},
“type”: “n8n-nodes-base.manualTrigger”,
“typeVersion”: 1,
“position”: [
0,
0
],
“id”: “9374aa8b-9c7c-4d8d-9c83-8fcf95ae7f98”,
“name”: “When clicking ‘Execute workflow’”
},
{
“parameters”: {
“documentId”: {
“__rl”: true,
“value”: “1GsJK5nsOvOPT3vuNVLdBbXf5l1fFOrR4g2mQHcQ2UYo”,
“mode”: “list”,
“cachedResultName”: “טסט מחייה לידים”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/1GsJK5nsOvOPT3vuNVLdBbXf5l1fFOrR4g2mQHcQ2UYo/edit?usp=drivesdk”
},
“sheetName”: {
“__rl”: true,
“value”: “gid=0”,
“mode”: “list”,
“cachedResultName”: “costumers”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/1GsJK5nsOvOPT3vuNVLdBbXf5l1fFOrR4g2mQHcQ2UYo/edit#gid=0”
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.6,
“position”: [
220,
0
],
“id”: “77647c44-5509-4b99-bead-daa58f87e618”,
“name”: “לידים”,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “Bbch8QCni9khTWKR”,
“name”: “Google Sheets account”
}
}
},
{
“parameters”: {
“jsCode”: “// items: [{ json: { "כניסה למערכת": "DD/MM/YYYY", … }}, …]\nconst results = ;\nconst msPerDay = 1000 * 60 * 60 * 24;\nconst today = new Date(); // או: new Date()\n\nfor (const item of items) {\n const dateParts = item.json["כניסה למערכת"].split("/"); // ["DD","MM","YYYY"]\n const entryDate = new Date(+dateParts[2], dateParts[1] - 1, +dateParts[0]);\n const diffDays = Math.floor((today - entryDate) / msPerDay);\n\n if (diffDays === 7) {\n results.push({ json: item.json });\n }\n}\n\nreturn results;\n”
},
“type”: “n8n-nodes-base.code”,
“typeVersion”: 2,
“position”: [
460,
-80
],
“id”: “b554455f-4e20-4287-8f64-7e07d4b0b22d”,
“name”: “מסנן לפי שבוע”
},
{
“parameters”: {
“sendTo”: “={{ $json[‘אימייל’] }}”,
“subject”: “={{ $json[‘עמודה 1’] }}”,
“message”: “={{ $json.col_2 }}”,
“options”: {
“appendAttribution”: false
}
},
“type”: “n8n-nodes-base.gmail”,
“typeVersion”: 2.1,
“position”: [
960,
-240
],
“id”: “531a80af-4372-4143-8529-f0861cb38709”,
“name”: “שולח מייל”,
“webhookId”: “cb8e787a-a26d-4286-87f4-89ad726cbf00”,
“credentials”: {
“gmailOAuth2”: {
“id”: “01P0B5gnivuwZO4a”,
“name”: “Gmail account”
}
}
},
{
“parameters”: {
“documentId”: {
“__rl”: true,
“value”: “18PdPKmt0x9Nw0xXUBY6_PZKO-2qlRTz1Hx0VkmDZSq8”,
“mode”: “list”,
“cachedResultName”: “תסריטים”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/18PdPKmt0x9Nw0xXUBY6_PZKO-2qlRTz1Hx0VkmDZSq8/edit?usp=drivesdk”
},
“sheetName”: {
“__rl”: true,
“value”: “gid=0”,
“mode”: “list”,
“cachedResultName”: “גיליון1”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/18PdPKmt0x9Nw0xXUBY6_PZKO-2qlRTz1Hx0VkmDZSq8/edit#gid=0”
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.6,
“position”: [
460,
-320
],
“id”: “f16b0022-993b-4706-9ed9-33742e5d68d8”,
“name”: “תסריטים”,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “Bbch8QCni9khTWKR”,
“name”: “Google Sheets account”
}
}
},
{
“parameters”: {},
“type”: “n8n-nodes-base.merge”,
“typeVersion”: 3.2,
“position”: [
700,
-240
],
“id”: “941bd0bb-dddb-4c28-bdf3-ee52cc7297bc”,
“name”: “Merge”
}
],
“pinData”: {},
“connections”: {
“When clicking ‘Execute workflow’”: {
“main”: [
[
{
“node”: “לידים”,
“type”: “main”,
“index”: 0
},
{
“node”: “תסריטים”,
“type”: “main”,
“index”: 0
}
]
]
},
“לידים”: {
“main”: [
[
{
“node”: “מסנן לפי שבוע”,
“type”: “main”,
“index”: 0
}
]
]
},
“מסנן לפי שבוע”: {
“main”: [
[
{
“node”: “Merge”,
“type”: “main”,
“index”: 1
}
]
]
},
“שולח מייל”: {
“main”: [
]
},
“תסריטים”: {
“main”: [
[
{
“node”: “Merge”,
“type”: “main”,
“index”: 0
}
]
]
},
“Merge”: {
“main”: [
[
{
“node”: “שולח מייל”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“active”: false,
“settings”: {
“executionOrder”: “v1”
},
“versionId”: “63de36c5-cf8f-4e3b-a009-b7fcea7b0495”,
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “291e978387bfbcbf138a3ffe563a56dd940e9578522a90831124748d117ca431”
},
“id”: “Si9TyUMmb5GvT1Wa”,
“tags”:
}
did you get the json?
Unfortunately no, please post it here. To do so, with the workflow open, click the three dots in the top right corner, then “Download”. After that, create a reply here: click on the “</>” icon and paste the contents of the downloaded file
