Content gen from Form and Google Sheets

AI-Powered Social Media Content Generation Engine Workflow Overview This workflow automates the entire content creation process, transforming a single idea into a complete, multi-platform social media campaign. It begins when a user submits a primary keyword and target audience via a form. The system then uses a multi-agent AI process to first brainstorm a list of related keywords and then, for each keyword, it finds a relevant source article. Finally, it generates a unique, platform-specific social media post for LinkedIn, Instagram, Twitter (X), and Facebook. All generated content and research are then systematically organized in a Google Sheet, effectively acting as an automated content calendar and research database. Technologies Used - Automation Platform: n8n - AI Services & Models: - OpenAI: GPT-4o Mini (for social media post generation) - Perplexity AI: sonar-pro (for keyword research) and sonar-reasoning via OpenRouter (for article sourcing) - Data Storage: Google Sheets - APIs: Perplexity AI, OpenRouter How AI Creates Value This workflow demonstrates a sophisticated, multi-agent AI system where different AI models are used for specialized tasks, mimicking a human content team. 1. AI as a Strategist (Ideation): Perplexity AI first acts as a keyword strategist, expanding one core idea into dozens of potential content angles. This overcomes creative blocks and ensures a rich pipeline of topics. 2. AI as a Researcher (Sourcing): Perplexity AI then functions as a research assistant, programmatically finding relevant articles for each new keyword, eliminating hours of manual searching. 3. AI as a Content Creator (Generation & Adaptation): The core of the value lies in the OpenAI node. It uses a highly detailed and expertly engineered prompt that makes the AI act as a seasoned social media expert with a specific brand voice (emulating Alex Hormozi). It doesn't just write one generic post; it intelligently adapts the same core insight for four different platforms, respecting their unique formats, tones, character limits, and audience expectations.