Automated AI-Driven Weather & Quote Social Media Posting System

📌 Project Overview

A local brand needed a daily social presence without the daily work of building each post.

I built the n8n workflow that pulls live weather, writes a matching quote, designs the image and posts it to Facebook on schedule.

🚩 The Problem

• Manual daily weather post creation was time-consuming

• Inconsistent posting schedule leading to missed days

• Required gathering weather data, writing copy, and designing images

• Inefficient use of time across multiple platforms

📌 Key Impact

✔ Daily content time cut from 30 minutes to zero

✔ Facebook posting runs fully unattended

✔ Weather-accurate, location-specific content every day

✔ Consistent posting schedule with no missed days

✔ Framework reusable for other locations or platforms

💡 The Solution

I designed and implemented a fully automated workflow that generates, designs, and publishes daily Facebook posts using real-time weather data and AI-generated content. The automation retrieves current weather conditions, generates a contextual inspirational quote, dynamically creates a branded image, and publishes the final post automatically on a schedule. This end-to-end system eliminated manual steps while ensuring consistency, relevance, and visual quality.

🛠 Technologies Used

n8n, Google Gemini (AI Text Generation), Weather API (Real-Time Weather Data), HTTP APIs (Dynamic Image Generation), Facebook Graph API (Automated Posting), Google Sheets (Data Logging & Deduplication)

Patrick Cacdac, Automation Specialist