Content Factory AI Agent

What This Agent Does

This automated content creation workflow transforms trending news into multi-platform content every 8 hours. It monitors Google News RSS feeds, identifies the most relevant trending topics using AI analysis, and automatically generates three types of content: SEO-optimized blog posts, Instagram captions with design suggestions, and TikTok/Reels scripts. All generated content is then organized and saved to a Google Sheet for easy access and scheduling.

Key benefits include:

• Save 10+ hours weekly on content research and creation
• Never miss trending topics with automated 8-hour monitoring cycles
• Maintain consistent posting across multiple platforms without manual effort
• Generate SEO-optimized content that ranks well and drives organic traffic
• Build a content library automatically in Google Sheets for future use

This workflow is perfect for content creators, social media managers, and marketing teams who need to stay current with trends while maintaining a consistent content pipeline across blogs, Instagram, and TikTok.

Who Is It For

This automation agent is designed for:

• Social Media Managers juggling multiple platforms and needing fresh, trend-based content regularly
• Content Creators & Influencers who want to capitalize on trending topics quickly across different formats
• Marketing Teams at small to medium businesses looking to maintain active social presence without dedicated writers
• Bloggers & Publishers seeking to combine SEO blog content with social media promotion
• Digital Agencies managing content for multiple clients and needing scalable content production
• Solopreneurs who need to maximize content output while minimizing time investment

If you're spending hours researching trends, writing blog posts, and adapting content for different platforms, this workflow will transform your content creation process.

Required Integrations

OpenAI

Why it's needed: OpenAI's GPT-4o-mini powers three AI agents in this workflow—the Trend Filter that analyzes news relevance, the SEO Blog Writer that creates long-form content, and both the Instagram Designer and TikTok Script Writer that adapt content for social platforms.

Setup steps:

1. Create an OpenAI account at platform.openai.com
2. Add payment method in Billing settings (GPT-4o-mini is cost-effective at ~$0.15 per million tokens)
3. Generate API key:
   • Navigate to API Keys section
   • Click "Create new secret key"
   • Name it "TaskAGI Content Workflow"
   • Copy the key immediately (it won't be shown again)
4. Configure in TaskAGI:
   • Go to Integrations in your TaskAGI dashboard
   • Select "OpenAI"
   • Paste your API key in the authentication field
   • Click "Test Connection" to verify
   • Save the integration

Important: Store your API key securely. The gpt-4o-mini model provides excellent quality at a fraction of the cost of GPT-4, making this workflow economical even with frequent runs.

Google Sheets

Why it's needed: Google Sheets serves as your content repository, storing all generated blog posts, Instagram content, and TikTok scripts in an organized, accessible format. This allows you to review, schedule, and manage content from a single location.

Setup steps:

1. Create a Google Sheet:

   • Go to sheets.google.com
   • Create a new spreadsheet named "Content Library"
   • Add column headers: Date, Topic, Blog Post, Instagram Caption, Instagram Design Notes, TikTok Script, Source URL
   • Copy the sheet URL from your browser

2. Enable Google Sheets API:

   • Visit console.cloud.google.com
   • Create a new project or select existing one
   • Enable "Google Sheets API" from the API Library
   • Create credentials (OAuth 2.0 Client ID or Service Account)

3. Configure in TaskAGI:

   • Navigate to Integrations → Google Sheets
   • Click "Connect Google Account"
   • Authorize TaskAGI to access your Google Sheets
   • Grant necessary permissions (read and write)
   • Verify connection status shows "Connected"

4. Set sharing permissions:

   • Share your Content Library sheet with the service account email (if using service account)
   • Or ensure your connected Google account has edit access

Configuration Steps

Step 1: Configure the Schedule Trigger

The Every 8 Hours node initiates your workflow automatically.

• Interval: Set to 8 hours (or customize to 4 hours, 12 hours, or 24 hours based on your needs)
• Start time: Configure when you want the first run (e.g., 8:00 AM)
• Timezone: Select your local timezone to ensure runs happen at convenient times

Pro tip: Start with 12-hour intervals during testing, then increase frequency once you're confident in the setup.

Step 2: Set Up Google News RSS Fetch

The Fetch Google News RSS node retrieves trending news articles.

• Method: GET
• URL: https://news.google.com/rss/search?q=[YOUR_TOPIC]&hl=en&gl=US&ceid=US:en
• Replace [YOUR_TOPIC] with your niche (e.g., "artificial intelligence", "digital marketing", "sustainable fashion")
• Headers: Leave default or add User-Agent: TaskAGI/1.0
• Timeout: 30 seconds

Example URLs:

Tech news: https://news.google.com/rss/search?q=technology&hl=en&gl=US&ceid=US:en
Marketing: https://news.google.com/rss/search?q=digital+marketing&hl=en&gl=US&ceid=US:en

Step 3: Configure AI Trend Filter

The AI Agent: Trend Filter analyzes RSS feed data and selects the most relevant topic.

• Model: gpt-4o-mini
• Temperature: 0.3 (lower = more focused and consistent)
• Max tokens: 500
• Prompt structure: The agent receives RSS feed data and filters for:
  • Relevance to your niche
  • Trending potential
  • Content creation viability
  • Recency and newsworthiness

Input mapping: Connect the output from "Fetch Google News RSS" node to this agent's input field.

Expected output: A single selected topic with title, summary, and source URL in JSON format.

Step 4: Configure SEO Blog Writer

The AI Agent: SEO Blog Writer creates comprehensive blog content.

• Model: gpt-4o-mini
• Temperature: 0.7 (balanced creativity and coherence)
• Max tokens: 2000 (adjust based on desired blog length)
• Prompt customization:
  • Specify your brand voice (professional, casual, technical)
  • Define target word count (800-1500 words recommended)
  • Include SEO requirements (keywords, meta description)
  • Set structure preferences (H2/H3 headings, bullet points)

Input mapping: Use the topic output from the Trend Filter as {{topic}} variable.

Output: Full blog post with SEO optimization, headings, and formatting.

Step 5: Configure Instagram Designer

The AI Agent: Instagram Designer creates platform-specific content.

• Model: gpt-4o-mini
• Temperature: 0.8 (higher creativity for engaging social content)
• Max tokens: 800
• Output includes:
  • Hook-driven caption (first line grabs attention)
  • Hashtag strategy (mix of trending and niche tags)
  • Visual design suggestions (colors, layout, imagery)
  • Call-to-action recommendations

Input mapping: Reference the same topic from Trend Filter.

Step 6: Configure TikTok Script Writer

The AI Agent: TikTok Script Writer generates short-form video scripts.

• Model: gpt-4o-mini
• Temperature: 0.8
• Max tokens: 600
• Script format:
  • Hook (first 3 seconds)
  • Main content points (15-30 seconds)
  • Visual cues and transitions
  • Trending audio suggestions
  • Closing CTA

Input mapping: Use the topic from Trend Filter.

Step 7: Set Up Content Formatter

The Format All Content node organizes outputs into a structured format.

• Function type: JavaScript or Python
• Purpose: Combines all AI-generated content into a single object
• Data structure:

{
  date: new Date().toISOString(),
  topic: trendFilter.topic,
  blogPost: blogWriter.content,
  instagramCaption: instagramDesigner.caption,
  instagramDesign: instagramDesigner.designNotes,
  tiktokScript: tiktokWriter.script,
  sourceUrl: trendFilter.sourceUrl
}

Input mapping: Connect outputs from all three content creation agents.

Step 8: Configure Google Sheets Append

The Append to Google Sheets node saves everything to your spreadsheet.

• Sheet URL: Paste your Content Library Google Sheet URL
• Sheet name: Sheet1 (or your custom sheet name)
• Append mode: Add new row
• Column mapping:
  • Column A: {{formatted.date}}
  • Column B: {{formatted.topic}}
  • Column C: {{formatted.blogPost}}
  • Column D: {{formatted.instagramCaption}}
  • Column E: {{formatted.instagramDesign}}
  • Column F: {{formatted.tiktokScript}}
  • Column G: {{formatted.sourceUrl}}

Verification: Ensure column order matches your sheet headers exactly.

Testing Your Agent

Initial Test Run

1. Disable the schedule trigger temporarily (use manual trigger instead)
2. Click "Run Workflow" from the TaskAGI dashboard
3. Monitor execution in real-time through the workflow visualizer
4. Check each node for successful completion (green checkmarks)

Verification Checklist

After Fetch Google News RSS:

• ✅ Verify RSS data was retrieved (check node output)
• ✅ Confirm articles are recent (within last 24-48 hours)
• ✅ Ensure data includes titles, descriptions, and links

After AI Trend Filter:

• ✅ One topic was selected (not multiple)
• ✅ Topic is relevant to your configured niche
• ✅ Output includes title, summary, and source URL

After Content Creation Agents:

• ✅ Blog post is 800+ words with proper formatting
• ✅ Instagram caption includes hashtags and is under 2,200 characters
• ✅ TikTok script has clear hook, content, and CTA
• ✅ All content relates to the selected topic

After Google Sheets Append:

• ✅ New row appears in your spreadsheet
• ✅ All columns are populated correctly
• ✅ No data is truncated or missing
• ✅ Formatting is readable

Expected Results

A successful run should complete in 2-4 minutes and produce:

• 1 new row in Google Sheets
• 1 blog post (800-1500 words)
• 1 Instagram post package (caption + design notes)
• 1 TikTok script (30-60 seconds of content)

Troubleshooting

"RSS Feed Failed to Load"

Cause: Invalid URL, network timeout, or Google News blocking requests.

Solutions:

• Verify your RSS URL in a browser first
• Add a User-Agent header to mimic browser requests
• Increase timeout to 60 seconds
• Try alternative RSS feeds (NewsAPI, Feedly)

"OpenAI API Error: Rate Limit Exceeded"

Cause: Too many requests in short timeframe or insufficient API credits.

Solutions:

• Check your OpenAI usage dashboard for rate limits
• Add billing information if on free tier
• Increase interval between workflow runs
• Reduce max_tokens in AI agent configurations

"Google Sheets: Permission Denied"

Cause: Insufficient permissions or incorrect sheet URL.

Solutions:

• Verify sheet URL is correct (should include /edit)
• Check sharing settings—sheet must be accessible to your connected account
• Re-authenticate Google Sheets integration in TaskAGI
• Ensure service account email (if used) has Editor access

"AI Generated Content is Off-Topic"

Cause: Trend Filter selecting irrelevant articles or prompt needs refinement.

Solutions:

• Narrow your RSS search query (more specific keywords)
• Adjust Trend Filter prompt to emphasize your niche requirements
• Lower temperature on Trend Filter to 0.2 for more focused selection
• Add negative keywords to RSS query (e.g., -politics to exclude political news)

"Workflow Runs But Sheet Stays Empty"

Cause: Data formatting issue or column mapping mismatch.

Solutions:

• Check Format All Content node output structure
• Verify column mapping matches sheet header order exactly
• Test with hardcoded values first to isolate the issue
• Review TaskAGI logs for specific error messages

"Content Quality is Inconsistent"

Cause: Temperature settings too high or prompts too vague.

Solutions:

• Lower temperature to 0.6-0.7 for more consistent output
• Add specific examples in your prompts
• Include brand voice guidelines in system prompts
• Specify exact structure requirements (e.g., "Include exactly 5 H2 headings")

Next Steps

Immediate Actions After Setup

1. Run 3-5 test cycles manually before enabling automated schedule
2. Review generated content quality and adjust prompts as needed
3. Create a content review process (even automated content benefits from human oversight)
4. Set up notifications for workflow failures or errors
5. Document your customizations for future reference

Optimization Suggestions

Enhance Content Quality:

• Add a fourth AI agent for content editing/proofreading
• Include competitor analysis in the Trend Filter prompt
• Create brand-specific style guides in your prompts
• Add sentiment analysis to filter negative news

Expand Functionality:

• Add LinkedIn post generation for B2B content
• Include Twitter thread creation
• Generate Pinterest pin descriptions
• Create email newsletter summaries

Improve Efficiency:

• Implement content deduplication (avoid repeating topics)
• Add keyword research integration (SEMrush, Ahrefs)
• Create conditional logic to skip low-quality topics
• Set up A/B testing for different prompt variations

Scale Your Operation:

• Duplicate workflow for multiple niches
• Add multi-language support for international audiences
• Create separate sheets for different content categories
• Integrate with scheduling tools (Buffer, Hootsuite) for automatic posting

Advanced Usage Tips

Content Personalization: Add variables to your prompts that pull from a database of:

• Brand voice examples
• Target audience demographics
• Seasonal themes or campaigns
• Product/service information

Quality Control Layer: Insert a validation node between content creation and saving that:

• Checks word count minimums
• Verifies required keywords are present
• Ensures proper formatting
• Flags potentially sensitive content

Analytics Integration: Connect your Google Sheet to:

• Google Data Studio for content performance dashboards
• Zapier for cross-platform automation
• Notion for content calendar management
• Slack for team notifications when new content is ready

Cost Optimization:

• Monitor OpenAI usage in the first month
• Adjust max_tokens based on actual needs (you may not need 2000 for every blog)
• Consider switching to gpt-3.5-turbo for less critical content pieces
• Implement caching for repeated API calls

Congratulations! You've now set up an automated content creation machine that works around the clock. Your workflow will continuously monitor trends, generate multi-platform content, and build your content library—all while you focus on strategy, engagement, and growing your audience. Start with the testing phase, refine your prompts based on results, and watch your content production scale effortlessly.