This tutorial covers a comprehensive automation workflow that lets you automatically create and post content across social media platforms, including LinkedIn, Facebook, Twitter, and Instagram. You’ll learn how to generate image carousels, vertical videos with AI voiceovers and captions, and more—all from simple voice notes recorded in Slack. This process leverages tools like Airtable and Make.com to organize, review, and publish posts, creating an efficient and hands-off content pipeline.
Step 1: Record Audio Content in Slack
1. Create a Slack Channel: Set up a dedicated channel (e.g., “Speak to Social”) where you can record audio notes.
2. Record Voice Notes: Use Slack’s recording feature to add voice notes to this channel. You can casually talk about topics you want to cover, such as insights on your industry or tips for your audience.
3. Automation Trigger: Each time an audio note is recorded, an automation in Make.com will initiate the process by downloading the file.
Step 2: Transcribe and Extract Key Points with ChatGPT
1. Download Audio: Make.com will download the audio note from Slack.
2. Transcription: Using OpenAI’s Whisper model, the automation transcribes the audio into text.
3. Extract Key Points: ChatGPT processes the transcription and pulls out the main points, which will later help structure each social media post.
Step 3: Organize Transcriptions in Airtable
1. Create an Airtable Base: Set up a base in Airtable with tables for “Speak” (raw transcriptions) and “Social” (posts for each platform).
2. Link Tables: Connect each transcription entry in “Speak” to the related posts in “Social.”
3. Store Data: The transcription is stored in Airtable, where you can review, edit, and organize each post for different social media channels.
Step 4: Generate Social Media Posts
For each transcription, the automation creates distinct posts for LinkedIn, Facebook, Twitter, and Instagram. Here’s how each type is generated:
1. LinkedIn & Facebook: A straightforward text post is generated using ChatGPT’s summary of the main points.
2. Twitter (X): A separate automation generates concise tweets, possibly breaking down the transcription into multiple posts.
3. Instagram Carousel: ChatGPT condenses the main points into brief sentences, creating a sequence for an image carousel.
4. Instagram Reels: ChatGPT writes a short script for a voiceover, which will be paired with a B-roll video and captions.
Step 5: Approve and Schedule Posts in Airtable
1. Review: In Airtable, review each generated post. You can adjust the text or add notes if needed.
2. Status Updates: Update the status to “Approved” once a post is ready.
3. Automated Scheduling: An Airtable automation checks for approved posts at scheduled intervals (e.g., once a day) and moves them to the “Published” view.
Step 6: Publish Content Across Platforms Using Make.com
1. LinkedIn and Facebook Posts: Simple text posts are sent directly to LinkedIn and Facebook.
2. Instagram Carousel: The automation generates individual images for each slide using a tool like Placid, and then posts the carousel to Instagram.
3. Instagram Reels with Voiceover: 11 Labs generates an AI voiceover from the short script, and Json-to-Video combines it with a B-roll video and captions. The completed video is automatically posted to Instagram.
4. Twitter Post: Each Twitter post is published in a separate process, allowing multiple tweets from one transcription.
Step 7: Monitor and Track Post Status
1. Auto-Mark as Published: Each post’s status is updated in Airtable to “Published” after it goes live.
2. Track Performance: Use Airtable to monitor when each post was created, published, and last modified. This history helps refine future content and automation strategies.
Next Steps
Ready to transform your social media strategy?
Sign up for Make.com
Schedule a free consultation to optimize your setup
Visit Growwstacks for more automation resources
Comments