Content generation and publishing

This workflow automatically generates unique, engaging social media posts with AI-created images and publishes them to Facebook, Instagram, and LinkedIn—all managed through a simple Google Sheet.

Who is it for?

This template is perfect for:

  • Social Media Managers
  • Content Creators and Influencers
  • Marketing Agencies
  • Small Business Owners managing multiple platforms

What it does

  1. Google Sheets Input: Reads your target niche/audience from an "Input" sheet and pulls all previously covered topics from a "Topics" sheet.
  2. Topic Generation: Uses ChatGPT to generate ONE unique, specific topic related to your niche that hasn't been covered before (avoiding duplicate topics).
  3. Topic Research: Uses Perplexity AI to research the topic and create a detailed summary with facts and information.
  4. Router Split: Splits the workflow into three parallel routes for Facebook, Instagram, and LinkedIn.
  5. Post Content Generation: Three separate ChatGPT modules generate platform-specific posts (Facebook, Instagram, LinkedIn) following viral frameworks and best practices for each platform.
  6. AI Image Creation: DALL-E 3 generates a unique, stylized illustration based on the topic (no text, featuring a person engaged in an activity related to the topic).
  7. Image Download: HTTP module downloads the generated image from the DALL-E URL.
  8. Multi-Platform Publishing: Simultaneously posts to Facebook Pages, Instagram Business, and LinkedIn with the AI-generated image and platform-specific caption.
  9. Topic Logging: Adds the newly generated topic to the "Topics" sheet to prevent future duplicates.
  10. Sheet Update: Updates Google Sheet with status and tracking information.

How to set up

  1. Google Sheets Structure:

    • Update Spreadsheet ID in all Google Sheets modules.
    • Create two sheets: "Input" (with your niche/audience in cell A2) and "Topics" (to track covered topics).
    • The "Topics" sheet will auto-populate with generated topics to prevent duplicates.

  2. OpenAI Configuration:

  3. Add your OpenAI API key to all OpenAI modules.

  4. Customize the post generation prompts to match your brand voice and viral frameworks.

  5. Perplexity AI Setup:

  6. Add your Perplexity API key.

  7. Social Media Platform Connections:

  8. Facebook Pages: Connect your Facebook account and select your Page ID.

  9. Instagram Business: Connect your Instagram Business account (requires Facebook connection).

  10. LinkedIn: Connect your LinkedIn account for company or personal page posting.

  11. Customize Image Generation:

  12. In the DALL-E 3 module, adjust the prompt rules to match your visual style preferences.

  13. Customize Post Templates:

  14. Facebook Post: Edit the viral framework example to match your style.

  15. Instagram Post: Customize the caption structure and call-to-action format.

  16. LinkedIn Post: Adjust the professional tone and formatting preferences.

  17. Run the Workflow: Schedule the scenario to run daily/weekly, or trigger manually.

← Previous
Next →