Weekly Business Report Email

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": "Weekly Business Report",
  "nodes": [
    {
      "id": "schedule",
      "name": "Every Monday 8am",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1.2,
      "position": [
        250,
        300
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "expression": "0 8 * * 1"
            }
          ]
        }
      }
    },
    {
      "id": "fetch",
      "name": "Fetch Metrics",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        450,
        300
      ],
      "parameters": {
        "method": "GET",
        "url": "{{CONFIGURE: metrics API endpoint}}",
        "authentication": "none"
      }
    },
    {
      "id": "aggregate",
      "name": "Aggregate Last 7 Days",
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [
        650,
        300
      ],
      "parameters": {
        "mode": "manual",
        "fields": {
          "values": [
            {
              "name": "period",
              "type": "string",
              "value": "7d"
            },
            {
              "name": "summary",
              "type": "string",
              "value": "={{ JSON.stringify($input.all()) }}"
            }
          ]
        }
      }
    },
    {
      "id": "email",
      "name": "Send Report Email",
      "type": "n8n-nodes-base.emailSend",
      "typeVersion": 2.1,
      "position": [
        850,
        300
      ],
      "parameters": {
        "fromEmail": "{{CONFIGURE: sender email}}",
        "toEmail": "{{CONFIGURE: recipient email}}",
        "subject": "Weekly Business Report",
        "emailType": "text",
        "message": "={{ $json.summary }}"
      }
    },
    {
      "id": "store",
      "name": "Archive To Drive",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        1050,
        300
      ],
      "parameters": {
        "method": "POST",
        "url": "{{CONFIGURE: storage endpoint}}",
        "authentication": "none",
        "sendBody": true,
        "bodyParameters": {
          "parameters": [
            {
              "name": "report",
              "value": "={{ $json.summary }}"
            }
          ]
        }
      }
    }
  ],
  "connections": {
    "Every Monday 8am": {
      "main": [
        [
          {
            "node": "Fetch Metrics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Metrics": {
      "main": [
        [
          {
            "node": "Aggregate Last 7 Days",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate Last 7 Days": {
      "main": [
        [
          {
            "node": "Send Report Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Report Email": {
      "main": [
        [
          {
            "node": "Archive To Drive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {}
}

About this workflow

Weekly Business Report. Uses httpRequest, emailSend. Scheduled trigger; 5 nodes.

Source: https://github.com/jjaguirr/ai-agency-platform/blob/414217bcb46036da6c18e923f2a2d48449e20a96/templates/n8n/report_generation.json — original creator credit. Request a take-down →

More General workflows → · Browse all categories →

Related workflows

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