8
n8n Deutschamn8n.com

Mein Arbeitsablauf 3

Fortgeschritten

Dies ist ein Social Media, Multimodal AI-Bereich Automatisierungsworkflow mit 10 Nodes. Hauptsächlich werden If, Set, Limit, GoogleDrive, GoogleSheets und andere Nodes verwendet. Automatisierung von TikTok-Videopublikationen aus Google Sheets und Drive mit Blotato

Voraussetzungen
  • •Google Drive API-Anmeldedaten
  • •Google Sheets API-Anmeldedaten

Verwendete Nodes (10)

If
Set
Limit
StickyNote
GoogleDrive
GoogleSheets
ScheduleTrigger
Blotato

Kategorie

Soziale Medien
Multimodales KI
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
React Flow
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "id": "fGSgxvT4oxPB2QtC",
  "meta": {
    "instanceId": "aa8f1cf0c4d8087e25a2eea962da249799481d2fb992314793977a97a5e71d77",
    "templateCredsSetupCompleted": true
  },
  "name": "My workflow 3",
  "tags": [],
  "nodes": [
    {
      "id": "803334ae-8858-402a-a572-d8a0bbc53c75",
      "name": "Get Google Drive ID",
      "type": "n8n-nodes-base.set",
      "position": [
        -288,
        400
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "a1750d20-2f6e-4826-80b8-654d0985120d",
              "name": "final_google_drive_url",
              "type": "string",
              "value": "={{ $json['Media URL'].match(/https:\\/\\/drive\\.google\\.com\\/file\\/d\\/([A-Za-z0-9_-]+)/i)[1]  }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "2a36e1fd-0949-44c6-984e-c545cf0454d8",
      "name": "URL VIDEO to Post",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -304,
        192
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TgAOn_dRUwEQFlWtNXFxXj72SVqPuMIMZ85dwsjcuG0/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1TgAOn_dRUwEQFlWtNXFxXj72SVqPuMIMZ85dwsjcuG0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TgAOn_dRUwEQFlWtNXFxXj72SVqPuMIMZ85dwsjcuG0/edit?usp=drivesdk",
          "cachedResultName": "Handsome warden TikTok"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "bAnK8T185A3Wr7Kj",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "b58b9863-09df-4cce-a6c9-ab94c971b408",
      "name": "Upload Video to BLOTATO",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "position": [
        -432,
        608
      ],
      "parameters": {
        "mediaUrl": "=https://drive.google.com/uc?export=download&id={{ $('Get Google Drive ID').item.json.final_google_drive_url }}",
        "resource": "media"
      },
      "credentials": {
        "blotatoApi": {
          "id": "6sPTZyXKAaTQFB4O",
          "name": "Blotato API Account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "fda25ce7-dcba-413e-bc46-894a09924bf0",
      "name": "Tiktok",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "position": [
        -272,
        608
      ],
      "parameters": {
        "options": {},
        "platform": "tiktok",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "13117",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/13117",
          "cachedResultName": "handsomewarden"
        },
        "postContentText": "={{ $('URL VIDEO to Post').item.json.Caption }}",
        "postContentMediaUrls": "={{ $json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "6sPTZyXKAaTQFB4O",
          "name": "Blotato API Account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "ef03626b-2726-424b-9324-7dc308a14c1a",
      "name": "Update Status to \"DONE\"",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -112,
        608
      ],
      "parameters": {
        "columns": {
          "value": {
            "ID": "={{ $('URL VIDEO to Post').item.json.ID }}",
            "Status": "posted"
          },
          "schema": [
            {
              "id": "ID",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "ID",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Title",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Media URL",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Media URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Caption",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Caption",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "ID"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TgAOn_dRUwEQFlWtNXFxXj72SVqPuMIMZ85dwsjcuG0/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1TgAOn_dRUwEQFlWtNXFxXj72SVqPuMIMZ85dwsjcuG0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TgAOn_dRUwEQFlWtNXFxXj72SVqPuMIMZ85dwsjcuG0/edit?usp=drivesdk",
          "cachedResultName": "Handsome warden TikTok"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "bAnK8T185A3Wr7Kj",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "48004fda-d785-4891-a99b-42e1bfc75f20",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        -144,
        192
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "bc74b0c2-aa46-4bcd-91f3-1eb6b0720167",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.Status }}",
              "rightValue": "pending"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "8abafc8d-b429-485b-840f-a4a4cc25cf28",
      "name": "Begrenzen",
      "type": "n8n-nodes-base.limit",
      "position": [
        -432,
        400
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "f0905405-fb5d-4a4b-b67e-76a2a6980962",
      "name": "Zeitplan-Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -464,
        192
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours"
            }
          ]
        }
      },
      "executeOnce": false,
      "retryOnFail": false,
      "typeVersion": 1.2,
      "alwaysOutputData": false
    },
    {
      "id": "d48267e8-d01e-4035-99ed-4f646afe8784",
      "name": "Share file",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -160,
        400
      ],
      "parameters": {
        "fileId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $json.final_google_drive_url }}"
        },
        "options": {},
        "operation": "share",
        "permissionsUi": {
          "permissionsValues": {
            "role": "reader",
            "type": "anyone"
          }
        }
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "id": "1Bnhm02w1dxE4FO6",
          "name": "Farooq Google Drive account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "362862ae-f47f-465a-a771-ae8c408cae94",
      "name": "📋 DATA RETRIEVAL & FILTERING",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -976,
        160
      ],
      "parameters": {
        "width": 464,
        "height": 736,
        "content": "**Data Retrieval & Filtering Section**\n\nThis section fetches video data from Google Sheets and filters for pending posts only.\n\n• Schedule Trigger: Runs every hour\n• Google Sheets: Retrieves video data\n• If Node: Filters for 'pending' status\n• Limit: Processes 1 video at a time to avoid rate limits\n\n**⚠️ IMPORTANT REQUIREMENTS**\n\n• **Self-hosted n8n only** (community nodes required)\n• Google Sheets with columns: ID, Title, Media URL, Caption, Status\n• Blotato API account for TikTok posting\n• Google Drive & Sheets OAuth2 credentials\n• Videos must be stored in Google Drive\n• Status must be set to 'pending' for processing\n\n**Video Processing Section**\n\nThis section handles video file preparation for posting.\n\n• Get Google Drive ID: Extracts file ID from URL\n• Share File: Makes Google Drive file publicly accessible\n• Upload to Blotato: Transfers video to Blotato platform\n\n**TikTok Posting & Tracking Section**\n\nThis section handles the actual posting and status updates.\n\n• TikTok Node: Posts video with caption to TikTok\n• Update Status: Marks post as 'posted' in Google Sheets\n\n**Note:** Ensure your Blotato API credentials are properly configured."
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "d94c0d1f-9d93-4e80-a59a-514f08033055",
  "connections": {
    "48004fda-d785-4891-a99b-42e1bfc75f20": {
      "main": [
        [
          {
            "node": "Limit",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Limit": {
      "main": [
        [
          {
            "node": "803334ae-8858-402a-a572-d8a0bbc53c75",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fda25ce7-dcba-413e-bc46-894a09924bf0": {
      "main": [
        [
          {
            "node": "ef03626b-2726-424b-9324-7dc308a14c1a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d48267e8-d01e-4035-99ed-4f646afe8784": {
      "main": [
        [
          {
            "node": "b58b9863-09df-4cce-a6c9-ab94c971b408",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "2a36e1fd-0949-44c6-984e-c545cf0454d8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2a36e1fd-0949-44c6-984e-c545cf0454d8": {
      "main": [
        [
          {
            "node": "48004fda-d785-4891-a99b-42e1bfc75f20",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "803334ae-8858-402a-a572-d8a0bbc53c75": {
      "main": [
        [
          {
            "node": "d48267e8-d01e-4035-99ed-4f646afe8784",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b58b9863-09df-4cce-a6c9-ab94c971b408": {
      "main": [
        [
          {
            "node": "fda25ce7-dcba-413e-bc46-894a09924bf0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Fortgeschritten - Soziale Medien, Multimodales KI

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.

Verwandte Workflows

Erstellung emotionaler Geschichten mit Gemini KI: Generieren von Bildern und Veo3-JSON-Prompts
Emotionale Geschichte mit Gemini AI erstellen: Bilder und Veo3 JSON-Prompts generieren
If
Set
Code
+
If
Set
Code
35 NodesMuhammad Farooq Iqbal
Content-Erstellung
LinkedIn-Beitrag mit Bild
Automatisierte Erstellung von LinkedIn-Inhalten: Beiträge und Bilder 24/7 mit Gemini AI
If
Code
Limit
+
If
Code
Limit
17 NodesMuhammad Farooq Iqbal
Soziale Medien
Wallpaper
Mit Gemini 2.0, Google Sheets und Drive aus Textprompts KI-Bilder erstellen
If
Code
Limit
+
If
Code
Limit
12 NodesMuhammad Farooq Iqbal
Content-Erstellung
Business-Partner-Erschließung mit Google Maps, GPT-4 und WhatsApp automatisieren
Geschäftliche Partnerakquise mit Google Maps, GPT-4 und WhatsApp automatisieren
If
Set
Code
+
If
Set
Code
64 NodesKhairul Muhtadin
KI-Chatbot
WordPress-Blog-Automatisierung Professional Edition (Deep Research) v2.1 Markt
Automatisierung der Erstellung von SEO-optimierten Blogs mit GPT-4o, Perplexity AI und mehrsprachiger Unterstützung
If
Set
Xml
+
If
Set
Xml
125 NodesDaniel Ng
Content-Erstellung
💥 Automatische Erzeugung von Social-Media-Videos mit GPT-5 und Veröffentlichung mit Blotato - Video
Automatisierte Erstellung von Social-Media-Videos mit GPT-5 und Veröffentlichung mit Blotato
Set
Merge
Telegram
+
Set
Merge
Telegram
31 NodesDr. Firas
Soziale Medien
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes10
Kategorie2
Node-Typen8
Schwierigkeitsbeschreibung

Für erfahrene Benutzer, mittelkomplexe Workflows mit 6-15 Nodes

Autor
Muhammad Farooq Iqbal

Muhammad Farooq Iqbal

@mfarooqone
Externe Links
Auf n8n.io ansehen →

Diesen Workflow teilen

Kategorien

Multimodales KI
1540
Künstliche Intelligenz
1108
Content-Erstellung
695
KI-Zusammenfassung
516
Marketing
419
KI-Chatbot
251
Engineering
241
Marktforschung
203
Verschiedenes
193
Sonstiges
176
Vertrieb
162
IT-Betrieb
156
Dokumentenextraktion
147
KI RAG
146
Bausteine
144
Soziale Medien
137
Lead-Generierung
125
Persönliche Produktivität
117
DevOps
111
Personalwesen
101
Support
97
Lead-Pflege
87
Kundenbeziehungsmanagement
82
Finanzen
81
Produkt
77
Support-Chatbot
76
Design
70
Ticketverwaltung
67
Sicherheitsbetrieb
57
Rechnungsverarbeitung
53
Krypto-Handel
49
Dateiverwaltung
39
Projektmanagement
35
Internes Wiki
32

Kategorien: 34