{
  "name": "Automated marketing performance email reports with Google Sheets & Outlook",
  "nodes": [
    {
      "id": "dd0fb46b-c0ce-4499-a000-8a16fe234969",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -3088,
        1232
      ]
    },
    {
      "id": "67ca251f-bd65-4707-b807-9353033e205c",
      "name": "Get Google Sheets Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2848,
        1264
      ]
    },
    {
      "id": "363322ba-a8f0-4269-afa2-6cc13f7f36b3",
      "name": "Count Unique Customers",
      "type": "n8n-nodes-base.summarize",
      "position": [
        -2144,
        688
      ]
    },
    {
      "id": "d8d0162f-305a-4359-bdd6-ebf917202265",
      "name": "Count Unique Campaigns",
      "type": "n8n-nodes-base.summarize",
      "position": [
        -2144,
        864
      ]
    },
    {
      "id": "de8c8386-8fd7-49ed-bf90-88980ceb90f2",
      "name": "Sum Total Clicks",
      "type": "n8n-nodes-base.summarize",
      "position": [
        -2144,
        1072
      ]
    },
    {
      "id": "6618e8fb-8eb2-43b8-bd5f-b00b7306c8c5",
      "name": "Sum Total Conversions",
      "type": "n8n-nodes-base.summarize",
      "position": [
        -2144,
        1232
      ]
    },
    {
      "id": "c9a81add-1ec5-4db5-8f55-076cdc1db97a",
      "name": "Sum Total Spend",
      "type": "n8n-nodes-base.summarize",
      "position": [
        -2128,
        1408
      ]
    },
    {
      "id": "cf7b8d92-15fa-46fd-a63f-0d1b2792f282",
      "name": "Send Email Report1",
      "type": "n8n-nodes-base.microsoftOutlook",
      "position": [
        -1472,
        1328
      ]
    },
    {
      "id": "d9d8fce2-da0f-4ba4-be18-445f5c71a466",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        -1776,
        1296
      ]
    },
    {
      "id": "446a50f7-8d42-40f9-9323-790ea93a4aa5",
      "name": "Sticky Note17",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3136,
        480
      ],
      "parameters": {
        "width": 1984,
        "height": 128,
        "content": "## 📬 Need Help or Want to Customize This?\n📧 [robert@ynteractive.com](mailto:robert@ynteractive.com)  \n🔗 [LinkedIn](https://www.linkedin.com/in/robert-breen-29429625/)"
      }
    },
    {
      "id": "08007788-b10a-45c2-8d8e-44b31d0679cc",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3136,
        624
      ],
      "parameters": {
        "width": 480,
        "height": 928,
        "content": "### Step 1: Set Up Your Google Sheets Data Source\n\n**Copy the Sample Data Template:**\n1. Access the template: [Marketing Performance Data Template](https://docs.google.com/spreadsheets/d/19aUQYZq02qHs"
      }
    },
    {
      "id": "6020cd74-f930-4e34-bcf4-8bb51caaffcf",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1920,
        624
      ],
      "parameters": {
        "width": 768,
        "height": 928,
        "content": "\n#### Node 8: \"Merge\"\n- **Purpose**: Combines all calculated metrics into one data object\n- **Configuration**: Pre-configured to merge by position\n- **No setup required**\n\n#### Node 9: \"Send Email Rep"
      }
    },
    {
      "id": "babb9445-8793-4b44-8447-0ed788ca53a0",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2624,
        624
      ],
      "parameters": {
        "width": 672,
        "height": 928,
        "content": " #### Node 3-7: Data Analysis Nodes\n\n**\"Count Unique Customers\"**\n- **Purpose**: Counts how many unique customers were reached\n- **Configuration**: Pre-configured to count unique \"Customer ID\" values\n"
      }
    }
  ],
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Send Email Report1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sum Total Spend": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 4
          }
        ]
      ]
    },
    "Sum Total Clicks": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Send Email Report1": {
      "main": [
        []
      ]
    },
    "Sum Total Conversions": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 3
          }
        ]
      ]
    },
    "Count Unique Campaigns": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Count Unique Customers": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Google Sheets Data": {
      "main": [
        [
          {
            "node": "Count Unique Customers",
            "type": "main",
            "index": 0
          },
          {
            "node": "Count Unique Campaigns",
            "type": "main",
            "index": 0
          },
          {
            "node": "Sum Total Clicks",
            "type": "main",
            "index": 0
          },
          {
            "node": "Sum Total Conversions",
            "type": "main",
            "index": 0
          },
          {
            "node": "Sum Total Spend",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get Google Sheets Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}