Automatisierung der Brand-Asset-Ordner und Kundenbenachrichtigungen

• •Google-Konto + Gmail API-Anmeldedaten
• •Slack Bot Token oder Webhook URL
• •Google Drive API-Anmeldedaten
• •Google Sheets API-Anmeldedaten

{
  "id": "jmS6Qy4SvpqfkhrP",
  "meta": {
    "instanceId": "a287613f1596da776459594685fbf4e2b4a12124f80ab8c8772f5e37bff103ae",
    "templateCredsSetupCompleted": true
  },
  "name": "Brand Asset Folder Automation & Client Notification",
  "tags": [],
  "nodes": [
    {
      "id": "172ce921-4c79-4a36-a2ec-01b64dd21bad",
      "name": "Projektordner erstellen",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        200,
        -220
      ],
      "parameters": {
        "name": "={{ $json.client_name }}",
        "options": {},
        "resource": "drive",
        "authentication": "oAuth2"
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "id": "x21v1WYanfJMbdKO",
          "name": "Google Drive account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "9767a498-c0dd-48f4-a185-5b1da3c19b67",
      "name": "Notiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        -280
      ],
      "parameters": {
        "width": 1160,
        "height": 240,
        "content": "## Flow"
      },
      "typeVersion": 1
    },
    {
      "id": "407f1185-9cca-43ef-a0b7-2cc0a9ecd76b",
      "name": "Team benachrichtigen Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        640,
        -220
      ],
      "parameters": {
        "text": "=🎉 New onboarding started: {{ $('Edit Fields').item.json.client_name }} - {{ $('Edit Fields').item.json.project_type }} (Due {{ $('Edit Fields').item.json.deadline }})",
        "channel": "#ops",
        "attachments": [],
        "otherOptions": {}
      },
      "typeVersion": 1
    },
    {
      "id": "6e55e74a-aeed-48ba-9256-02237d327379",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        420,
        -220
      ],
      "webhookId": "1c7da0c9-84d0-4043-b465-fe1675c68f29",
      "parameters": {
        "sendTo": "={{ $json.contact_email }}",
        "message": "=Hi {{ $json.client_name }},\n\nThanks for choosing us for your project: {{ $json.project_type }}\n\nWe’ve created a dedicated Drive folder for your files and assets: {{ $json.brand_drive_folder }}\n\nThe expected deadline is {{ $json.deadline }}, and we’ll be supporting you every step of the way.\n\nIf you have questions, just reply to this email.\n\nCheers,  \nThe Neura Forge Team\n",
        "options": {},
        "subject": "=Welcome to Your Project: {{ $json.project_type }}",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "QFfaHpKmgq4YPiRN",
          "name": "Temp"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "379b7a46-591a-417f-8bbb-d6512e680cb9",
      "name": "Felder bearbeiten",
      "type": "n8n-nodes-base.set",
      "position": [
        -20,
        -220
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "ffa83172-5dc5-4c96-b12f-97341b8e5353",
              "name": "client_name",
              "type": "string",
              "value": ""
            },
            {
              "id": "cc2e6229-be93-4105-a567-4fa1fd0f70dd",
              "name": "contact_email",
              "type": "string",
              "value": ""
            },
            {
              "id": "c79c2ceb-ad1c-4682-9644-10b8aaa412fc",
              "name": "project_type",
              "type": "string",
              "value": ""
            },
            {
              "id": "83fe9c2d-3f46-4832-9509-b7aef48a609b",
              "name": "deadline",
              "type": "string",
              "value": ""
            },
            {
              "id": "31e20af4-e807-409f-802c-04cfc79daa0c",
              "name": "brand_drive_folder",
              "type": "string",
              "value": ""
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "68e27ad8-5985-406e-9e49-4abcc7ad623c",
      "name": "Google Tabellen Trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -240,
        -220
      ],
      "parameters": {
        "event": "rowUpdate",
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        }
      },
      "credentials": {
        "googleSheetsTriggerOAuth2Api": {
          "id": "nvSvynB2kgypuGYX",
          "name": "Google Sheets Trigger account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "50e3c83d-6c47-41f7-a70a-52effef4ef54",
      "name": "Notiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        0
      ],
      "parameters": {
        "color": 3,
        "width": 840,
        "height": 860,
        "content": "# Brand Asset Folder Automation & Client Notification\n\n## 🧠 Problem\nCreative and digital agencies often waste time manually creating Google Drive folders for each new client or project. Project managers must manually send emails with folder links, and clients often get confused on where to upload their assets. This slows down project kick-offs and introduces chaos in collaboration.\n\n## ✅ Solution\nThis automation automatically creates a Google Drive folder when a new project is initiated, generates a shareable link, and sends a personalized email to the client with instructions and a link to upload brand assets. This eliminates manual folder creation and improves client onboarding speed and clarity.\n\n## 👥 This AI Agent is for:\n- Creative & digital agencies  \n- Freelancers handling multiple client projects  \n- Project managers dealing with design, branding, or web development  \n- Remote teams that rely on structured file management workflows\n\n## 🧩 Scope\n- **Input**: Project brief including client name, contact email, project type, deadline  \n- **Google Drive**: Auto-create a folder inside a parent directory  \n- **Output**: Email sent to client with folder link, project summary, and next steps  \n- **Optional**: Store metadata to Airtable or Notion\n\n## ⚙️ How to Set Up\n1. Configure your Google Drive credentials in n8n and allow folder creation access  \n2. Create a parent folder where all project folders will be generated  \n3. Fill in required input fields (e.g. client name, email, deadline, project type)  \n4. Update the Gmail node with your preferred email content and sender address  \n5. Test the workflow with sample data before activating\n"
      },
      "typeVersion": 1
    },
    {
      "id": "e445df5a-f051-43ab-ae8b-a473fe9eb50d",
      "name": "Notiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        540,
        0
      ],
      "parameters": {
        "color": 4,
        "width": 300,
        "height": 300,
        "content": "# Google Sheet Format\n\n### client_name\n### client_contact\n### project_type\n### deadline\n### brand_drive_folder"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "8ad9dd11-89b7-444d-b360-5366f8c8ca1c",
  "connections": {
    "6e55e74a-aeed-48ba-9256-02237d327379": {
      "main": [
        [
          {
            "node": "407f1185-9cca-43ef-a0b7-2cc0a9ecd76b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "379b7a46-591a-417f-8bbb-d6512e680cb9": {
      "main": [
        [
          {
            "node": "172ce921-4c79-4a36-a2ec-01b64dd21bad",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "172ce921-4c79-4a36-a2ec-01b64dd21bad": {
      "main": [
        [
          {
            "node": "6e55e74a-aeed-48ba-9256-02237d327379",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Trigger": {
      "main": [
        [
          {
            "node": "379b7a46-591a-417f-8bbb-d6512e680cb9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}