AutomationFlowsMarketing & Ads › Smartlead Email Campaign Analytics Dashboard with Google Sheets Integration

Smartlead Email Campaign Analytics Dashboard with Google Sheets Integration

ByRahi Uppal @rahiuppal on n8n.io

Workflow 1: Domain and Email Health 🩺 This part of the workflow is triggered every 5 hours by the Schedule Trigger1 node. Its purpose is to pull health metrics for both email domains and individual email addresses.

Cron / scheduled trigger★★★★☆ complexity17 nodesHTTP RequestGoogle Sheets
Marketing & Ads Trigger: Cron / scheduled Nodes: 17 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #7210 — we link there as the canonical source.

This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.

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 →

Download .json
{
  "id": "VZkddNG4TSPdUova",
  "name": "n8nSmartlead",
  "tags": [],
  "nodes": [
    {
      "id": "5502d514-0df8-4a43-b7ee-3d2b339359f3",
      "name": "HTTP Request5",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        520,
        -120
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "4080a374-16cf-4c2c-8aa5-0127015a6184",
      "name": "Append or update row in sheet5",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        920,
        -120
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "a3d52977-01f7-4edf-8e9a-9729519cbfa4",
      "name": "Split Out5",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        740,
        -120
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "ce8aadb2-4bef-4b98-b5b1-e50aa8a07803",
      "name": "HTTP Request6",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        520,
        140
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "c4aa2293-424c-4865-9f89-26e5fd77052f",
      "name": "Append or update row in sheet6",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        920,
        140
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "6515197c-0bb9-463e-837c-ff8e399ecc42",
      "name": "Split Out6",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        740,
        140
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "271bd281-f8f7-4358-ba81-2269ae9c10a7",
      "name": "Schedule Trigger1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        120,
        40
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "0385032a-7bd4-47bd-a105-5f51ef54d90b",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        20,
        -220
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "9d5dde4b-cfe8-4448-b039-2ed8dcdbdc5c",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1760,
        -120
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "02e0141f-2eca-44f3-9188-dc1c00759378",
      "name": "Append or update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2160,
        -120
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "18058bee-4a57-4bfc-9bd8-e9531517d223",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1980,
        -120
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "5b14d983-d3f4-4731-8383-bd77180b3a48",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        1520,
        20
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "b3b9f28c-2e8a-495c-b5aa-55069f8acd39",
      "name": "HTTP Request1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1760,
        160
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "d42a8ab0-799d-41d8-a613-7d62fdb71a38",
      "name": "Append or update row in sheet1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2160,
        160
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "32907a08-92ea-47f0-942d-3b1adcc3ce1d",
      "name": "Split Out1",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1980,
        160
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "3317b109-2406-46f0-a3c3-66c95542cf79",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1400,
        -220
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "02ea928f-b467-4370-9db3-158ec5681745",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1200,
        -420
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "5624155b-c5ff-44a5-a0b0-793f3468c6ae",
  "connections": {
    "Split Out": {
      "main": [
        [
          {
            "node": "Append or update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out1": {
      "main": [
        [
          {
            "node": "Append or update row in sheet1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out5": {
      "main": [
        [
          {
            "node": "Append or update row in sheet5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out6": {
      "main": [
        [
          {
            "node": "Append or update row in sheet6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request1": {
      "main": [
        [
          {
            "node": "Split Out1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request5": {
      "main": [
        [
          {
            "node": "Split Out5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request6": {
      "main": [
        [
          {
            "node": "Split Out6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger1": {
      "main": [
        [
          {
            "node": "HTTP Request5",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Workflow 1: Domain and Email Health 🩺 This part of the workflow is triggered every 5 hours by the Schedule Trigger1 node. Its purpose is to pull health metrics for both email domains and individual email addresses.

Source: https://n8n.io/workflows/7210/ — 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.

Marketing & Ads

This workflow runs on scheduled weekly and monthly triggers to generate unified marketing performance reports. It processes multiple websites by collecting analytics data, paid ads performance, and CR

Gmail, Google Sheets, Google Analytics +3
Marketing & Ads

Goal: Get Reddit posts from specific subreddits, filter those mentioning freelance/gigs and n8n, extract top-level comments, remove mod replies, and store everything into Google Sheets.

HTTP Request, Reddit, Google Sheets
Marketing & Ads

This workflow is a comprehensive solution for digital marketers, performance agencies, and e-commerce brands looking to scale their creative testing process on Meta Ads efficiently. It eliminates the

Google Drive, HTTP Request, Google Sheets
Marketing & Ads

This automation creates a seamless daily pipeline that: Pulls yesterday's website visitors from Leadfeeder Enriches company data using Apollo.io's powerful database Delivers enriched leads to your Goo

HTTP Request, Google Sheets, Error Trigger +1
Marketing & Ads

Watch target companies for C-level and VP hiring signals, then send AI-personalized outreach emails when leadership roles are posted.

Google Sheets, @Predictleads/N8N Nodes Predictleads, Slack +2