{
  "name": "Convert DMARC reports to readable tables with Gmail automation",
  "nodes": [
    {
      "id": "20c68419-20da-4d03-bdbb-ef724420814d",
      "name": "unzip",
      "type": "n8n-nodes-base.compression",
      "position": [
        32,
        -768
      ]
    },
    {
      "id": "279e9ea7-0c62-41dd-8275-4db569b5e30d",
      "name": "xml",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        256,
        -768
      ]
    },
    {
      "id": "01b3cacd-ea7d-4a83-9514-6dc885e58f61",
      "name": "xml2json",
      "type": "n8n-nodes-base.xml",
      "position": [
        480,
        -768
      ]
    },
    {
      "id": "132c9c80-b18b-4b25-9b17-0c1bbfdd3df4",
      "name": "set",
      "type": "n8n-nodes-base.set",
      "position": [
        704,
        -768
      ]
    },
    {
      "id": "1d46956f-93c6-402d-9ae1-df4636920b18",
      "name": "send",
      "type": "n8n-nodes-base.gmail",
      "position": [
        928,
        -768
      ]
    },
    {
      "id": "d4e0902d-a50f-46aa-a800-e342aabe3358",
      "name": "cron",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -416,
        -768
      ]
    },
    {
      "id": "8f154531-edde-43fd-8547-94ece2527a2b",
      "name": "dmarc",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -192,
        -768
      ]
    },
    {
      "id": "4a12a76b-3924-43d6-ab5b-c602a9fb4fe0",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        -864
      ],
      "parameters": {
        "width": 288,
        "height": null,
        "content": "Send report by email. \n\nSuggestion: You could add an Airtable node here if you want to keep records."
      }
    },
    {
      "id": "219325bb-86f9-44d7-be9a-a25ddca52775",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        208,
        -864
      ],
      "parameters": {
        "width": 544,
        "height": null,
        "content": "Convert the XML to JSON. \nHandle both zip and gz formats.\nCreate HTML table for email."
      }
    },
    {
      "id": "d8218575-9846-436c-b429-4a33a6f3d721",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -208,
        -864
      ],
      "parameters": {
        "width": 368,
        "height": null,
        "content": "Get DMARC reports and download the attached reports."
      }
    },
    {
      "id": "9b8f2ae9-f804-4d02-bc33-1a9e43611e06",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -592,
        -864
      ],
      "parameters": {
        "width": 368,
        "height": 112,
        "content": "Gmail and Yahoo send DMARC reports as zip/gz xml files that are hard to read. This workflow unpacks them, turns the data into a simple table, and emails you an easy-to-read report"
      }
    }
  ],
  "connections": {
    "set": {
      "main": [
        [
          {
            "node": "send",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "xml": {
      "main": [
        [
          {
            "node": "xml2json",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cron": {
      "main": [
        [
          {
            "node": "dmarc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "dmarc": {
      "main": [
        [
          {
            "node": "unzip",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "unzip": {
      "main": [
        [
          {
            "node": "xml",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "xml2json": {
      "main": [
        [
          {
            "node": "set",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}