Automate daily Hindu festival posts on X with Google Gemini and GPT-4o Mini 🤖

✨ Automate Daily Hindu Festival Posts on X (Twitter) with AI 🐦

This workflow automates the entire process of creating and publishing culturally rich social media content about Hindu festivals. It starts by building a comprehensive festival calendar for the year in a Google Sheet, then runs daily to post engaging, bilingual updates on X (formerly Twitter). 🗓️

The workflow uses a sophisticated dual-AI system: Google Gemini acts as a content generator creating multiple post options ✍️, while OpenAI's GPT-4o Mini acts as a discerning social media manager, selecting the very best post for publication. 🧠 This ensures your content is not only automated but also high-quality and optimized for engagement.

How it works ⚙️

This workflow operates in two distinct stages:

Part 1: Data Population (One-Time Manual Run)

1. 🔍 Fetch Festival Data: Manually trigger the workflow to scrape a list of 2025 Hindu festivals from a public calendar using the [Jina AI Reader API](https://jina.ai/reader/). 2. ✨ Enrich with AI: For each festival, a Google Gemini model researches and extracts key details: The festival's name in Hindi. A concise description of its significance in English. A Hindi translation of the description. 3. 📝 Store in Google Sheets: The enriched data for the entire year is then systematically organized and saved in a designated Google Sheet, creating a content calendar.

Part 2: Daily Automated Posting