I built a fully automated AI Social Media System that analyzes an article and creates text posts (Twitter, Threads), text and image posts (Linkedin, Facebook, Instagram), and AI avatar video posts (Tiktok).

This system uses AI to automate content creation and posting across platforms:

🔥 Monitors Google Sheets for new articles

🔥 Writes AI social media posts

🔥 Generates AI images

🔥 Generates AI avatar clone videos

🔥 Publish to social media using Blotato.com API

I included multiple different types of content generated (text, image, video), so that you can easily customize this AI system to fit your needs.

Here’s the Youtube video:

Use Cases

‼️But first, I don’t recommend automation if you’re a beginner content creator.

It takes A LOT of trial-and-error to figure out your voice, niche, brand, the value you uniquely provide, how to make great content, etc. This is why I designed Blotato as a hybrid platform: you + AI.

For intermediate and advanced creators, automation is handy for specific use cases:

• Evergreen content - e.g. automatically repurposing the same specific pieces of content or CTA on a weekly basis:

  • lead magnets

  • courses

  • playbooks

  • testimonials

• Brief news updates - e.g. be the first in your industry to share news on DeepSeek

Import Make Blueprint

1. Log into Make.com

2. Go to "Scenarios"‘

3. Click on "Create a new scenario"

4. Click on "Import Blueprint" (top-right corner)

5. Upload my prebuilt Make Blueprint (located at bottom of this post)

Workflow Overview

Here’s how everything works:

1. Google Sheets - Watch Rows

   • Monitors a spreadsheet for new URLs.

   • Triggers the automation when new row is added.

2. HTTP Module - Fetch Content

   • Retrieves the article from the provided URL in the Google Sheet.

3. OpenAI - Extract Article

   • Extracts the text article from the raw HTML. This helps clean up the input for our AI writing prompts.

4. OpenAI - Create Content

   • Write posts for LinkedIn, Twitter, Threads, Facebook, Instagram.

   • Generate AI image prompt, then generate AI image with DALLE-3.

   • Write AI video script and caption for AI avatar video for Tiktok.

5. Blotato - Automated Posting

   • Publish content to social media platforms via Blotato API.

Setup Google Sheets

My Google Sheet is super simple. I just drop in an article URL, and the entire automation runs. You can easily switch this to Airtable, Notion, Slack, etc. depending on your flow.

1. Make a new Google Sheet

2. Create a column with header URL

3. Connect the Google Sheet to Make

   • Select the correct spreadsheet ID and sheet name

   • Enable "Includes Headers"

Setup Blotato

Next, you’ll need to setup your Blotato API Key and Account IDs:

• Login to Blotato.com

• Go to “Settings”

• Copy your API key and account IDs

• Paste them into the Make node “Setup Social Accounts”

Setup Heygen

Check out my previous in-depth tutorials on setting up your AI Clone.

You’ll need to sign up for Heygen’s API plan, which is separate from their web app.

Within Make, select your Heygen avatar and voice.

Test Everything

After setting up your accounts and connecting them in Make, run the scenario with a real article URL, so that you have sample data flowing through the system.

⚡️ You don’t need to change anything else to get the system working!

I also recommend testing one branch at a time.

Simply UNLINK the other branches, while you isolate testing one branch. When done, link all branches back to the main router.

⚠️ Common troubleshooting issues:

• If posts fail to publish, check your API key and Account IDs.

• If your Make variables appear transparent with a colored border, run the scenario once so you have data flowing in the system.

• If your avatar video is not generated, most likely you need to upgrade to a paid Heygen API plan OR increase the wait timeout.

Make Blueprint

Once configured, this AI Social Media System will:

• Pull content from Google Sheets

• Use AI to write social media posts

• Use AI to generate images and avatar video

• Post automatically to all major platforms

Here’s the Make blueprint: