私のワークフロー3
中級
これはSocial Media, Multimodal AI分野の自動化ワークフローで、10個のノードを含みます。主にIf, Set, Limit, GoogleDrive, GoogleSheetsなどのノードを使用。 Google SheetsとGoogle Driveを使ってBlotatoでTikTok動画の自動投稿
前提条件
- •Google Drive API認証情報
- •Google Sheets API認証情報
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "fGSgxvT4oxPB2QtC",
"meta": {
"instanceId": "aa8f1cf0c4d8087e25a2eea962da249799481d2fb992314793977a97a5e71d77",
"templateCredsSetupCompleted": true
},
"name": "My workflow 3",
"tags": [],
"nodes": [
{
"id": "803334ae-8858-402a-a572-d8a0bbc53c75",
"name": "Get Google ドライブ 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": "制限",
"type": "n8n-nodes-base.limit",
"position": [
-432,
400
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f0905405-fb5d-4a4b-b67e-76a2a6980962",
"name": "スケジュールトリガー",
"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": "Get Google Drive ID",
"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
}
]
]
},
"Get Google Drive ID": {
"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
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - ソーシャルメディア, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
Gemini AIを使用した感情物語作成：画像生成とVeo3 JSONプロンプト
Gemini AIを使って感情のある物語を作成：画像とVeo3 JSONプロンプトを生成する
If
Set
Code
+
If
Set
Code
35 ノードMuhammad Farooq Iqbal
コンテンツ作成
LinkedInに画像付きで投稿
Gemini AIでLinkedInコンテンツ（投稿と画像）をAIが24/7自動生成
If
Code
Limit
+
If
Code
Limit
17 ノードMuhammad Farooq Iqbal
ソーシャルメディア
壁紙
Gemini 2.0、Google Sheets、Google Drive を使ってテキストプロンプトから AI 画像を生成
If
Code
Limit
+
If
Code
Limit
12 ノードMuhammad Farooq Iqbal
コンテンツ作成
Google Maps、GPT-4、WhatsApp を使用したビジネスパートナー獲得の自動化
Google Maps、GPT-4、WhatsAppを使用したビジネスパートナーの開拓の自動化
If
Set
Code
+
If
Set
Code
64 ノードKhairul Muhtadin
AIチャットボット
WordPressブログの自動化プロフェッショナル版（先端研究）v2.1マーケットプラグイン
GPT-4o、Perplexity AI、そして多言語対応を使ったSEO最適化ブログ作成の自動化
If
Set
Xml
+
If
Set
Xml
125 ノードDaniel Ng
コンテンツ作成
💥 GPT-5を使用してソーシャルメディア動画を自動生成し、Blotato経由で公開 - 動画
GPT-5を使用して自動のにソーシャルメディア動画を生成し、Blotatoで公開
Set
Merge
Telegram
+
Set
Merge
Telegram
31 ノードDr. Firas
ソーシャルメディア
