8
n8n Françaisamn8n.com

Mon workflow 3

Intermédiaire

Ceci est unSocial Media, Multimodal AIworkflow d'automatisation du domainecontenant 10 nœuds.Utilise principalement des nœuds comme If, Set, Limit, GoogleDrive, GoogleSheets. Automatiser la publication de vidéos TikTok à partir de Google Sheets et Drive avec Blotato

Prérequis
  • •Informations d'identification Google Drive API
  • •Informations d'identification Google Sheets API

Nœuds utilisés (10)

If
Set
Limit
StickyNote
GoogleDrive
GoogleSheets
ScheduleTrigger
Blotato

Catégorie

Réseaux sociaux
IA Multimodale
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
React Flow
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "id": "fGSgxvT4oxPB2QtC",
  "meta": {
    "instanceId": "aa8f1cf0c4d8087e25a2eea962da249799481d2fb992314793977a97a5e71d77",
    "templateCredsSetupCompleted": true
  },
  "name": "My workflow 3",
  "tags": [],
  "nodes": [
    {
      "id": "803334ae-8858-402a-a572-d8a0bbc53c75",
      "name": "Obtenir l'ID Drive Google",
      "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 à publier",
      "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": "Téléverser la vidéo sur 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": "Mettre à jour le statut en \"TERMINÉ\"",
      "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": "Limit",
      "type": "n8n-nodes-base.limit",
      "position": [
        -432,
        400
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "f0905405-fb5d-4a4b-b67e-76a2a6980962",
      "name": "Schedule 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": "Partager le fichier",
      "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": "📋 RÉCUPÉRATION & FILTRAGE DES DONNÉES",
      "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": "8abafc8d-b429-485b-840f-a4a4cc25cf28",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8abafc8d-b429-485b-840f-a4a4cc25cf28": {
      "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
          }
        ]
      ]
    },
    "f0905405-fb5d-4a4b-b67e-76a2a6980962": {
      "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
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Intermédiaire - Réseaux sociaux, IA Multimodale

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Workflows recommandés

Créer une histoire émotionnelle avec l'IA Gemini : générer des images et des invites JSON pour Veo3
Créer une histoire émotionnelle avec Gemini IA : générer des images et des invites JSON pour Veo3
If
Set
Code
+
If
Set
Code
35 NœudsMuhammad Farooq Iqbal
Création de contenu
Publication LinkedIn avec image
Génération automatique de contenu LinkedIn : publications et images 24/7 avec Gemini AI
If
Code
Limit
+
If
Code
Limit
17 NœudsMuhammad Farooq Iqbal
Réseaux sociaux
Fonds d'écran
Générer des images IA à partir de prompts texte avec Gemini 2.0, Google Sheets et Drive
If
Code
Limit
+
If
Code
Limit
12 NœudsMuhammad Farooq Iqbal
Création de contenu
Automatisation du développement de partenaires commerciaux avec Google Maps, GPT-4 et WhatsApp
Automatisation du développement de partenaires commerciaux avec Google Maps, GPT-4 et WhatsApp
If
Set
Code
+
If
Set
Code
64 NœudsKhairul Muhtadin
Chatbot IA
Version professionnelle de l'automatisation de blog WordPress (recherche approfondie) v2.1 sur le marché
Automatisation de la création de blog optimisé pour le SEO avec GPT-4o, Perplexity AI et support multilingue
If
Set
Xml
+
If
Set
Xml
125 NœudsDaniel Ng
Création de contenu
💥 Générer automatiquement des vidéos de médias sociaux avec GPT-5 et les publier via Blotato - Vidéo
Génération automatique de vidéos pour les médias sociaux avec GPT-5 et publication via Blotato
Set
Merge
Telegram
+
Set
Merge
Telegram
31 NœudsDr. Firas
Réseaux sociaux
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds10
Catégorie2
Types de nœuds8
Description de la difficulté

Adapté aux utilisateurs expérimentés, avec des workflows de complexité moyenne contenant 6-15 nœuds

Auteur
Muhammad Farooq Iqbal

Muhammad Farooq Iqbal

@mfarooqone
Liens externes
Voir sur n8n.io →

Partager ce workflow

Catégories

IA Multimodale
1540
Intelligence Artificielle
1108
Création de contenu
695
Résumé IA
516
Marketing
419
Chatbot IA
251
Ingénierie
241
Étude de marché
203
Divers
193
Autres
176
Ventes
162
Opérations IT
156
Extraction de documents
147
RAG IA
146
Blocs de construction
144
Réseaux sociaux
137
Génération de leads
125
Productivité personnelle
117
DevOps
111
Ressources Humaines
101
Support
97
Nurturing de leads
87
CRM
82
Finance
81
Produit
77
Chatbot de support
76
Design
70
Gestion des tickets
67
Opérations de sécurité
57
Traitement des factures
53
Trading crypto
49
Gestion de fichiers
39
Gestion de projet
35
Wiki interne
32

Catégories: 34