{
  "name": "Export Cloudflare domains with DNS records and settings to Google Sheets",
  "nodes": [
    {
      "id": "9fd3e8a6-291f-4aba-bdc2-9055bd0e6d6b",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        680,
        380
      ],
      "parameters": {
        "width": 500,
        "height": 240,
        "content": "# Requirements\n\nFor storing and processing of data in this flow you will need:\n\n- CloudFlare.com API key/token - for retrieving your data (https://dash.cloudflare.com/:account/api-tokens) (need full a"
      }
    },
    {
      "id": "f4b9ee64-9c52-43bb-a91e-ad03a6286e3c",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        680,
        640
      ],
      "parameters": {
        "width": 500,
        "height": 600,
        "content": "# Author\n![Kpendic](https://gravatar.com/avatar/8e343ec0d9b4fb672f921e822a8561be?size=188)\n### Kresimir Pendic\nSenior BE professional, specializing in automation, AI and data analysis. \n\n## Say hi!\nht"
      }
    },
    {
      "id": "b47eb629-9241-420c-8490-669d3ee1b037",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        680,
        1260
      ],
      "parameters": {
        "width": 500,
        "height": 140,
        "content": "# Need help?\nFor getting help with this workflow, please create a topic on the community forums here:\nhttps://community.n8n.io/c/questions/"
      }
    },
    {
      "id": "00f46c50-55a1-48f8-a519-621973f2a886",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        680,
        220
      ],
      "parameters": {
        "width": 2000,
        "height": 140,
        "content": ""
      }
    },
    {
      "id": "b5f368ea-72ae-4cb0-b09b-e80b9818f779",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1300,
        260
      ],
      "parameters": {
        "width": 740,
        "height": 80,
        "content": "# CloudFlare dump => Google Sheets"
      }
    },
    {
      "id": "2536518c-90b5-49be-8a22-0b3e542831f1",
      "name": "When clicking ‘Test workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        1280,
        600
      ]
    },
    {
      "id": "e206aea7-d544-43c2-89cd-9808ec164b03",
      "name": "Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1200,
        380
      ],
      "parameters": {
        "width": 1480,
        "height": 920,
        "content": "## Fetch TLDs, each dns & settings & Transform data\n\n1. Get your CloudFlare domains and basic info\nhttps://dash.cloudflare.com/:account/api-tokens\n2. Adapt your Transformings to your specific needs\n3."
      }
    },
    {
      "id": "fa2397fa-baee-4aca-8ca3-8c0d1d2fada4",
      "name": "Wait",
      "type": "n8n-nodes-base.wait",
      "position": [
        1380,
        1020
      ]
    },
    {
      "id": "da801aa4-e3f1-4e56-93e4-928eda0962d5",
      "name": "Set Page",
      "type": "n8n-nodes-base.set",
      "position": [
        1520,
        600
      ]
    },
    {
      "id": "5ae6a35b-5090-449f-a689-b82a13ced8b3",
      "name": "Increment Page",
      "type": "n8n-nodes-base.set",
      "position": [
        1280,
        820
      ]
    },
    {
      "id": "deb40a37-4e32-4dc6-8620-8322ef8014ea",
      "name": "More Pages?",
      "type": "n8n-nodes-base.if",
      "position": [
        1840,
        1080
      ]
    },
    {
      "id": "fcd860d3-021e-4cb1-a347-ffbe1d61a184",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        1620,
        820
      ]
    },
    {
      "id": "2348687c-8ce7-440a-9209-7ddc39c046ca",
      "name": "Get TLDs",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1720,
        600
      ]
    },
    {
      "id": "542fad7f-13d5-4ddd-8558-23858b62764e",
      "name": "Each Host",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1900,
        600
      ]
    },
    {
      "id": "0e2582e1-c058-4b18-a062-7f199beb56ef",
      "name": "Get DNS",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2160,
        760
      ]
    },
    {
      "id": "09d1c96b-dc94-43bd-8847-5ba40747747a",
      "name": "Get Settings",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2180,
        540
      ]
    },
    {
      "id": "12cf6091-df4b-4f8a-be93-79933778f667",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2120,
        1000
      ],
      "parameters": {
        "width": 540,
        "height": 280,
        "content": "## 2. Add credentials for Google Sheets & save"
      }
    },
    {
      "id": "57f125f5-319c-4607-b3ed-522ee9d086c2",
      "name": "Flatten",
      "type": "n8n-nodes-base.code",
      "position": [
        2240,
        1080
      ]
    },
    {
      "id": "3c84495b-1c2d-4252-bb9e-6f77d009a660",
      "name": "Filter TLD",
      "type": "n8n-nodes-base.code",
      "position": [
        1840,
        820
      ]
    },
    {
      "id": "d57e934d-d000-401f-938a-f9eeed756ff2",
      "name": "Filter DNS",
      "type": "n8n-nodes-base.code",
      "position": [
        2400,
        800
      ]
    },
    {
      "id": "820d2a47-77c6-47bb-a236-9f91351ad343",
      "name": "Filter Settings",
      "type": "n8n-nodes-base.code",
      "position": [
        2440,
        560
      ]
    },
    {
      "id": "c5cb1263-7b24-48be-9af4-25eba131db17",
      "name": "Export",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2460,
        1080
      ]
    }
  ],
  "connections": {
    "Wait": {
      "main": [
        [
          {
            "node": "Increment Page",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge": {
      "main": [
        [
          {
            "node": "More Pages?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Flatten": {
      "main": [
        [
          {
            "node": "Export",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get DNS": {
      "main": [
        [
          {
            "node": "Filter DNS",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get TLDs": {
      "main": [
        [
          {
            "node": "Each Host",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Page": {
      "main": [
        [
          {
            "node": "Get TLDs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Each Host": {
      "main": [
        [
          {
            "node": "Get Settings",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get DNS",
            "type": "main",
            "index": 0
          },
          {
            "node": "Filter TLD",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter DNS": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Filter TLD": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "More Pages?": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          },
          {
            "node": "Flatten",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Flatten",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Settings": {
      "main": [
        [
          {
            "node": "Filter Settings",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Increment Page": {
      "main": [
        [
          {
            "node": "Set Page",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Settings": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Set Page",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}