Automate LinkedIn Posts: RSS to Google Sheets with OpenAI

Automate LinkedIn Posts: RSS to Google Sheets with OpenAI

Streamline your LinkedIn content creation with this powerful n8n workflow that intelligently reads your RSS feed, evaluates content relevance with OpenAI, and crafts engaging LinkedIn posts. By automating these steps, you save time and ensure your social media stays active with high-quality content tailored to your audience.

What this workflow does

• Triggers automatically every day at 7:00 AM to start the process.
• Reads the newest articles from your specified RSS feed, focusing only on the content published in the last 24 hours.
• Restricts to the first five articles to efficiently manage processing load.
• Utilizes OpenAI to assess and score each article's niche relevance on a scale from 0 to 10, capturing only those with a score of 7 or higher.
• Generates compelling LinkedIn post drafts based on the article's content, tailored angle, and expert hot take.
• Logs the drafts along with relevant metadata into a Google Sheets "Drafts" tab for seamless review and records maintenance.
• Instantly alerts your specified Slack channel, ensuring your team is notified and ready to review the drafts.

Use cases

• Content Managers: Ensure daily posts with minimal manual intervention while maintaining high relevance to your niche.
• SaaS Operators: Keep your audience engaged with regular, high-quality content without dedicating valuable time to content curation.
• Automation Engineers: Leverage this n8n workflow to streamline your LinkedIn content strategy and showcase automation capabilities to clients.

Technical details

• Core Integrations: RSS Feed Read, OpenAI, Google Sheets, Slack
• Key Nodes: Set, Limit, Filter, Sticky Note
• Set-Up Requirements:
  • Configure OpenAI credentials and customize prompts for audience and voice.
  • Establish Google Sheets with OAuth credentials and a properly formatted "Drafts" sheet.
  • Add Slack credentials and update the target Slack channel ID for notifications.
  • Replace the default RSS feed URL with your preferred source for content.