MS_Gold Price Tracker

• •Telegram Bot Token
• •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich

{
  "id": "8647Dl470mxxSj2Q",
  "meta": {
    "instanceId": "c92a0c76586da37fb3ac600956b62e842bfa4bd5f52acc7feb4e8a6e75ca1381",
    "templateCredsSetupCompleted": true
  },
  "name": "MS_GOLD_PRICING",
  "tags": [],
  "nodes": [
    {
      "id": "8a30ec34-036d-4b20-b434-1e2d6cd27c98",
      "name": "Zeitplan-Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -360,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "minutes",
              "minutesInterval": 15
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "7082fdcf-2877-4f36-b90a-2178ca1505a4",
      "name": "Report: Prepare",
      "type": "n8n-nodes-base.code",
      "position": [
        840,
        20
      ],
      "parameters": {
        "jsCode": "/*\n  n8n Code Node – Gold Table v2 (Fixed Alignment + Thousand Separators)\n  IN  : same JSON payload\n  OUT : { telegram_text : \"<Markdown V2>\" }\n*/\n\nconst data = $json;\nconst meta = data.items[0];\nconst gPerOz = 31.1034768;\nconst usdGram = meta.xauPrice / gPerOz;\nconst rates = data.rates;\n\n// Fixed formatting function with correct column widths and thousand separators\nfunction fmt(n, w) {\n  const rounded = Math.round(n);\n  const formatted = rounded.toLocaleString('en-US'); // Adds thousand separators\n  return formatted.padStart(w, ' ');\n}\n\nfunction esc(txt) {\n  return txt.replace(/([_*[\\]()~`>#+\\-=|{}.!])/g, '\\\\$1');\n}\n\nconst targets = [\n  { flag: '🇪🇬', code: $('Set Currency').first().json.currency },\n  { flag: '🇺🇸', code: 'USD' },\n];\n\nlet rows = '';\nfor (const t of targets) {\n  const fx = rates[t.code] || 1;\n  const g24 = usdGram * fx;\n  \n  // Format each column with the exact width from the table structure\n  const currency = `${t.flag} ${t.code}`.padEnd(9, ' ');  // \"Cur\" column is 8 chars wide (updated)\n  const col24k = fmt(g24, 6);          // \"24k g\" column is 6 chars wide  \n  const col21k = fmt(g24 * 0.875, 6);  // \"21k g\" column is 6 chars wide\n  const col18k = fmt(g24 * 0.75, 6);   // \"18k g\" column is 6 chars wide\n  const col24oz = fmt(g24 * gPerOz, 8); // \"24k oz\" column is 8 chars wide\n  \n  rows += `│ ${currency} │ ${col24k} │ ${col21k} │ ${col18k} │ ${col24oz} │\\n`;\n}\n\nconst arrow = meta.pcXau >= 0 ? '🔺' : '🔻';\nconst pct = meta.pcXau.toFixed(2).replace('-', '');\n\nconst text = `🪙 *Gold per gram / oz*\n\\`\\`\\`\n┌──────────┬────────┬────────┬────────┬──────────┐\n│ Cur      │  24k g │  21k g │  18k g │  24k oz  │\n├──────────┼────────┼────────┼────────┼──────────┤\n${rows}└──────────┴────────┴────────┴────────┴──────────┘\n\\`\\`\\`\n${arrow} *${esc(pct)}\\\\%* _exrate\\\\-api_`;\n\nreturn [{ json: { telegram_text: text } }];"
      },
      "typeVersion": 2
    },
    {
      "id": "a6a78262-ed4e-4ecd-8fc9-7815548d1838",
      "name": "Send a text message",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1160,
        20
      ],
      "webhookId": "6cad3897-95a7-4b25-8fcb-d1c6aac04aa2",
      "parameters": {
        "text": "={{ $json.telegram_text }}",
        "chatId": "={{ $('Set Currency').item.json.telegram_chat_id }}",
        "additionalFields": {
          "parse_mode": "Markdown",
          "appendAttribution": false
        }
      },
      "credentials": {
        "telegramApi": {
          "id": "OymlVCuTPYhVa2B9",
          "name": "Telegram account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "0cbfe028-2702-48fa-9370-a7e218e4aa79",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -140,
        -80
      ],
      "parameters": {
        "color": 5,
        "width": 220,
        "height": 240,
        "content": "## Set inputs \n- currency"
      },
      "typeVersion": 1
    },
    {
      "id": "7a41155a-e736-405e-bb18-3203fdcdf3dd",
      "name": "Haftnotiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        780,
        -60
      ],
      "parameters": {
        "color": 3,
        "width": 220,
        "height": 240,
        "content": "## Report"
      },
      "typeVersion": 1
    },
    {
      "id": "b9bcc84e-b758-4309-b160-1d7d435e86ca",
      "name": "Haftnotiz4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1100,
        -60
      ],
      "parameters": {
        "color": 6,
        "width": 220,
        "height": 240,
        "content": "## Send"
      },
      "typeVersion": 1
    },
    {
      "id": "b8c88e6d-7a4c-417b-a4e8-1533ebab27b5",
      "name": "Convert Currency",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        240,
        180
      ],
      "parameters": {
        "url": "https://open.er-api.com/v6/latest/USD",
        "options": {}
      },
      "typeVersion": 4.2
    },
    {
      "id": "d5000d8e-559e-4e23-a751-17af0ec75198",
      "name": "Fetch Price",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        240,
        -160
      ],
      "parameters": {
        "url": "https://data-asg.goldprice.org/dbXRates/USD",
        "options": {
          "timeout": 5000
        },
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "User-Agent",
              "value": "Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1"
            }
          ]
        }
      },
      "retryOnFail": true,
      "typeVersion": 4.2
    },
    {
      "id": "c552222e-efc9-4c61-ba3c-f1a33d24765a",
      "name": "Haftnotiz5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        180,
        -240
      ],
      "parameters": {
        "color": 3,
        "width": 220,
        "height": 240,
        "content": "## Pricing"
      },
      "typeVersion": 1
    },
    {
      "id": "1506df90-1c50-4744-b776-ff99e2b0d958",
      "name": "Haftnotiz6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        180,
        100
      ],
      "parameters": {
        "color": 3,
        "width": 220,
        "height": 240,
        "content": "## Currrency"
      },
      "typeVersion": 1
    },
    {
      "id": "c90ab53c-8d8a-41b5-86e8-5136e81e6d96",
      "name": "Setzen Currency",
      "type": "n8n-nodes-base.set",
      "position": [
        -80,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "b9f4869a-2059-4b09-84e3-26c7d1e95d30",
              "name": "currency",
              "type": "string",
              "value": "={{ $env.currency }}"
            },
            {
              "id": "593d886f-6c7b-4338-a057-46f2c57a041e",
              "name": "telegram_chat_id",
              "type": "string",
              "value": "={{ $env.telegram_chat_id }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "baa17bc3-0f3e-40a5-9488-41ec54f0291a",
      "name": "Zusammenführen",
      "type": "n8n-nodes-base.merge",
      "position": [
        560,
        20
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineByPosition"
      },
      "typeVersion": 3.2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "a0a28bf8-c7c2-4b00-aef6-799c08e5301f",
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "7082fdcf-2877-4f36-b90a-2178ca1505a4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d5000d8e-559e-4e23-a751-17af0ec75198": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Currency": {
      "main": [
        [
          {
            "node": "d5000d8e-559e-4e23-a751-17af0ec75198",
            "type": "main",
            "index": 0
          },
          {
            "node": "b8c88e6d-7a4c-417b-a4e8-1533ebab27b5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7082fdcf-2877-4f36-b90a-2178ca1505a4": {
      "main": [
        [
          {
            "node": "a6a78262-ed4e-4ecd-8fc9-7815548d1838",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b8c88e6d-7a4c-417b-a4e8-1533ebab27b5": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Set Currency",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}