Automate Your Magento 2 Weekly Sales & Performance Reports

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 →

{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "a30bba15-3032-4abe-9431-dfadae71ed3f",
      "name": "GET Week Dates",
      "type": "n8n-nodes-base.code",
      "position": [
        -220,
        -660
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 2
    },
    {
      "id": "40c5272c-b09f-427d-add9-c6460a23177f",
      "name": "Get Last Week Orders",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueRegularOutput",
      "position": [
        220,
        -660
      ],
      "parameters": {},
      "typeVersion": 4.2,
      "alwaysOutputData": false
    },
    {
      "id": "94b4787c-b5ae-427d-b7cd-b83748964e6f",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        440,
        -660
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "47f7cc41-ee09-4f5a-a00d-d73cae9db4ac",
      "name": "Weekly Summary",
      "type": "n8n-nodes-base.code",
      "position": [
        660,
        -760
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "f168f3d2-7c77-4d27-a497-e43baed3f23f",
      "name": "Product Breakdown",
      "type": "n8n-nodes-base.code",
      "position": [
        660,
        -560
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "cc8cf65e-ba9c-479b-b739-9c4e5c99bc50",
      "name": "Log Weekly Summary",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        880,
        -760
      ],
      "parameters": {},
      "typeVersion": 4.6,
      "alwaysOutputData": true
    },
    {
      "id": "7f1cc863-1d7f-465c-b0cd-16ee528c5c8d",
      "name": "Log Products Breakdown",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        880,
        -560
      ],
      "parameters": {},
      "typeVersion": 4.6,
      "alwaysOutputData": true
    },
    {
      "id": "a51b42b7-b591-4e07-8a4d-5f4f567cd26c",
      "name": "Create spreadsheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        0,
        -660
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "be5e4ccd-a578-4c89-9b73-ea113f750dd6",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -440,
        -660
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "8c24cf2f-80c3-4626-a0ff-cf620137a524",
      "name": "Send a message",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1100,
        -760
      ],
      "parameters": {},
      "typeVersion": 2.1
    }
  ],
  "connections": {
    "Code": {
      "main": [
        [
          {
            "node": "Product Breakdown",
            "type": "main",
            "index": 0
          },
          {
            "node": "Weekly Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GET Week Dates": {
      "main": [
        [
          {
            "node": "Create spreadsheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Weekly Summary": {
      "main": [
        [
          {
            "node": "Log Weekly Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "GET Week Dates",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Product Breakdown": {
      "main": [
        [
          {
            "node": "Log Products Breakdown",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create spreadsheet": {
      "main": [
        [
          {
            "node": "Get Last Week Orders",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log Weekly Summary": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Last Week Orders": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log Products Breakdown": {
      "main": [
        []
      ]
    }
  }
}

About this workflow

Perfect for store owners and agencies.

Source: https://n8n.io/workflows/6953/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

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