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

⚡ 620 views · 📱 Social Media & Email Marketing

💡 Pro Tip — Twitter’s API is paid now, which makes simple data pulls expensive. ScraperNode is a community node that scrapes Twitter profiles and posts without needing API access.

View All Scrapers

Description

✨ 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.
  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

  1. ⏰ Daily Trigger: A Schedule Trigger node activates the workflow every morning at 8 AM.
  2. ✔️ Check for Festivals: The workflow gets today’s date and checks the Google Sheet to see if there is a corresponding festival.
  3. 🎨 Generate Post Options: If a festival is scheduled for the day, Google Gemini generates three distinct and engaging post options for X. Each post is crafted to be concise, use a mix of English and Hindi, and include relevant emojis and hashtags.
  4. 🏆 Select the Best Post: OpenAI’s GPT-4o Mini then evaluates the three generated posts based on criteria like clarity, engagement potential, and effective use of language. It selects the single most impactful post.
  5. 🚀 Publish to X: The winning post is automatically published to your connected X account.

Features ⭐

Prerequisites 🛠️

Before you can use this workflow, you will need to:

How to use this template 🚀

  1. 🔑 Set up Credentials:
    • In n8n, go to the “Credentials” section and add new credentials for Jina AI, Google (for both Sheets and Gemini), OpenAI, and X using the API keys and tokens you obtained.
  2. 📊 Configure the Google Sheet:
    • Create a new Google Sheet. In the first row, create the following headers exactly as written:
      • Name of the Festival
      • Date
      • English Description (Note the trailing space)
      • Hindi Description
    • Open the “Add all Rows at once” and “Fetch Data of Matched Date” nodes in the workflow and connect them to your Google account and select the Sheet you just created.
  3. ▶️ Populate the Data (Manual Step):
    • Click the “Execute workflow” button on the When clicking ‘Execute workflow’ node. This will run the first part of the workflow, filling your Google Sheet with festival data for 2025. This only needs to be done once.
  4. ✅ Activate the Workflow:
    • Save the workflow and then activate it using the toggle at the top right of the n8n canvas.
    • The workflow will now run automatically every day to post about the day’s festival.

Extending the Workflow 💡

🔗 Nodes Used

Google Sheets, HTTP Request, X (Formerly Twitter), Schedule Trigger, Basic LLM Chain, OpenAI Chat Model

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup