Festival social media automation with Gemini AI for X/Twitter & Facebook

by AppStoneLab Technologies LLP ✓ · 1,938 views · created 2025-07-08 · Social Media, Multimodal AI

What this workflow does

This AI workflow has 17 nodes and runs on a schedule (every day at 08:00). Along the way it connects Google Sheets, X (Formerly Twitter), Facebook Graph API and Google Gemini Chat Model. It also calls generativelanguage.googleapis.com, api.x.com and api.twitter.com over HTTP.

How it runs

Trigger: On a schedule (every day at 08:00).

1. Get Today's Date (Code): runs custom JavaScript code
2. Fetch Data of Matched Date (Google Sheets): uses Google Sheets
3. Prompt Generator (AI Agent): runs an AI agent, with model: Prompt generator model; output parser: Structured prompts
4. Generate Posts (Basic LLM Chain): sends a prompt to an LLM, with model: Post Generator Model; output parser: Structured Posts
5. Generate Image (HTTP Request): calls generativelanguage.googleapis.com (POST)
6. Merge: merges the data from its input branches
7. Convert base64 to Image (Code): runs custom JavaScript code
8. Aggregate: combines items into one
9. Get Media ID for X (HTTP Request): calls api.x.com (POST)
10. Post to Facebook (Facebook Graph API): uses Facebook Graph API

…plus 2 more steps. See the full node list below.

Services it uses

Google SheetsX (Formerly Twitter)Facebook Graph APIGoogle Gemini Chat Model

HTTP calls to: generativelanguage.googleapis.com, api.x.com, api.twitter.com

Before you upgrade to n8n 3.0

Nodes used (12)

• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Schedule Triggern8n-nodes-base.scheduleTrigger
• X (Formerly Twitter)n8n-nodes-base.twitter
• Aggregaten8n-nodes-base.aggregate
• Mergen8n-nodes-base.merge
• HTTP Requestn8n-nodes-base.httpRequest
• AI Agent@n8n/n8n-nodes-langchain.agent
• Facebook Graph APIn8n-nodes-base.facebookGraphApi
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini

From the author

🎉 Festival Social Media Automation with Gemini AI for X/Twitter & Facebook Transform your festival marketing with this comprehensive automation workflow that creates and posts culturally authentic social media content across multiple platforms daily. ⚙️ What…

View the original on n8n.io → Check your own copy