Automate social media content planning with Llama 3.3 AI, trending topics & Google Suite

How it works:

1. Daily Trigger: Every morning at 8 AM, the workflow is automatically triggered.

2. Fetch Trending Topics: The workflow collects trending topics from external sources, such as news RSS feeds and Reddit popular posts. These trends are merged and summarized to provide up-to-date context for content generation.

3. Read Active Campaigns: The workflow reads all rows from the “Active Campaigns” Google Sheet, but only processes campaigns with a status of "active" to avoid generating content for paused or inactive campaigns.

4. Enrich Campaigns with Trends: Each active campaign is enriched with the latest trending topics, so the generated content can reference current events or popular themes.

5. AI Content Generation: For each enriched campaign, Groq AI generates: - An engaging post caption tailored to the platform and target audience - Creative direction with visual suggestions - Relevant hashtags (5-10) - Best posting time recommendation for the platform

6. Quality Scoring: The workflow calculates a quality score for each generated content idea, considering factors like caption length, hashtag count, and creative direction.

7. Append to Google Sheets: The generated content ideas, along with their quality scores and other details, are appended to the “Daily Content Plan” Google Sheet for record-keeping and team collaboration.