Generate weekly content drafts from Google Sheets with Groq AI and Slack
Ready for 3.0What this workflow does
This AI workflow has 19 nodes and runs on a schedule (every week at 09:00). Along the way it connects Google Sheets, Groq Chat Model and Slack.
How it runs
Trigger: On a schedule (every week at 09:00).
- Fetch Content Backlog (Google Sheets): uses Google Sheets
- Order by Deadline (Sort): sorts the items
- Route by Format (Video/Blog/Social) (Switch): routes items into 3 branches
- Generate Blog Outline (AI Agent): runs an AI agent, with model: SEO Strategist LLM
- Generate Video Script (AI Agent): runs an AI agent, with model: Video Producer LLM
- Generate Social Post (AI Agent): runs an AI agent, with model: Growth Expert LLM
- Map Blog Data (Edit Fields (Set)): sets 2 fields: row_id, formatted_output
- Map Video Data (Edit Fields (Set)): sets 2 fields: row_id, formatted_output
- Map Social Data (Edit Fields (Set)): sets 2 fields: row_id, formatted_output
- Sync Parallel Branches (Merge): merges the data from its input branches
…plus 5 more steps. See the full node list below.
Services it uses
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 (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Sort
n8n-nodes-base.sort - Switch
n8n-nodes-base.switch - AI Agent
@n8n/n8n-nodes-langchain.agent - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Edit Fields (Set)
n8n-nodes-base.set - Merge
n8n-nodes-base.merge - Aggregate
n8n-nodes-base.aggregate - Code
n8n-nodes-base.code - Slack
n8n-nodes-base.slack - Split Out
n8n-nodes-base.splitOut
From the author
The Content Calendar Manager > n8n + Google Sheets + Groq AI + Slack Automation This workflow automates your entire content planning process—from idea backlog to AI-generated drafts and team-ready summaries. It runs weekly, fetches pending content ideas…