✨ $500 AI Visibility Audit — live at Spurlock Studios. Book the audit

Marketing

Perplexity Shorts Generator | RSS -> Instagram Shorts AI Assistant w/ Perplexity

This n8n workflow reads an RSS feed for AI/automation news. An AI agent, powered by Claude (OpenRouter) and Perplexity, analyzes articles, generates short script outlines and hooks for potential Instagram Shorts, and stores them in a Google Sheet, referencing a database for…

Built · ~4.5 hours saved per week

AI Content Idea & Script Generator for Social Media This workflow automates the creation of short-form video content ideas and scripts by monitoring an RSS feed for relevant news, using an AI agent to research and evaluate the topics, and then populating a content calendar in Google Sheets. Technologies Used - n8n: The automation platform coordinating the entire process. - RSS: Used to ingest new articles and content ideas from a specified news source. - Google Sheets: Acts as a database for content ideas, scripts, and a list of reusable video hooks. - AI (Perplexity & OpenRouter): A sophisticated AI Agent that uses multiple models and tools to perform its tasks. - Perplexity API: Provides real-time, web-connected search and content generation capabilities. - OpenRouter (Anthropic Claude 3.7 Sonnet): The core Large Language Model (LLM) that powers the AI Agent's reasoning and text generation. AI & Automation Value This workflow provides significant value by creating a fully autonomous content ideation and scripting pipeline. It eliminates the manual effort of: 1. Monitoring News: Automatically pulls the latest articles related to a specific niche (AI tools, automation). 2. Vetting Ideas: The AI agent intelligently filters articles, discarding those that are uninteresting or don't fit the content creator's niche. 3. Preventing Duplicates: The AI checks the existing content database (Google Sheets) to ensure it doesn't create scripts for topics that have already been covered. 4. Research & Scripting: Instead of just summarizing, the AI uses Perplexity to conduct fresh, up-to-the-minute research on the topic before outlining a concise script and selecting an appropriate, attention-grabbing hook from a predefined list. 5. Content Management: Automatically logs the approved idea, hook, and script into a Google Sheet, creating a ready-to-use backlog for video production. How the AI Integrates The core of this workflow is the AI Agent node. This is not a simple prompt-and-response; it's an autonomous agent given a mission, a reasoning model (Claude 3.7 Sonnet), and a set of tools to accomplish its goal.

Tags: Marketing, Perplexity, Content Management, Content Creation, Google, AI Assistant

Integrations: RSS, AI Agent, Google Sheets, HTTP

Related automations

Back to the Automation Library