{
  "name": "Generate course certificates from Google Sheets with Stencil PDF and Outlook",
  "nodes": [
    {
      "id": "3343a90f-b31a-46f7-9712-9d9e68f09a00",
      "name": "Generate report",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        176,
        -64
      ]
    },
    {
      "id": "51fe6b7a-cedc-46c4-9473-843b56c3201e",
      "name": "Upload file",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        400,
        16
      ]
    },
    {
      "id": "6c67c9cd-4ac9-4ab7-bce0-695e7335ec02",
      "name": "Update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        624,
        16
      ]
    },
    {
      "id": "7781839c-a6a3-4d1d-9915-d397b51b505c",
      "name": "Send a message",
      "type": "n8n-nodes-base.microsoftOutlook",
      "position": [
        1296,
        -64
      ]
    },
    {
      "id": "aa0b5983-d019-40c0-a8fc-28d311b2749f",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        848,
        -64
      ]
    },
    {
      "id": "d3373c11-524b-4448-8936-2eb248a743c5",
      "name": "New participant",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -720,
        32
      ]
    },
    {
      "id": "d49e1bf3-59ed-4aef-9b2b-f31c71ca71a3",
      "name": "Input",
      "type": "n8n-nodes-base.set",
      "position": [
        -272,
        -64
      ]
    },
    {
      "id": "665178b1-8847-40a5-9463-8f6325659b3f",
      "name": "Test Data",
      "type": "n8n-nodes-base.set",
      "position": [
        -496,
        -160
      ]
    },
    {
      "id": "8a52bef6-6279-48f9-b71c-1cce0f63a455",
      "name": "Update row in sheet1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1520,
        -64
      ]
    },
    {
      "id": "4883c4ff-a5f7-446d-9fae-9a1e8bf1dc5e",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1216,
        -304
      ],
      "parameters": {
        "width": 400,
        "height": 608,
        "content": "## How it works\nThis workflow automates course certificate generation and distribution. When a new participant is added to Google Sheets, the workflow generates a personalized PDF certificate using St"
      }
    },
    {
      "id": "840336e5-0794-425b-ad51-3226dbe3cac5",
      "name": "Generate and save report",
      "type": "n8n-nodes-base.noOp",
      "position": [
        -48,
        -64
      ]
    },
    {
      "id": "a0908fbf-6d2f-4b6b-a3c9-082accc0583f",
      "name": "Send to participant",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1072,
        -64
      ]
    },
    {
      "id": "b75e7c32-253f-4a56-b7c9-4b9be56af6aa",
      "name": "E-Mail not sent",
      "type": "n8n-nodes-base.filter",
      "position": [
        -496,
        32
      ]
    },
    {
      "id": "fc021d18-71cf-41f2-8177-3b7b4f1931cc",
      "name": "Manual Trigger",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -720,
        -160
      ]
    },
    {
      "id": "1ff0471e-da8f-41d8-91be-2ca2eb5103bc",
      "name": "Data Processing",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -528,
        -304
      ],
      "parameters": {
        "width": 384,
        "height": 496,
        "content": "Filters unsent entries and consolidates data from different trigger sources"
      }
    },
    {
      "id": "b128ce20-f85f-44c1-92c5-ab9880f5fb91",
      "name": "PDF Generation & Storage",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        96,
        -304
      ],
      "parameters": {
        "width": 880,
        "height": 496,
        "content": "Creates personalized PDF certificate via Stencil API and stores it in Google Drive. Also it is linked to the participant int he google sheets document."
      }
    },
    {
      "id": "eda2c05d-c731-495f-a96d-506e256e3285",
      "name": "Email Delivery & Tracking",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1248,
        -304
      ],
      "parameters": {
        "width": 448,
        "height": 496,
        "content": "Finished certificate is sent via mail to the participant. "
      }
    }
  ],
  "connections": {
    "Input": {
      "main": [
        [
          {
            "node": "Generate and save report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge": {
      "main": [
        [
          {
            "node": "Send to participant",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Test Data": {
      "main": [
        [
          {
            "node": "Input",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload file": {
      "main": [
        [
          {
            "node": "Update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Manual Trigger": {
      "main": [
        [
          {
            "node": "Test Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message": {
      "main": [
        [
          {
            "node": "Update row in sheet1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "E-Mail not sent": {
      "main": [
        [
          {
            "node": "Input",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate report": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          },
          {
            "node": "Upload file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "New participant": {
      "main": [
        [
          {
            "node": "E-Mail not sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send to participant": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update row in sheet": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Generate and save report": {
      "main": [
        [
          {
            "node": "Generate report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}