n8n

How to Automate Google Sheets Social Publishing?

Publish one video to nine social channels from a simple spreadsheet. Built for marketers, creators, and agencies that need consistent daily posts without logging into each app.

A nightly schedule kicks off at a set hour. The workflow reads a row in Google Sheets to grab the video URL and title. It stores all social account IDs in one place, uploads the media to a posting API, then creates posts for Instagram, YouTube, TikTok, Facebook, Threads, Twitter, LinkedIn, Bluesky, and Pinterest. Each post uses the right fields, such as YouTube title or TikTok options. A final step can record results back to Google Sheets for tracking.

Setup is simple if you have a Google Sheets account and an API key for the posting service. Expect a big time win by cutting manual uploads across nine channels, often from two hours to about ten minutes. This is a strong fit for teams running daily or weekly campaigns, batch publishing content, or repurposing shorts across platforms. Follow the steps below and use the Tools Required section to connect accounts and add credentials.

What are the key features?

  • Scheduled run at a set hour using a schedule trigger to post on time every day
  • Reads video URL and title from Google Sheets with OAuth2 authentication
  • Central place to store social account IDs for all channels using a Set node
  • Single media upload to the posting API before creating platform posts
  • Nine HTTP requests to create posts for Instagram, YouTube, TikTok, Facebook, Threads, Twitter, LinkedIn, Bluesky, and Pinterest
  • Platform specific fields supported such as YouTube title and TikTok options
  • Optional log back to Google Sheets to track posting status

What are the benefits?

  • Reduce manual work from 2 hours to about 10 minutes for each video
  • Automate over 90 percent of repetitive posting steps
  • Connect Google Sheets and a posting API to reach nine networks at once
  • Improve caption and title consistency and cut posting errors by 95 percent
  • Handle 10 times more posting volume without adding headcount

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Sheets and Blotato. See the Tools Required section above for links to create accounts with these services.
  3. Prepare your spreadsheet: create a Google Sheet with at least these columns named exactly as used in the nodes: URL VIDEO and Titre. Add a test row with a valid, publicly reachable video URL.
  4. Open the Get my video node. In the Document field, select your Google Sheet. In the Sheet field, pick the correct tab. Save the node.
  5. In the n8n credentials manager, create a new Google Sheets OAuth2 credential. Name it clearly, for example Google Sheets Marketing. Assign it to both Google Sheets nodes.
  6. Create an API key in your posting service account. In each HTTP Request node that calls the posting API, add a header named blotato-api-key and paste your API key as the value.
  7. Open the Assign Social Media IDs node. Replace the placeholder IDs with the real account IDs from your posting service connections for Instagram, YouTube, TikTok, Facebook, Threads, Twitter, LinkedIn, Bluesky, and Pinterest.
  8. Check the Upload Video to Blotato node body. Ensure the url field maps to the URL VIDEO column from your sheet. Keep send body and headers enabled.
  9. Review the YouTube and TikTok nodes. Confirm title maps to Titre and any platform options match how you publish content.
  10. Set the Schedule Trigger to your preferred time. The example uses 22 for the hour. Adjust to your time zone if needed.
  11. Run a test execution. Confirm the Upload Video step returns a media object, and each post node returns a success status. Verify posts appear in your posting service and on the social channels.
  12. Use the final Google Sheets node to record results. Map fields like post IDs or status back to your sheet so you can track what was published.
  13. Troubleshoot common issues: if you see 401 errors, check the API key header. If posts fail, confirm account IDs. If media upload fails, make sure the video URL is accessible and spelled correctly. If the sheet is not found, confirm document and sheet names.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Blotato

Sign up

Starter: $29 / mo (includes Social media API and n8n & Make official nodes)

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.