Send Emails from CSV Data

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "nodes": [
    {
      "parameters": {},
      "name": "Start",
      "type": "n8n-nodes-base.start",
      "typeVersion": 1,
      "id": "start"
    },
    {
      "parameters": {
        "filePath": "/home/ubuntu/produtividade_exemplo.csv",
        "options": {}
      },
      "name": "Read CSV",
      "type": "n8n-nodes-base.readCsv",
      "typeVersion": 1,
      "id": "readCsv",
      "executeOnce": false,
      "alwaysOutputData": true,
      "credentials": {}
    },
    {
      "parameters": {
        "values": [
          {
            "name": "total_horas",
            "value": "={{ $json.Horas_Dedicadas }}"
          }
        ],
        "options": {}
      },
      "name": "Set Produtividade",
      "type": "n8n-nodes-base.set",
      "typeVersion": 1,
      "id": "setProdutividade",
      "executeOnce": false,
      "alwaysOutputData": true
    },
    {
      "parameters": {
        "from": "seu_email@exemplo.com",
        "to": "gestor@exemplo.com",
        "subject": "Relat\u00f3rio de Produtividade Di\u00e1ria",
        "text": "Ol\u00e1 Gestor,\n\nSegue o relat\u00f3rio de produtividade di\u00e1ria:\n\n{{ $json.Funcionario }} - {{ $json.Atividade }} ({{ $json.Horas_Dedicadas }} horas) - Status: {{ $json.Status }}\n\nAtenciosamente,\nSua Automa\u00e7\u00e3o n8n",
        "options": {}
      },
      "name": "Send Email",
      "type": "n8n-nodes-base.emailSend",
      "typeVersion": 1,
      "id": "sendEmail",
      "executeOnce": false,
      "alwaysOutputData": true,
      "credentials": {
        "smtp": {
          "name": "<your credential>"
        }
      }
    }
  ],
  "connections": {
    "start": [
      [
        "Read CSV"
      ]
    ],
    "Read CSV": [
      [
        "Set Produtividade"
      ]
    ],
    "Set Produtividade": [
      [
        "Send Email"
      ]
    ]
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• smtp

About this workflow

N8N Workflow Fix. Uses start, readCsv, emailSend. Manual trigger; 4 nodes.

Source: https://github.com/Flame-wtr/n8n/blob/823ede8c9f28b59ba646e174138d164c9c0077e6/n8n_workflow_fix.json — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.