This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"active": false,
"connections": {
"Get my video": {
"main": [
[
{
"node": "Assign Social Media IDs",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get my video",
"type": "main",
"index": 0
}
]
]
},
"Assign Social Media IDs": {
"main": [
[
{
"node": "Upload Video to Blotato",
"type": "main",
"index": 0
}
]
]
},
"Upload Video to Blotato": {
"main": [
[
{
"node": "INSTAGRAM",
"type": "main",
"index": 0
},
{
"node": "YOUTUBE",
"type": "main",
"index": 0
},
{
"node": "TIKTOK",
"type": "main",
"index": 0
},
{
"node": "FACEBOOK",
"type": "main",
"index": 0
},
{
"node": "THREADS",
"type": "main",
"index": 0
},
{
"node": "LINKEDIN",
"type": "main",
"index": 0
},
{
"node": "BLUESKY",
"type": "main",
"index": 0
},
{
"node": "PINTEREST",
"type": "main",
"index": 0
},
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
}
},
"createdAt": "2025-07-14T19:04:38.814Z",
"id": "8UpqTxZE8W7papQu",
"isArchived": false,
"meta": {
"templateCredsSetupCompleted": true
},
"name": "11-Auto_Publish_Social_Videos_to_9_Platforms_via_Google_Sheets_and_Blotato",
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 22
}
]
}
},
"id": "67e5232a-4f1e-43ef-a10d-624a07f2d88b",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
480,
120
],
"typeVersion": 1.2
},
{
"parameters": {
"mode": "raw",
"jsonOutput": "{\n \"instagram_id\": \"111\",\n \"youtube_id\": \"222\",\n \"tiktok_id\": \"333\",\n \"facebook_id\": \"444\",\n \"facebook_page_id\": \"555\",\n \"threads_id\": \"666\",\n \"twitter_id\": \"777\",\n \"linkedin_id\": \"888\",\n \"pinterest_id\": \"999\",\n \"pinterest_board_id\": \"101010\",\n \"bluesky_id\": \"111111\"\n}",
"options": {}
},
"id": "4a2aa29e-51e6-4c86-a7a6-3890d3ed32fd",
"name": "Assign Social Media IDs",
"type": "n8n-nodes-base.set",
"position": [
920,
120
],
"typeVersion": 3.4
},
{
"parameters": {
"documentId": {
"__rl": true,
"mode": "id",
"value": "="
},
"sheetName": {
"__rl": true,
"mode": "id",
"value": "="
},
"options": {}
},
"id": "a850d49d-c2d2-4d61-ab34-b04e7b47de7d",
"name": "Get my video",
"type": "n8n-nodes-base.googleSheets",
"position": [
700,
120
],
"typeVersion": 4.5
},
{
"parameters": {
"method": "POST",
"url": "https://backend.blotato.com/v2/media",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "blotato-api-key"
}
]
},
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "url",
"value": "={{ $('Get my video').item.json['URL VIDEO'] }}"
}
]
},
"options": {}
},
"id": "b9fbc1e4-440a-4384-89ea-36d6fbb2e062",
"name": "Upload Video to Blotato",
"type": "n8n-nodes-base.httpRequest",
"position": [
1160,
120
],
"typeVersion": 4.2
},
{
"parameters": {
"method": "POST",
"url": "https://backend.blotato.com/v2/posts",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "blotato-api-key"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"post\": {\n \"accountId\": \"{{ $('Assign Social Media IDs').item.json.instagram_id }}\",\n \"target\": {\n \"targetType\": \"instagram\"\n },\n \"content\": {\n \"text\": \"{{ $('Get my video').item.json.DESCRIPTION }}\",\n \"platform\": \"instagram\",\n \"mediaUrls\": [\n \"{{ $json.url }}\"\n ]\n }\n }\n}\n\n",
"options": {}
},
"id": "205f97b6-a1fb-49dd-8a90-952e403ec1c7",
"name": "INSTAGRAM",
"type": "n8n-nodes-base.httpRequest",
"position": [
1440,
-140
],
"typeVersion": 4.2
},
{
"parameters": {
"method": "POST",
"url": "https://backend.blotato.com/v2/posts",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "blotato-api-key"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"post\": {\n \"accountId\": \"{{ $('Assign Social Media IDs').item.json.youtube_id }}\",\n \"target\": {\n \"targetType\": \"youtube\",\n \"title\": \"{{ $('Get my video').item.json.Titre }}\",\n \"privacyStatus\": \"unlisted\",\n \"shouldNotifySubscribers\": \"false\"\n },\n \"content\": {\n \"text\": \"{{ $('Get my video').item.json.DESCRIPTION }}\",\n \"platform\": \"youtube\",\n \"mediaUrls\": [\n \"{{ $json.url }}\"\n ]\n }\n }\n}\n",
"options": {}
},
"id": "9debf86d-dae8-4100-9fda-4b318aa26a28",
"name": "YOUTUBE",
"type": "n8n-nodes-base.httpRequest",
"position": [
1660,
-140
],
"typeVersion": 4.2
},
{
"parameters": {
"method": "POST",
"url": "https://backend.blotato.com/v2/posts",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "blotato-api-key"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"post\": {\n \"accountId\": \"{{ $('Assign Social Media IDs').item.json.tiktok_id }}\",\n \"target\": {\n \"targetType\": \"tiktok\",\n \"isYourBrand\": \"false\", \n \"disabledDuet\": \"false\",\n \"privacyLevel\": \"PUBLIC_TO_EVERYONE\",\n \"isAiGenerated\": \"true\",\n \"disabledStitch\": \"false\",\n \"disabledComments\": \"false\",\n \"isBrandedContent\": \"false\"\n \n },\n \"content\": {\n \"text\": \"{{ $('Get my video').item.json.DESCRIPTION }}\",\n \"platform\": \"tiktok\",\n \"mediaUrls\": [\n \"{{ $json.url }}\"\n ]\n }\n }\n}\n",
"options": {}
},
"id": "20c52c17-238b-4cdb-9664-2a580f88ac02",
"name": "TIKTOK",
"type": "n8n-nodes-base.httpRequest",
"position": [
1860,
-140
],
"typeVersion": 4.2
},
{
"parameters": {
"method": "POST",
"url": "https://backend.blotato.com/v2/posts",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "blotato-api-key"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"post\": {\n \"accountId\": \"{{ $('Assign Social Media IDs').item.json.facebook_id }}\",\n \"target\": {\n \"targetType\": \"facebook\",\n \"pageId\": \"{{ $('Assign Social Media IDs').item.json.facebook_page_id }}\"\n\n \n },\n \"content\": {\n \"text\": \"{{ $('Get my video').item.json.DESCRIPTION }}\",\n \"platform\": \"facebook\",\n \"mediaUrls\": [\n \"{{ $json.url }}\"\n ]\n }\n }\n}",
"options": {}
},
"id": "1c555f43-6ebd-4710-af08-494b14e036b8",
"name": "FACEBOOK",
"type": "n8n-nodes-base.httpRequest",
"position": [
1440,
120
],
"typeVersion": 4.2
},
{
"parameters": {
"method": "POST",
"url": "https://backend.blotato.com/v2/posts",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "blotato-api-key"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"post\": {\n \"accountId\": \"{{ $('Assign Social Media IDs').item.json.threads_id }}\",\n \"target\": {\n \"targetType\": \"threads\"\n \n },\n \"content\": {\n \"text\": \"{{ $('Get my video').item.json.DESCRIPTION }}\",\n \"platform\": \"threads\",\n \"mediaUrls\": [\n \"{{ $json.url }}\"\n ]\n }\n }\n}\n",
"options": {}
},
"id": "de51a562-e421-4b5a-b112-53ee722ece47",
"name": "THREADS",
"type": "n8n-nodes-base.httpRequest",
"position": [
1660,
120
],
"typeVersion": 4.2
},
{
"parameters": {
"method": "POST",
"url": "https://backend.blotato.com/v2/posts",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "blotato-api-key"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"post\": {\n \"accountId\": \"{{ $('Assign Social Media IDs').item.json.twitter_id }}\",\n \"target\": {\n \"targetType\": \"twitter\"\n \n },\n \"content\": {\n \"text\": \"{{ $('Get my video').item.json.DESCRIPTION }}\",\n \"platform\": \"twitter\",\n \"mediaUrls\": [\n \"{{ $json.url }}\"\n ]\n }\n }\n}\n",
"options": {}
},
"id": "06220ac6-db3d-498d-af9f-a4d403fab420",
"name": "TWETTER",
"type": "n8n-nodes-base.httpRequest",
"position": [
1860,
120
],
"typeVersion": 4.2
},
{
"parameters": {
"method": "POST",
"url": "https://backend.blotato.com/v2/posts",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "blotato-api-key"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"post\": {\n \"accountId\": \"{{ $('Assign Social Media IDs').item.json.linkedin_id }}\",\n \"target\": {\n \"targetType\": \"linkedin\"\n \n },\n \"content\": {\n \"text\": \"{{ $('Get my video').item.json.DESCRIPTION }}\",\n \"platform\": \"linkedin\",\n \"mediaUrls\": [\n \"{{ $json.url }}\"\n ]\n }\n }\n}\n",
"options": {}
},
"id": "a88f6498-f63c-4499-8eee-65d8e74627c8",
"name": "LINKEDIN",
"type": "n8n-nodes-base.httpRequest",
"position": [
1440,
360
],
"typeVersion": 4.2
},
{
"parameters": {
"method": "POST",
"url": "https://backend.blotato.com/v2/posts",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "blotato-api-key"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "= {\n \"post\": {\n \"accountId\": \"{{ $('Assign Social Media IDs').item.json.bluesky_id }}\",\n \"target\": {\n \"targetType\": \"bluesky\"\n \n },\n \"content\": {\n \"text\": \"{{ $('Get my video').item.json.DESCRIPTION }}\",\n \"platform\": \"bluesky\",\n \"mediaUrls\": [\n \"https://pbs.twimg.com/media/GE8MgIiWEAAfsK3.jpg\"\n ]\n }\n }\n}\n",
"options": {}
},
"id": "a8c1eb1e-fa5a-4b4b-a8f8-acd3361a6720",
"name": "BLUESKY",
"type": "n8n-nodes-base.httpRequest",
"position": [
1660,
360
],
"typeVersion": 4.2
},
{
"parameters": {
"method": "POST",
"url": "https://backend.blotato.com/v2/posts",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "blotato-api-key"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"post\": {\n \"accountId\": \"{{ $('Assign Social Media IDs').item.json.pinterest_id }}\",\n \"target\": {\n \"targetType\": \"pinterest\",\n \"boardId\": \"{{ $('Assign Social Media IDs').item.json.pinterest_board_id }}\" \n },\n \"content\": {\n \"text\": \"{{ $('Get my video').item.json.DESCRIPTION }}\",\n \"platform\": \"pinterest\",\n \"mediaUrls\": [\n \"https://pbs.twimg.com/media/GE8MgIiWEAAfsK3.jpg\"\n ]\n }\n }\n}\n\n",
"options": {}
},
"id": "720cf804-a98f-4f7a-9e8d-136e588c1404",
"name": "PINTEREST",
"type": "n8n-nodes-base.httpRequest",
"position": [
1860,
360
],
"typeVersion": 4.2
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"mode": "id",
"value": "="
},
"sheetName": {
"__rl": true,
"mode": "id",
"value": "="
},
"columns": {
"value": {
"STATUS": "DONE",
"row_number": "={{ $('Get my video').item.json.row_number }}"
},
"schema": [
{
"id": "PROMPT",
"type": "string",
"display": true,
"required": false,
"displayName": "PROMPT",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "DESCRIPTION",
"type": "string",
"display": true,
"required": false,
"displayName": "DESCRIPTION",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL VIDEO",
"type": "string",
"display": true,
"required": false,
"displayName": "URL VIDEO",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Titre",
"type": "string",
"display": true,
"required": false,
"displayName": "Titre",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "STATUS",
"type": "string",
"display": true,
"required": false,
"displayName": "STATUS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"id": "9b598a55-4f96-4934-9e4d-f974113ff1dc",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
2040,
120
],
"typeVersion": 4.5
},
{
"parameters": {
"content": "# Auto-Publish to 9 Social Platforms\n## Automates distribution using Blotato\u2019s API.\n## The video is auto-published to Instagram, YouTube, TikTok, Facebook, \n## LinkedIn, Threads, Twitter (X), Bluesky, and Pinterest \n## \u2014 all in one go, with no manual work required.\n### ** Documentation : ** [Guide](https://automatisation.notion.site/Workflow-n8n-d-Auto-Post-sur-les-r-seaux-sociaux-1d33d6550fd980b7b43ac417e9a06a9b?pvs=4)",
"height": 300,
"width": 880,
"color": 6
},
"id": "f05644fe-0b75-4553-ad3f-69eed8402f11",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
420,
-340
],
"typeVersion": 1
},
{
"parameters": {
"content": "## External Setup Guide\n[Guide](https://dr-firas.vip/)",
"height": 80,
"width": 300
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
420,
-440
],
"id": "ebe86cd7-113a-404b-9216-4fb2842c2476",
"name": "Sticky Note4"
}
],
"settings": {
"executionOrder": "v1"
},
"shared": [
{
"createdAt": "2025-08-13T17:53:53.281Z",
"updatedAt": "2025-08-13T17:53:53.281Z",
"role": "workflow:owner",
"workflowId": "8UpqTxZE8W7papQu",
"projectId": "6FPie4k3QSdqcndC"
}
],
"staticData": null,
"tags": [
{
"createdAt": "2025-07-09T21:41:38.773Z",
"updatedAt": "2025-07-09T21:41:38.773Z",
"id": "G5Lcoe2jTgqCJuSy",
"name": "OpenAI"
},
{
"createdAt": "2025-07-09T23:31:21.052Z",
"updatedAt": "2025-07-09T23:31:21.052Z",
"id": "JXtwH1KWn3HpvHrm",
"name": "templates"
},
{
"createdAt": "2025-07-09T23:31:21.059Z",
"updatedAt": "2025-07-09T23:31:21.059Z",
"id": "giPr8wYqaJHn1OWx",
"name": "creator"
},
{
"createdAt": "2025-07-09T21:41:38.763Z",
"updatedAt": "2025-07-09T21:41:38.763Z",
"id": "pz5LfYMpyppJnoPT",
"name": "WooCommerce"
}
],
"triggerCount": 0,
"updatedAt": "2025-07-14T19:04:38.814Z",
"versionId": "af2ec08c-842b-479f-a33b-763880616930"
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
11-Auto_Publish_Social_Videos_to_9_Platforms_via_Google_Sheets_and_Blotato. Uses googleSheets, httpRequest. Scheduled trigger; 16 nodes.
Source: https://github.com/ashishk-yadav/n8n-backup/blob/b98f3bb6ce2bd2837199bdcd61a27af64d0d652e/workflows/OpenAI/8UpqTxZE8W7papQu.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow automates video distribution to 9 social platforms simultaneously using Blotato's API. It includes both a scheduled publisher (checks Google Sheets for videos marked "Ready") and a subwo
Google Sheets, HTTP Request, Form Trigger +2
YogiAI. Uses googleSheets, googleSheetsTool, httpRequest, stopAndError. Scheduled trigger; 61 nodes.
Google Sheets, Google Sheets Tool, HTTP Request +1
This workflow monitors Google Calendar for events indicating that a customer will visit the company today or the next day, retrieves the required details, and sends reminder notifications to the relev
Google Calendar, Google Sheets, HTTP Request +1
ofn hook v0.24.0 beta. Uses start, httpRequest, functionItem, itemLists. Scheduled trigger; 42 nodes.
Start, HTTP Request, Function Item +3
Security teams, DevOps engineers, vulnerability analysts, and automation builders who want to eliminate repetitive Nessus scan parsing, AI-based risk triage, and manual reporting. Designed for orgs fo
Email Send, HTTP Request, Google Sheets +1