Repurpose blog posts into social content with Gemini, Google Sheets, and Slack
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 9 nodes and runs on a schedule (every day at 07:00). Along the way it connects Google Sheets and Slack. It also calls generativelanguage.googleapis.com over HTTP.
How it runs
Trigger: On a schedule (every day at 07:00).
- Read Blog Feed (RSS Read): reads an RSS feed
- Keep Latest 3 Posts (Code): runs custom JavaScript code
- Set Brand Voice (Edit Fields (Set)): sets 2 fields: brandVoice, hashtags
- Build Content Prompt (Code): runs custom JavaScript code
- Generate Social Posts with Gemini (HTTP Request): calls generativelanguage.googleapis.com (POST)
- Parse Social Posts (Code): runs custom JavaScript code
- Save Drafts to Sheet (Google Sheets): append
- Share Drafts for Review (Slack): uses Slack
Services it uses
HTTP calls to: generativelanguage.googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - RSS Read
n8n-nodes-base.rssFeedRead - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack
From the author
Quick Overview This workflow runs daily, reads your blog RSS feed, uses Google Gemini to repurpose the latest posts into Twitter/X and LinkedIn drafts in your brand voice, then appends the drafts to Google Sheets and posts them to a Slack channel for review.…