Multiple updates since last revision

Last updated Jun 26, 2025

How to Build A Content Generation Pipeline


Pipeline Overview: 3 Connected Agents

Each agent is essentially a single prompt connected to specific apps. The magic happens when you chain them together to create a continuous content generation workflow. Here's how the pipeline flows:

TLDR: Build a fully automated content pipeline with 3 connected agents.
Agent 1 discovers trends and posts to Slack.
Agent 2 monitors Slack and creates LinkedIn posts in Google Sheets.
Agent 3 adapts content for X/Twitter, Facebook, and Instagram


🔍 Agent 1: Google Trends → Research → Slack #inspiration

📝 Agent 2: Slack #inspiration → Google Drive guidelines → Google Sheets LinkedIn posts

🌐 Agent 3: Google Sheets LinkedIn → Adapt for X/Twitter, Facebook, Instagram

Agent 1: Trend Discovery & Inspiration

Purpose: Find trending topics in your industry and share them with your team for inspiration.

Apps Connected: Google Trends, Research action, Slack

Agent Prompt:

Find 10 trending topics in digital marketing using Google Trends.

For each trend:
1. Use Google Trends to identify rising search terms from the past 7 days
2. Use the Research action to gather a brief summary of what each trend is about
3. Focus on trends with 50%+ growth in interest

Post a summary to #inspiration Slack channel with this format:

🔥 Weekly Marketing Trends

1. [Trend Name] (+[%] growth)
   Brief explanation from research
   
2. [Trend Name] (+[%] growth)
   Brief explanation from research

[Continue for all 10 trends]

💡 *Team: Which of these could we create content around this week?*

Setup: Create a new agent, connect Google Trends + Research + Slack apps, paste this prompt, set to run every Monday at 9 AM.

Agent 2: LinkedIn Content Creation

Purpose: Monitor #inspiration channel and create professional LinkedIn posts following your copywriting guidelines.

Apps Connected: Slack, Google Drive, Google Sheets

Agent Prompt:

Monitor #inspiration Slack channel for new trend posts from the last 24 hours.

For each trend mentioned:
1. Read the "Copywriting Guidelines" document in Google Drive folder "team-marketing"
2. Create a professional LinkedIn post based on the trend
3. Follow the tone, structure, and style from the guidelines
4. Make posts 150-300 words with clear value propositions
5. Include relevant hashtags and a call-to-action

Add each LinkedIn post to this Google Sheets:
https://docs.google.com/spreadsheets/d/18zQqDkjxduEDjWbfAgomw8Cty5oIAo-hzccrW6DkWFo

Sheet: "LinkedIn"
Add to: First empty row
Columns to fill:
- Content: [Full LinkedIn post text]
- Trend Source: [Which trend from #inspiration]
- Posted: FALSE
- Created At: [Today's date]

Setup: Create a new agent, connect Slack + Google Drive + Google Sheets apps, paste this prompt, set to run every Monday at 11 AM.

Agent 3: Multi-Platform Content Adaptation

Purpose: Take LinkedIn posts and adapt them for X/Twitter, Facebook, and Instagram with platform-specific optimization.

Apps Connected: Google Sheets

Agent Prompt:


Setup: Create a new agent, connect Google Sheets app, paste this prompt, set to run every Monday at 1 PM.

Pipeline Automation & Scheduling

Making Agents Autonomous: For each agent, go to its main page and enable autonomous mode with your chosen schedule. This creates a fully automated pipeline that runs without manual intervention.

Recommended Schedule:

  • 9:00 AM: Agent 1 discovers trends and posts to #inspiration

  • 11:00 AM: Agent 2 creates LinkedIn posts from trends (2-hour gap for processing)

  • 1:00 PM: Agent 3 adapts LinkedIn posts for other platforms (2-hour gap for processing)

Quality Control: Your team can review posts in the Google Sheets before publishing. Set the "Posted" column to TRUE once content is live to prevent duplicate processing.

Expected Results

With this pipeline running every Monday, you'll automatically generate:

  • 10 trending topics researched and shared with your team

  • 3-5 LinkedIn posts following your copywriting guidelines

  • 12-20 total social media posts optimized for each platform

  • Organized content calendar in Google Sheets ready for publishing

This pipeline transforms your content creation from a manual weekly task into an automated system that consistently produces high-quality, trend-based social media content across all major platforms.

ON THIS PAGE

© 2025. All rights reserved. Incredible.one

Manage Cookies

© 2025. All rights reserved. Incredible.one

Manage Cookies

© 2025. All rights reserved. Incredible.one

Manage Cookies