• Sabrina Ramonov
  • Posts
  • 1-Minute AI Automation Turns Youtube Video Into Social Media Posts

1-Minute AI Automation Turns Youtube Video Into Social Media Posts

Content Creation Hack using AI, ChatGPT, and Zapier

Author

Sabrina Ramonov
July 13, 2024

Fun fact:

You can repurpose a Youtube video into multiple social media posts faster than brewing a cup of coffee!

AI automation is a powerful tool for content creators, entrepreneurs, brand builders, and marketers who feel overwhelmed.

In this post, I'll show you how to convert a Youtube video into LinkedIn and Twitter posts using ChatGPT and Zapier.

Here’s the Youtube tutorial accompanying this post:

What type of content do you like best?

Your vote helps me prioritize what content I should make next!

Login or Subscribe to participate in polls.

Table of Contents

Build the AI + Zapier Automation

1. Install Zapier Chrome Extension

Skip this step if you’ve already installed the Zapier Chrome extension.

  • Go to the Zapier Chrome extension page in the Chrome web store.

  • In the upper right, click Add to Chrome.

  • In the dialog box, click Add extension.

  • In your Chrome browser, click the extensions icon in the toolbar.

    In the dropdown menu, click the pin icon next to the Zapier extension.

2. Create a New Zap

  • Create a new Zap.

  • Set 1st step in the zap to “Zapier Chrome Extension”.

  • Select "New Push" as the event.

  • Create these 2 Input Fields:

    • YouTube video URL

    • Transcript

3. Formatter by Zapier:

  • Add a step for "Formatter by Zapier".

  • Choose "Text" as the event and "Truncate" as the transform.

  • Set the max length to 200,000 characters (you may need to lower this value if your text is still too long)

  • Set “Append Ellipsis?” to “true”

4. ChatGPT Writes LinkedIn Post

In this step, we’ll use ChatGPT to write the LinkedIn post, using the Youtube video transcript as the input.

  • Add a step for ChatGPT.

  • Select "Conversation" to send a chat to OpenAI for generating a completion.

  • Connect your ChatGPT account.

  • Use model GPT-4 for better quality output.

  • Fill out the “User Message” and “Assistant Instructions” like this:

  • Grab my ChatGPT prompt for writing linkedin posts from here and paste it into the “Assistant Instructions” field, as shown above

  • Set “Max Tokens” to 4096

  • Set “Temperature” to 0.8 (but I recommend playing around with this)

5. ChatGPT Writes Tweet

In this step, we’ll use ChatGPT to write the tweet, using the Youtube video transcript as the input.

  • Duplicate previous step

  • Change the “assistant instructions” prompt to write a tweet

  • Feel free to use this ChatGPT prompt for writing tweets

6. ChatGPT Write Title

Our workflow only knows the Youtube video URL and transcript. It doesn’t know the Youtube video title.

We could fetch it by calling the Youtube Data API, but I’m trying to reduce the number of external apps and dependencies.

As a shortcut, I use ChatGPT to write a one-sentence title based on the tweet from the previous step.

  • Add another ChatGPT step.

  • Select “Summarize Text” as the event.

  • In the “Text to Be Summarized” field, grab the “Reply” from the tweet writing step and append this instruction:

    • “Your final summary should be one-sentence long, maximum of 12 words”.

  • This title will be used in the Google Sheet output for easy reference.

7. Output to Google Sheets:

Finally, I output the title, URL, date, Linkedin post, and tweet to Google Sheets to facilitate easy editing and review.

I personally do not publish AI-generated content directly to social media platforms, as I want to make sure to add my unique perspective and insights, check for errors, and validate and attribute sources.

But, this is personal preference and highly depends on your use case, resource constraints, comfort level, audience, niche, etc.

  • If you haven’t already, create a Google Sheets spreadsheet with the following columns:

    • Title

    • URL

    • Date

    • LinkedIn Post

    • Tweet

  • In Zapier, add a step for “Google Sheets”.

  • Select event “Create Spreadsheet Row”.

  • Select your Google drive, sheet, and worksheet.

  • Populate the fields using outputs from previous steps, like below:

Test Full Workflow

Choose a Youtube video you want to repurpose for LinkedIn and Twitter.

1. Publish Zap

In Zapier, make sure you’ve tested each step.

Then, hit “Publish” in the top-right corner so that your zap goes live.

You should see your zap when you open the Zapier Chrome extension.

My zap is called “Youtube Transcript → LI/X Posts”.

2. Generate Transcript

Now, we’re ready to test everything!

The first step is to get the transcript of a Youtube video.

There are many ways to do this, but here’s a cost-effective method that doesn't require setting up a Google Developer account, using the YouTube Data API, or paying for another service.

3. Trigger Zap

Next, you’ll trigger the zap.

  • Open the Zapier Chrome Extension

  • Paste the full Transcript

  • Paste the Youtube Video URL

  • Scroll all the way down and click SEND

This triggers the AI-powered Zapier automation you just created.

4. Check Results

The last step is to check results.

In ~1 minute, your Google Sheets should populate with the social media posts written by ChatGPT.

As promised, faster than you can brew a cup of coffee ☕️ 

Here’s a real example:

Sabrina Ramonov @ sabrina.dev

Customization Options

One of the great things about AI + Zapier workflows, and no-code tools in general, is their flexibility and extensibility.

Don’t hesitate to tweak this automation to fit your needs!

Here are common variations:

  • Customize the prompts in ChatGPT to better reflect your writing voice and style. If you don’t already have a prompt you like, I recommend starting here and first changing the writing examples in the prompt.

  • If you use social media management tools, like Buffer, you can add these posts directly to your Buffer queue.

  • If you prefer to publish directly to social media platforms, Zapier offers numerous integrations:

    • LinkedIn: Choose "Create Share Update" to publish directly.

    • Facebook: Publish posts directly to your Facebook page.

    • Instagram: Publish photos with text to your feed.

  • You can even generate AI images for each post by calling OpenAI's DALL-E 3 and optimize the image dimensions for each platform.

[ADVANCED] AI Agent Design Patterns

For those who want to take it a step further, you can introduce AI agent design patterns such as Reflection:

  • Feedback Step: Add a step calling ChatGPT to review the LinkedIn post and provide feedback.

  • Improvement Step: Add another step calling ChatGPT to incorporate this feedback to create an even better post.

Last Thoughts

It’s pretty common for content creators to burn out.

I hope this AI automation helps streamline your process, taking some load off, without breaking the bank by introducing more apps to pay for.

Happy automating!

Did I miss anything?

Have ideas or suggestions?

Message me on LinkedIn 👋 

Sabrina Ramonov

P.S. If you’re enjoying my free newsletter, it’d mean the world to me if you share it with others. My newsletter just launched, every single referral helps. Thank you!