🤖

Automated Content Creation and Publishing Using Slack, Make.com, and Airtable

Jul 11, 2024

Automated Content Creation and Publishing Using Slack, Make.com, and Airtable

Overview

  • Objective: Automate creation and publishing of content to social media platforms (LinkedIn, Facebook, Twitter, Instagram).
  • Tools Used: Slack, Make.com, Airtable, ChatGPT, Placid, 11Labs, Json to Video
  • Outputs: Text posts, image carousels, vertical videos
  • Workflow: Audio note -> Airtable -> Social Media Posts
  • Ease: Engagement with prompts, review and approval before publishing

Steps Overview

  1. Record audio notes in Slack
  2. Create transcription and extract main points using ChatGPT
  3. Add transcription as a row in Airtable
  4. Generate content for different platforms via ChatGPT prompts
  5. Review and approve content in Airtable
  6. Publish approved content automatically

Detailed Steps

1. Record Audio Notes

  • Use Slack to record audio notes casually (even while walking).
  • Prompts used:
    • Statement: "If you want this thing..."
    • Problem: Main problem people face
    • Authority: Why you're the authority
    • Mistake: Biggest mistake people make
    • Better way: Offer better way to achieve it
    • Steps: Steps to achieve it

2. Automation Setup

  • Create new Slack channel for audio notes
  • Make.com scenario:
    • Watch for Slack channel messages
    • Download audio file
    • Transcribe audio with ChatGPT
    • Extract main points
    • Write data to Airtable

3. Airtable Setup

  • Create a base with 2 tables:
    1. Speak: Stores transcriptions
    • Columns: ID, Transcription, Created Time
    1. Social: Stores social media posts
    • Columns: ID, Content, Platform, Type, Status, Created Time, Modified Time

4. Generate Social Media Content

  • Routes in Make.com:
    • LinkedIn and Facebook
      • Create posts using extracted points
    • Twitter/X
      • Extract multiple tweets from transcription
    • Instagram Carousels
      • Summarize transcription into slide points
      • Create images using Placid
    • Instagram Reels
      • Summarize transcription for voiceover
      • Synthesize speech with 11Labs
      • Create video with Json to Video

5. Review and Approval in Airtable

  • Views for different statuses (Review, Approve, Publish, Published)
  • Update status to approve posts for automatic publishing

6. Publishing Automations

  • Scheduled Airtable automation to find approved posts
  • Call Make.com webhooks to trigger publication
  • Publish to respective platforms based on content type
    • Text posts: LinkedIn, Facebook
    • Image carousels: Instagram
    • Videos: Instagram Reels, Twitter/X

7. Closing Notes

  • Further customization and refinement possible
  • Join community for templates and additional resources

Full transcript