Generate weekly content drafts from Google Sheets with Groq AI and Slack

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 from Google Sheets, generates platform-specific content using AI (blogs, videos, social posts) and delivers a clean summary to Slack while updating statuses in your sheet.

Quick Implementation Steps

1. [Connect credentials for Google Sheets, Slack and Groq API in your n8n account](https://n8n.partnerlinks.io/om1efg2qgvwi). 2. Update the Google Sheet ID and Sheet Name in the "Fetch Content Backlog" node. 3. Ensure your sheet has columns: Sr No, Topic, Type, Status, Deadline. 4. Set your Slack Channel ID in the "Post Summary to Slack" node. 5. Test with sample rows (Status = idea or writing). 6. Activate the workflow.

What It Does

This workflow acts as a smart content operations assistant. Every week, it scans your content backlog stored in Google Sheets and identifies items that are either in the "idea" or "writing" stage. It then prioritizes them by deadline and processes them accordingly.

Based on the content type (Blog, Video or Social), the workflow routes each idea into specialized AI agents powered by Groq. These agents generate structured outputs such as blog outlines, video scripts or social media briefs—each tailored to its format and purpose.