I couldnt get it to work heres a copy of my work flow the NINE is the part that changes to randon tickers APPL TSLA etc in the end I just want the ticket by itself to be added to a cell in google sheets
{
“nodes”: [
{
“parameters”: {
“keepOnlySet”: true,
“values”: {
“string”: [
{
“name”: “TICKER”,
“value”: “={{$json[“raw”]}}”
}
]
},
“options”: {
“dotNotation”: false
}
},
“name”: “Set”,
“type”: “n8n-nodes-base.set”,
“typeVersion”: 1,
“position”: [
400,
200
]
},
{
“parameters”: {
“postProcessAction”: “nothing”,
“format”: “raw”,
“options”: {
“customEmailConfig”: “[“UNSEEN”]”,
“allowUnauthorizedCerts”: true
}
},
“name”: “IMAP Email”,
“type”: “n8n-nodes-base.emailReadImap”,
“typeVersion”: 1,
“position”: [
0,
200
],
“credentials”: {
“imap”: {
“id”: “15”,
“name”: “IMAP account”
}
}
},
{
“parameters”: {
“operation”: “removeDuplicates”
},
“name”: “Item Lists”,
“type”: “n8n-nodes-base.itemLists”,
“typeVersion”: 1,
“position”: [
220,
200
]
},
{
“parameters”: {
“values”: {
“string”: [
{
“name”: “TICKER”,
“value”: “TradingView Screener Alert:\nNew Tickers:\nNYSE:NINE”
}
]
},
“options”: {}
},
“name”: “Get initial values”,
“type”: “n8n-nodes-base.set”,
“typeVersion”: 1,
“position”: [
480,
20
]
},
{
“parameters”: {
“values”: {
“string”: [
{
“name”: "If the value always contains NYSE: ",
“value”: “={{$json[“TICKER”].match(/(?<!\w)\w+$/).toString()}}”
}
]
},
“options”: {}
},
“name”: “NYSE”,
“type”: “n8n-nodes-base.set”,
“typeVersion”: 1,
“position”: [
700,
20
]
}
],
“connections”: {
“IMAP Email”: {
“main”: [
[
{
“node”: “Item Lists”,
“type”: “main”,
“index”: 0
}
]
]
},
“Item Lists”: {
“main”: [
[
{
“node”: “Set”,
“type”: “main”,
“index”: 0
}
]
]
},
“Get initial values”: {
“main”: [
[
{
“node”: “NYSE”,
“type”: “main”,
“index”: 0
}
]
]
}
}
}