{
  "name": "Generate bulk Google Slides certificates 📜 as PDFs and email them with Gmail",
  "nodes": [
    {
      "id": "7e27628a-143d-4695-a7d5-99c16cf41706",
      "name": "When clicking 'Test workflow'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        496,
        272
      ]
    },
    {
      "id": "d31e2c79-a934-4e43-a867-8698907d28c5",
      "name": "Process One at a Time",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1024,
        272
      ]
    },
    {
      "id": "2f920ad0-869f-425f-93cc-ef74b7e4323d",
      "name": "Copy Slides Template",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1280,
        288
      ]
    },
    {
      "id": "60648c15-95db-48b4-9eee-3b1666285bfc",
      "name": "Replace Template Placeholders",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1488,
        288
      ]
    },
    {
      "id": "4f13e912-7e8f-4e4f-9295-9535bcd9ed40",
      "name": "Export to PDF",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1712,
        288
      ]
    },
    {
      "id": "616681e9-bf9d-4713-913f-b84ddeee1d1f",
      "name": "Save PDF to Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        1280,
        960
      ]
    },
    {
      "id": "57962326-14e2-49bb-b46e-40ada76f8d99",
      "name": "Mark as Processed",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1520,
        960
      ]
    },
    {
      "id": "c3db4aa9-ff10-4054-81bb-232bb7c874cd",
      "name": "Send a message",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1280,
        608
      ]
    },
    {
      "id": "14b280e9-b95d-4fba-8990-be9881a950fd",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        1984,
        944
      ]
    },
    {
      "id": "08598641-28bd-4baa-8c6b-021e5c1485e7",
      "name": "Wait 10s",
      "type": "n8n-nodes-base.wait",
      "position": [
        2240,
        944
      ]
    },
    {
      "id": "57f6a4e7-b234-4514-8608-4beec902ce5b",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1216,
        144
      ],
      "parameters": {
        "width": 656,
        "height": 304,
        "content": "## STEP 2 - Template\nReplace xxx with the Google Slides base template file id [like this](https://docs.google.com/presentation/d/1YWYsNfq4FeHP03MSYFz1cobVczBHWxwEW95BE4w0FHc/edit?slide=id.p#slide=id.p"
      }
    },
    {
      "id": "b8e5e740-7d8c-4293-b39d-d119c6aad242",
      "name": "Delete Temp Slide",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1744,
        960
      ]
    },
    {
      "id": "43d185ba-e4ea-4abe-b86d-b9d1045e4830",
      "name": "Read File",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        752,
        272
      ]
    },
    {
      "id": "336bcffe-1625-4882-8838-14ccbab5ce9e",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        672,
        144
      ],
      "parameters": {
        "width": 528,
        "height": 304,
        "content": "## STEP 1 - DB\nClone [this Sheet](https://docs.google.com/spreadsheets/d/1fHcfilCPpI4aAiJFQC3cPIAdJMmctMubz3kcOeai1yA/edit?usp=sharing). The workflow can generate and send personalized certificates fo"
      }
    },
    {
      "id": "dc1f88c2-1c9e-408a-920f-c291b51e2858",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1200,
        -384
      ],
      "parameters": {
        "width": 672,
        "height": 480,
        "content": "## Bulk certificate generator with Google Slides\n\n\n### How it works\n\nThis workflow bulk-generates personalized certificates by reading recipient data from Google Sheets and processing only rows that h"
      }
    },
    {
      "id": "308eda62-8989-4d70-8781-9da27efc2b46",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1216,
        480
      ],
      "parameters": {
        "width": 656,
        "height": 304,
        "content": "## STEP 3 - Email\nCertificates are automatically sent to recipients"
      }
    },
    {
      "id": "54863914-ad67-4fee-939c-ac670c4a26cf",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1216,
        816
      ],
      "parameters": {
        "width": 656,
        "height": 304,
        "content": "## STEP 4 - Save to Google Drive\nTemporary Google Slides files created during the generation process are automatically deleted after use, keeping **Google Drive clean and organized**."
      }
    },
    {
      "id": "b5afef8e-6853-421c-815b-908839bf3884",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        432,
        -640
      ],
      "parameters": {
        "width": 736,
        "height": 736,
        "content": "## MY NEW YOUTUBE CHANNEL\n👉 [Subscribe to my new **YouTube channel**](https://youtube.com/@n3witalia). Here I’ll share videos and Shorts with practical tutorials and **FREE templates for n8n**.\n\n[![im"
      }
    }
  ],
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Wait 10s",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 10s": {
      "main": [
        [
          {
            "node": "Process One at a Time",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read File": {
      "main": [
        [
          {
            "node": "Process One at a Time",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Export to PDF": {
      "main": [
        [
          {
            "node": "Save PDF to Drive",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Delete Temp Slide": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Mark as Processed": {
      "main": [
        [
          {
            "node": "Delete Temp Slide",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save PDF to Drive": {
      "main": [
        [
          {
            "node": "Mark as Processed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Copy Slides Template": {
      "main": [
        [
          {
            "node": "Replace Template Placeholders",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process One at a Time": {
      "main": [
        [],
        [
          {
            "node": "Copy Slides Template",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Replace Template Placeholders": {
      "main": [
        [
          {
            "node": "Export to PDF",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking 'Test workflow'": {
      "main": [
        [
          {
            "node": "Read File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}