AutomationFlowsData & Sheets › Automated Daily Posting to 9 Social Platforms with Google Sheets, Drive and…

Automated Daily Posting to 9 Social Platforms with Google Sheets, Drive and…

Original n8n title: Automated Daily Posting to 9 Social Platforms with Google Sheets, Drive and Blotato

BySabrina Ramonov 🍄 @sabrina-ramonov on n8n.io

This automation publishes to 9 social platforms daily! Manage your content in a simple Google Sheet. When you set a post's status to "Ready to Post" in your Google Sheet, this workflow grabs your image/video from your Google Drive, posts your content to 9 social platforms, then…

Cron / scheduled trigger★★★★☆ complexity23 nodesGoogle Sheets@Blotato/N8N Nodes Blotato
Data & Sheets Trigger: Cron / scheduled Nodes: 23 Complexity: ★★★★☆ Added:
Automated Daily Posting to 9 Social Platforms with Google Sheets, Drive and… — n8n workflow card showing Google Sheets, @Blotato/N8N Nodes Blotato integration

This workflow corresponds to n8n.io template #8524 — we link there as the canonical source.

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 →

Download .json
{
  "id": "IsEN5SyZ7lz4zsGY",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "1 Post Everywhere",
  "tags": [],
  "nodes": [
    {
      "id": "b203144c-fc13-47ed-815c-d034615e2ec4",
      "name": "Get Google Drive ID",
      "type": "n8n-nodes-base.set",
      "position": [
        -576,
        928
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "a1750d20-2f6e-4826-80b8-654d0985120d",
              "name": "final_google_drive_url",
              "type": "string",
              "value": "={{ $('Ready to Post Image/Video').item.json['Media URL (google drive)'].match(/https:\\/\\/drive\\.google\\.com\\/file\\/d\\/([A-Za-z0-9_-]+)/i)[1] }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "3816e08f-ca5f-4dc1-a376-0455edc6bad0",
      "name": "Ready to Post Image/Video",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -816,
        928
      ],
      "parameters": {
        "options": {
          "returnFirstMatch": true
        },
        "filtersUI": {
          "values": [
            {
              "lookupValue": "Ready to Post",
              "lookupColumn": "Status"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4/edit?usp=drivesdk",
          "cachedResultName": "1_post_everywhere"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "fa56ad76-9c08-42cd-b2c2-4053895fb730",
      "name": "Upload Image/Video to BLOTATO",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "position": [
        -336,
        928
      ],
      "parameters": {
        "mediaUrl": "=https://drive.google.com/uc?export=download&id={{ $json.final_google_drive_url }}",
        "resource": "media"
      },
      "credentials": {
        "blotatoApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "dd641212-cc0e-4259-95fa-8dbea48c1fe4",
      "name": "Tiktok [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "maxTries": 2,
      "position": [
        240,
        240
      ],
      "parameters": {
        "options": {},
        "platform": "tiktok",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "199",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/199",
          "cachedResultName": "sabrina_ramonov"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "name": "<your credential>"
        }
      },
      "retryOnFail": false,
      "typeVersion": 2,
      "waitBetweenTries": 3000
    },
    {
      "id": "ad80ba63-740a-4522-bee7-7ecd3237fe3d",
      "name": "Check Every 3 Hours",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1056,
        928
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours",
              "hoursInterval": 3
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "cf740889-604b-4494-b565-11c472b689c0",
      "name": "Linkedin [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "position": [
        240,
        400
      ],
      "parameters": {
        "options": {},
        "platform": "linkedin",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "4590",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/4590",
          "cachedResultName": "Sabrina Ramonov \ud83c\udf44"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "261a582e-fc1a-44c6-91d7-da34bfe631b2",
      "name": "Facebook [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "position": [
        240,
        560
      ],
      "parameters": {
        "options": {},
        "platform": "facebook",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "369",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/369",
          "cachedResultName": "Sabrina Ramonov"
        },
        "facebookPageId": {
          "__rl": true,
          "mode": "list",
          "value": "161711670360847",
          "cachedResultUrl": "https://backend.blotato.com/v2/YOUR_AWS_SECRET_KEY_HERE",
          "cachedResultName": "Blotato"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "b721aba5-845d-44b7-ba80-fa8d79094a3f",
      "name": "Instagram [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "maxTries": 2,
      "position": [
        240,
        720
      ],
      "parameters": {
        "options": {},
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "28",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/28",
          "cachedResultName": "sabrina_ramonov"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "name": "<your credential>"
        }
      },
      "retryOnFail": true,
      "typeVersion": 2,
      "waitBetweenTries": 5000
    },
    {
      "id": "2be9a129-4ed0-4a3b-9faa-4ef7cfaab7a7",
      "name": "Twitter [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "position": [
        240,
        880
      ],
      "parameters": {
        "options": {},
        "platform": "twitter",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "38",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/38",
          "cachedResultName": "Sabrina_Ramonov"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "f6527ebf-0f51-4301-aa83-8cb0bddef948",
      "name": "Youtube [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "position": [
        240,
        1040
      ],
      "parameters": {
        "options": {},
        "platform": "youtube",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "111",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/111",
          "cachedResultName": "Sabrina Ramonov \ud83c\udf44"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}",
        "postCreateYoutubeOptionTitle": "={{ $('Ready to Post Image/Video').item.json.Title }}"
      },
      "credentials": {
        "blotatoApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "c6566c09-9366-4d8c-afb4-073b0013954d",
      "name": "Threads [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "position": [
        240,
        1200
      ],
      "parameters": {
        "options": {},
        "platform": "threads",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "3",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/3",
          "cachedResultName": "sabrina_ramonov"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "668aa4c7-0058-472e-9196-a5a41eb0dd19",
      "name": "Bluesky [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "position": [
        240,
        1360
      ],
      "parameters": {
        "options": {},
        "platform": "bluesky",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "8",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/8",
          "cachedResultName": "sabrinaramonov.bsky.social"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "dcee45da-64dc-48a2-8a41-086b441ba409",
      "name": "Pinterest [BLOTATO]",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "onError": "continueErrorOutput",
      "position": [
        240,
        1520
      ],
      "parameters": {
        "options": {},
        "platform": "pinterest",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "358",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/358",
          "cachedResultName": "sabrina_ramonov"
        },
        "postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
        "pinterestBoardId": {
          "__rl": true,
          "mode": "id",
          "value": "1234"
        },
        "postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "eb36ef73-5b01-41ec-ae72-138647989dd5",
      "name": "Update Status to \"Posted\"",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        240,
        1744
      ],
      "parameters": {
        "columns": {
          "value": {
            "Status": "Posted",
            "Caption": "={{ $('Ready to Post Image/Video').item.json.Caption }}"
          },
          "schema": [
            {
              "id": "Title",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Media URL (google drive)",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Media URL (google drive)",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Caption",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Caption",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Caption"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4/edit?usp=drivesdk",
          "cachedResultName": "1_post_everywhere"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "57f04d8e-8317-4921-8e74-19526f16e675",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1152,
        304
      ],
      "parameters": {
        "color": 6,
        "width": 1056,
        "height": 1232,
        "content": "# Ready to Post\nYou can post text, images, videos, stories, slideshows, and carousels. \n\n## How Template Works\n- Checks Google Sheet every 3 hours for new items with status \"Ready to Post\"\n- Get 1 item that is ready to post (so you don't spam too many posts at the same time)\n- Get unique Google Drive ID of media (image/video)\n- Upload media to Blotato\n- Post media and caption to social platforms\n- Update item's status to \"Posted\" in Google sheet\n\n## Setup\n1. Sign up for Blotato.com\n2. Generate Blotato API Key by going to Settings > API > Generate API Key (paid feature only)\n3. Ensure you have \"Verified Community Nodes\" enabled in your n8n Admin Panel. Install \"Blotato\" community node.\n4. Create credential for Blotato.\n5. Connect your Google Drive to n8n: https://docs.n8n.io/integrations/builtin/credentials/google/oauth-single-service\n6. Copy this sample Google Sheet. Do NOT change the column names, unless you know what you're doing:\nhttps://docs.google.com/spreadsheets/d/1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4/edit\n7. Make your Google Drive folder containing images/videos PUBLIC (i.e. Anyone with the link)\n8. Complete the 3 setup steps shown in BROWN sticky notes in this template"
      },
      "typeVersion": 1
    },
    {
      "id": "c901d211-cf71-49a7-8220-9d2ef799668b",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -880,
        1104
      ],
      "parameters": {
        "color": 2,
        "width": 224,
        "height": 112,
        "content": "# Setup 1\nConfigure your Google Sheet"
      },
      "typeVersion": 1
    },
    {
      "id": "c1b490bb-7fd4-4fdb-a72b-22adb7a3871e",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -608,
        1104
      ],
      "parameters": {
        "color": 3,
        "width": 150,
        "height": 112,
        "content": "# Don't Touch"
      },
      "typeVersion": 1
    },
    {
      "id": "438b1381-f384-4365-aaf7-c990e28df071",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -256
      ],
      "parameters": {
        "color": 4,
        "width": 928,
        "height": 2224,
        "content": "# Post Everywhere\n\n## IMPORTANT\nDo not post the same image/video over and over again, otherwise it will be flagged as spam. Make sure to disclose AI generated content if you're using avatars.\n\n\ud83d\udc49  **Blotato API Docs**: https://help.blotato.com/api\n\u2705  **Troubleshoot Errors**: https://my.blotato.com/api-dashboard\n\ud83d\udcf7  **Media Requirements**: https://help.blotato.com/api/media\n\ud83d\udee0\ufe0f  **Contact help**: log into blotato > click support button in bottom right corner"
      },
      "typeVersion": 1
    },
    {
      "id": "e49dbbe2-fff5-44d5-a878-d8ada23a5d6b",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -416,
        1104
      ],
      "parameters": {
        "color": 2,
        "width": 272,
        "height": 304,
        "content": "# Setup 2\nSelect your Blotato credential\n\n### Troubleshooting Checklist:\n- your Google Drive is public\n- column names in your Google Sheet match the original example\n- file size < 60MB; for large files, Google Drive does not work, use Amazon S3 instead"
      },
      "typeVersion": 1
    },
    {
      "id": "c1d94f4b-00e2-47f8-839e-81f104ecfbe9",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1056,
        64
      ],
      "parameters": {
        "color": 7,
        "width": 608,
        "height": 1632,
        "content": "# Platform Specific Notes\n\n## Tiktok\nYou can post images, videos, and slideshows. Your Tiktok account must be warmed up before using Blotato, otherwise you'll get low views. [Follow this warm up guide](https://help.blotato.com/platforms/tiktok/brand-new-accounts). \n\nCheck out best practices and troubleshooting FAQs:\nhttps://help.blotato.com/platforms/tiktok\n\n## Linkedin\nYou can post text, images, videos, and PDF carousels. Check out best practices and troubleshooting FAQs:\nhttps://help.blotato.com/platforms/linkedin\n\n## Facebook\nYou can post text, images, regular videos, and reels. Check out best practices and troubleshooting FAQs\nhttps://help.blotato.com/platforms/facebook\n\n## Instagram\nYou can post images, reels, stories, and slideshows. Check out best practices and troubleshooting FAQs:\nhttps://help.blotato.com/platforms/instagram\n\n## Twitter\nYou can post text, images, and videos. You can post a long-form thread by clicking \"Show Advanced Settings\". Check out best practices and troubleshooting FAQs:\nhttps://help.blotato.com/platforms/twitter\n\n## Threads\nYou can post text, images, and videos. You can post a long-form thread by clicking \"Show Advanced Settings\". Check out best practices and troubleshooting FAQs:\nhttps://help.blotato.com/platforms/threads\n\n## Bluesky\nYou can post text, images, and videos. You can post a long-form thread by clicking \"Show Advanced Settings\". Check out best practices and troubleshooting FAQs:\nhttps://help.blotato.com/platforms/bluesky\n\n## Youtube\nYou can post Youtube shorts and long-form videos. You don't need to do anything. Youtube automatically posts Shorts if your video is <2 minutes and 9:16 aspect ratio.\n\nBrand new Youtube accounts are limited to a few posts per day via API. You can still upload manually through Youtube website. This restriction is directly from Youtube and is gradually lifted as you post consistently.\n\nCheck out best practices and troubleshooting FAQs:\nhttps://help.blotato.com/platforms/youtube\n\n## Pinterest\nYou can post image and video pins. You must warm up your Pinterest account by posting a few pins per day, gradually ramping up.\n\nHow to Get Your Pinterest Board ID:\nGo to Blotato, create a Pinterest post, click Publish, and you'll see your board IDs. Copy board ID to here.\n\nCheck out best practices and troubleshooting FAQs:\nhttps://help.blotato.com/platforms/pinterest\n\n## Need More Help?\n\nLog into Blotato.com\nClick support button in bottom right corner.\nSabrina Ramonov\ud83c\udf44 replies within 24 hours most weekdays."
      },
      "typeVersion": 1
    },
    {
      "id": "5f3b1432-b8e8-49a6-8b64-cd87eb266cc4",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        128,
        32
      ],
      "parameters": {
        "color": 2,
        "width": 320,
        "height": 176,
        "content": "# Setup 3\n1. Open each node\n2. Select your social account\n3. Deactivate platforms you don't need\n3. \ud83d\udc49 **You don't need to do anything else!**"
      },
      "typeVersion": 1
    },
    {
      "id": "c6bd6077-6d4c-485b-84db-63386a12329c",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        592,
        1104
      ],
      "parameters": {
        "color": 7,
        "width": 288,
        "height": 192,
        "content": "# Final Report\n\n\ud83d\udc49 View run logs and results.\n\n\ud83d\udc49 API Dashboard:\n https://my.blotato.com/api-dashboard"
      },
      "typeVersion": 1
    },
    {
      "id": "f75a35bc-24a7-4ec8-9165-c17e230e7f34",
      "name": "Final Report",
      "type": "n8n-nodes-base.merge",
      "position": [
        672,
        720
      ],
      "parameters": {
        "numberInputs": 9
      },
      "notesInFlow": false,
      "typeVersion": 3.2
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "a3cc5077-67c4-472e-b9bb-e93b21130696",
  "connections": {
    "Tiktok [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Bluesky [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 7
          }
        ]
      ]
    },
    "Threads [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 6
          }
        ]
      ]
    },
    "Twitter [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 4
          }
        ]
      ]
    },
    "Youtube [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 5
          }
        ]
      ]
    },
    "Facebook [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Linkedin [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Check Every 3 Hours": {
      "main": [
        [
          {
            "node": "Ready to Post Image/Video",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Google Drive ID": {
      "main": [
        [
          {
            "node": "Upload Image/Video to BLOTATO",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Instagram [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 3
          }
        ]
      ]
    },
    "Pinterest [BLOTATO]": {
      "main": [
        [],
        [
          {
            "node": "Final Report",
            "type": "main",
            "index": 8
          }
        ]
      ]
    },
    "Ready to Post Image/Video": {
      "main": [
        [
          {
            "node": "Get Google Drive ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload Image/Video to BLOTATO": {
      "main": [
        [
          {
            "node": "Tiktok [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Linkedin [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Facebook [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Instagram [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Twitter [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Youtube [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Threads [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Bluesky [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Pinterest [BLOTATO]",
            "type": "main",
            "index": 0
          },
          {
            "node": "Update Status to \"Posted\"",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This automation publishes to 9 social platforms daily! Manage your content in a simple Google Sheet. When you set a post's status to "Ready to Post" in your Google Sheet, this workflow grabs your image/video from your Google Drive, posts your content to 9 social platforms, then…

Source: https://n8n.io/workflows/8524/ — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Data & Sheets

Schedule and load content from Google Sheets, then publish videos in parallel across 9 social media platforms.

@Blotato/N8N Nodes Blotato, Google Sheets
Data & Sheets

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
Data & Sheets

YogiAI. Uses googleSheets, googleSheetsTool, httpRequest, stopAndError. Scheduled trigger; 61 nodes.

Google Sheets, Google Sheets Tool, HTTP Request +1
Data & Sheets

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
Data & Sheets

📄 Documentation: Notion Guide

Google Sheets, Google Drive, HTTP Request +2