{
  "name": "Track and report App Store featuring nominations with MySQL, Slack and Google Drive",
  "nodes": [
    {
      "id": "49057997-4b97-4dc8-bdd1-a7596336c6ef",
      "name": "Convert to File",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        176,
        752
      ]
    },
    {
      "id": "c136156c-50fa-4778-86c6-1281ca22224d",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        400,
        400
      ]
    },
    {
      "id": "d5498122-dfe5-414c-9a8a-b3d3f2407e22",
      "name": "Upload file",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        384,
        944
      ]
    },
    {
      "id": "318d19eb-028e-4183-9f55-3c43ae67aeb4",
      "name": "Upload a file",
      "type": "n8n-nodes-base.slack",
      "position": [
        384,
        752
      ]
    },
    {
      "id": "0a6048c3-ded2-4ea9-8731-6222d1dbe759",
      "name": "Split Out1",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        400,
        144
      ]
    },
    {
      "id": "977249ba-cdfa-41a7-bdfe-57f1e163a132",
      "name": "JWT Auth",
      "type": "n8n-nodes-base.jwt",
      "position": [
        -48,
        256
      ]
    },
    {
      "id": "2e10c8a9-34e1-45ee-989d-c0421ca63f30",
      "name": "Fetch apps from App Store Connect",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        192,
        144
      ]
    },
    {
      "id": "b05fbbc1-b995-4020-8c4d-3c1b680ba81f",
      "name": "Fetch submitted nominations from App Store Connect",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        192,
        400
      ]
    },
    {
      "id": "1121f3fd-fabc-4114-9d8a-16d5787cb721",
      "name": "Store applications in MySQL",
      "type": "n8n-nodes-base.mySql",
      "position": [
        608,
        144
      ]
    },
    {
      "id": "959cc6ed-a27c-4880-9489-80d5889d8ea8",
      "name": "Store nominations in MySQL",
      "type": "n8n-nodes-base.mySql",
      "position": [
        608,
        400
      ]
    },
    {
      "id": "78b7631e-6cf4-4405-b7d7-ff357dc82945",
      "name": "Generate the report with a query",
      "type": "n8n-nodes-base.mySql",
      "position": [
        -32,
        752
      ]
    },
    {
      "id": "9e830d1f-4394-4dee-b1e2-fdeffb5783ca",
      "name": "Weekly Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -320,
        400
      ]
    },
    {
      "id": "26cd9aaa-bc2d-4087-9b7a-eacb5689557c",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        800,
        48
      ],
      "parameters": {
        "width": 384,
        "height": 224,
        "content": "CREATE TABLE `applications` (\n  `id` int NOT NULL AUTO_INCREMENT,\n  `apple_app_id` bigint NOT NULL,\n  `name` text NOT NULL,\n  `bundle_id` text NOT NULL,\n  PRIMARY KEY (`id`),\n  UNIQUE KEY `apple_app_i"
      }
    },
    {
      "id": "dcf196f7-04a7-4261-9858-6a8d660648b4",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        800,
        368
      ],
      "parameters": {
        "width": 400,
        "height": 464,
        "content": "CREATE TABLE `nominations` (\n  `id` int NOT NULL AUTO_INCREMENT,\n  `nomination_id` varchar(45) NOT NULL,\n  `app_id` bigint DEFAULT NULL,\n  `type` varchar(45) DEFAULT NULL,\n  `name` text,\n  `sub_type` "
      }
    },
    {
      "id": "ff176030-be3c-4352-b33f-03bb87c8256e",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -928,
        112
      ],
      "parameters": {
        "width": 560,
        "height": 768,
        "content": "### Apple App Store Connect: Featuring Nominations Report\n\nThis workflow automates the process of tracking and reporting app nominations submitted to Apple for App Store featuring consideration. It co"
      }
    },
    {
      "id": "d5476450-96d9-4267-ba5c-7e7ea6b87b8b",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        128,
        96
      ],
      "parameters": {
        "width": 624,
        "height": 224,
        "content": "Fetch applications from App Store Connect API and store them in MySQL"
      }
    },
    {
      "id": "52c173f4-e5f1-4408-877a-0ba02b8aeaf0",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        128,
        352
      ],
      "parameters": {
        "width": 624,
        "height": 224,
        "content": "Fetch nominations from App Store Connect API and store them in MySQL"
      }
    },
    {
      "id": "b788da30-b5f7-4fdb-8026-20c2552a3e30",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        176
      ],
      "parameters": {
        "width": 150,
        "height": 240,
        "content": "App Store Connect API authentication"
      }
    },
    {
      "id": "61cb070d-7b27-45bf-ab92-81ee022052c1",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -96,
        704
      ],
      "parameters": {
        "width": 662,
        "height": 400,
        "content": "Run a SQL query to generate the report and upload it to Slack and Google Drive"
      }
    }
  ],
  "connections": {
    "JWT Auth": {
      "main": [
        [
          {
            "node": "Fetch submitted nominations from App Store Connect",
            "type": "main",
            "index": 0
          },
          {
            "node": "Fetch apps from App Store Connect",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out": {
      "main": [
        [
          {
            "node": "Store nominations in MySQL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out1": {
      "main": [
        [
          {
            "node": "Store applications in MySQL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Weekly Trigger": {
      "main": [
        [
          {
            "node": "JWT Auth",
            "type": "main",
            "index": 0
          },
          {
            "node": "Generate the report with a query",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to File": {
      "main": [
        [
          {
            "node": "Upload file",
            "type": "main",
            "index": 0
          },
          {
            "node": "Upload a file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate the report with a query": {
      "main": [
        [
          {
            "node": "Convert to File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch apps from App Store Connect": {
      "main": [
        [
          {
            "node": "Split Out1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch submitted nominations from App Store Connect": {
      "main": [
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}