Automated Email Marketing from Google Sheets

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 →

{
  "name": "Automatizaci\u00f3n de Email Marketing",
  "nodes": [
    {
      "id": "1",
      "name": "Schedule",
      "type": "n8n-nodes-base.cron",
      "position": [
        100,
        300
      ],
      "parameters": {
        "triggerTimes": {
          "item": [
            {
              "mode": "everyWeek",
              "dayOfWeek": 1,
              "hour": 9,
              "minute": 0
            }
          ]
        }
      }
    },
    {
      "id": "2",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        300,
        300
      ],
      "parameters": {
        "operation": "read",
        "sheetName": "Suscriptores",
        "range": "A:D"
      }
    },
    {
      "id": "3",
      "name": "Function",
      "type": "n8n-nodes-base.function",
      "position": [
        500,
        300
      ],
      "parameters": {
        "functionCode": "// Personalizar los datos para cada suscriptor\nfor (const item of items) {\n  item.json.personalizacion = `Hola ${item.json.nombre}, te enviamos las \u00faltimas novedades sobre IA.`;\n}\nreturn items;"
      }
    },
    {
      "id": "4",
      "name": "Send Email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        700,
        300
      ],
      "parameters": {
        "to": "={{ $json[\"email\"] }}",
        "subject": "Novedades semanales de IA",
        "text": "={{ $json[\"personalizacion\"] }}\n\nDescubre los \u00faltimos avances en inteligencia artificial."
      }
    }
  ],
  "connections": {
    "Schedule": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets": {
      "main": [
        [
          {
            "node": "Function",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Function": {
      "main": [
        [
          {
            "node": "Send Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

About this workflow

Automatización de Email Marketing. Uses googleSheets, emailSend. Scheduled trigger; 4 nodes.

Source: https://github.com/cristianbm-hub/elproyectoia_landing/blob/68766838f037aa9f97ca3fb237bbea5127c90bce/public/workflows/email-marketing.txt — original creator credit. Request a take-down →

More Marketing & Ads workflows → · Browse all categories →

Related workflows

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