here is the code I’m trying to add my email signatures to my emails sending out i can get them to if i copy and past them but the link wont work if there not comply written out vary new to all of this would love some help.
{
“name”: “CAAL”,
“nodes”: [
{
“parameters”: {},
“type”: “n8n-nodes-base.manualTrigger”,
“typeVersion”: 1,
“position”: [
-2900,
-400
],
“id”: “13e01a2c-109d-4be0-83fb-9781f179e72a”,
“name”: “When clicking ‘Execute workflow’”
},
{
“parameters”: {
“resource”: “worksheet”,
“operation”: “readRows”,
“workbook”: {
“__rl”: true,
“value”: “01DNXMIDMJMJHS65DUMBAIBLAZHB2N5OC7”,
“mode”: “list”,
“cachedResultName”: “CCBH_Personalized”,
“cachedResultUrl”: “Sign in to your account”
},
“worksheet”: {
“__rl”: true,
“value”: “{00000000-0001-0000-0000-000000000000}”,
“mode”: “list”,
“cachedResultName”: “Sheet1”,
“cachedResultUrl”: “https://livemissouristate-my.sharepoint.com/personal/sw8526s_login_missouristate_edu/_layouts/15/Doc.aspx?sourcedoc={2F4F6289-7474-4060-80AC-193874DEB85F}&file=CCBH_Personalized.xlsx&action=default&mobileredirect=true&DefaultItemOpen=1&activeCell=Sheet1!A1”
},
“options”: {}
},
“type”: “n8n-nodes-base.microsoftExcel”,
“typeVersion”: 2.1,
“position”: [
-2620,
-460
],
“id”: “0e07de5e-826a-4949-9661-b1b4e9b5a0a4”,
“name”: “Microsoft Excel 3651”,
“credentials”: {
“microsoftExcelOAuth2Api”: {
“id”: “5QxmIvSslpa7PpUo”,
“name”: “Microsoft Excel account 3”
}
}
},
{
“parameters”: {
“batchSize”: “=1”,
“options”: {
“reset”: true
}
},
“type”: “n8n-nodes-base.splitInBatches”,
“typeVersion”: 3,
“position”: [
-2300,
-480
],
“id”: “ed35aa1e-05ca-47be-af9b-1049b4393dc7”,
“name”: “Loop Over Items1”
},
{
“parameters”: {
“assignments”: {
“assignments”: [
{
“id”: “6c793f9a-c455-4fa8-ad00-0b3e0b0cfca9”,
“name”: “Personalized Email”,
“value”: “={{ $json[‘Personalized Email’] }}”,
“type”: “string”
},
{
“id”: “ca9a1f36-8d29-407c-b974-0a457088c50e”,
“name”: “CEO”,
“value”: “={{ $json.CEO }}”,
“type”: “string”
},
{
“id”: “51d510c9-3f1e-4de8-a5a3-2540c6dc0493”,
“name”: "CEO email1 ",
“value”: “={{ $json['CEO email1 '] }}”,
“type”: “string”
}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.set”,
“typeVersion”: 3.4,
“position”: [
-1920,
-60
],
“id”: “d220bf45-0309-400e-9d6e-dffb98b6cc76”,
“name”: “Edit Fields”
},
{
“parameters”: {
“toRecipients”: “={{ $json['CEO email1 '] }}”,
“subject”: "test ",
“bodyContent”: “={{ $json[‘Personalized Email’] }}”,
“additionalFields”: {
“from”: “Sam Wooderson”
}
},
“type”: “n8n-nodes-base.microsoftOutlook”,
“typeVersion”: 2,
“position”: [
-1940,
-520
],
“id”: “bc147084-24a1-4998-bb6d-e5a66c9426ea”,
“name”: “Microsoft Outlook”,
“webhookId”: “9876d7cc-cc1a-4c32-9bb1-330edeedc8bf”,
“credentials”: {
“microsoftOutlookOAuth2Api”: {
“id”: “i3z24wB89Hj79fZk”,
“name”: “Microsoft Outlook account 2”
}
},
“onError”: “continueRegularOutput”
}
],
“pinData”: {},
“connections”: {
“When clicking ‘Execute workflow’”: {
“main”: [
[
{
“node”: “Microsoft Excel 3651”,
“type”: “main”,
“index”: 0
}
]
]
},
“Microsoft Excel 3651”: {
“main”: [
[
{
“node”: “Loop Over Items1”,
“type”: “main”,
“index”: 0
}
]
]
},
“Loop Over Items1”: {
“main”: [
,
[
{
“node”: “Microsoft Outlook”,
“type”: “main”,
“index”: 0
}
]
]
},
“Edit Fields”: {
“main”: [
]
},
“Microsoft Outlook”: {
“main”: [
]
}
},
“active”: false,
“settings”: {
“executionOrder”: “v1”
},
“versionId”: “5166c9de-c46c-42dc-b2bc-112e5c9f75a1”,
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “8898770c6c7cbb0faed2626c9828c4528fa8ed01c47ff098d48fefdf4437121a”
},
“id”: “Xr2CSDkQNX0wAT2y”,
“tags”:
}