Automate Weekly SMB Blogs with Perplexity & n8n Workflow

Automate Weekly SMB Blogs with Perplexity & n8n Workflow

Streamline your content creation process with the "Automate Weekly SMB Blogs" workflow using n8n. Designed for small and medium-sized businesses, this powerful automation runs every week, generating fresh blog content from topic suggestion to publication, while you focus on growing your business.

What this workflow does

• Every Friday at 10:00 AM, the workflow activates to ensure your blog remains consistently updated.
• It fetches previously published titles from Supabase to avoid repetition and maintain content diversity.
• Harnesses the power of Perplexity to suggest a new, SEO-optimized blog topic and provides comprehensive research including trends and insights tailored to SMBs.
• Transmits the topic and research to Anthropic Claude, which crafts a complete blog post, complete with title, excerpt, meta description, category, read time, and HTML body.
• Converts the generated text into structured data, generates a URL slug, and readies the post for publication.
• Engages Google Gemini to create an attractive 16:9 cover image, stores it in Supabase Storage, and links the image URL to the post.
• Finalizes by inserting the post into the Supabase blog_posts table with a "published" status and notifies the team through Gmail.

Use cases

• SMB Marketing Teams: Continuously fuel your content marketing strategy with engaging and informative blogs, while minimizing manual workload.
• Content Managers: Maintain a consistent posting schedule seamlessly, ensuring fresh content every week without the usual hassle.
• Automation Enthusiasts: Leverage this detailed workflow to save time, enhance productivity, and guarantee that your content stands out with SEO-friendly topics and visuals.

Technical details

• Integration Tools Used: Supabase, Perplexity, Anthropic Claude, Google Gemini, Gmail
• Nodes Employed: Set, Code, Gmail, Perplexity, Sticky note, HTTP request

Maximize efficiency with the n8n workflow marketplace and take the strain out of your weekly blog posts with this expertly crafted automation. Perfect for n8n users, automation engineers, and SaaS operators looking to enhance their blog content effortlessly.