Marketing Analytics
Role: AI Automation Developer

AI Music & Sports Content Generator with Email Approval

Client: Digital Media Publisher
2 weeks
6 Technologies

Key Measurable Results

Weekly Pack

Researched stories and visuals delivered to the client's inbox automatically

Real-Time

Catches trending music & sports stories while they are still fresh

100%

Client email approval before any content is published

1The Problem

The client publishes weekly music and sports content, but keeping up with breaking news, picking trending stories, writing posts, and creating visuals took hours every week—and by the time assets were finished manually, some stories were already stale.

2What We Built

Built a weekly n8n workflow that scrapes trending posts via Apify, runs live web searches for breaking music and sports news, uses OpenAI to select and write up the best stories, generates matching visuals with an AI image model, saves assets to Google Drive, and emails the weekly pack via Gmail for client approval.

The Tools & How We Used Them

n8n Weekly Trigger & Topic Settings

Runs automatically every week with a configurable settings node at the start so search topics can be updated without editing workflow logic.

Apify + Live Web Search

Combines Apify social scraping with live web search so the workflow captures what fans are talking about right now plus breaking news.

OpenAI + AI Image Generation

OpenAI selects the strongest stories and writes the copy, while an AI image model creates a custom visual for each story.

Google Drive & Gmail Approval Loop

Uploads finished visuals to Google Drive and emails the weekly content pack to the client's inbox so nothing goes out without their sign-off.

How It Works — Step by Step

1

Built a scheduled weekly n8n workflow with an easy-to-edit topic configuration node

2

Combined Apify source scraping with live web searches to gather fresh music and sports stories

3

Used OpenAI to rank stories and write engaging social copy for the week's pack

4

Generated matching visuals automatically, stored them in Google Drive, and sent a Gmail approval digest

✓The Result

Weekly Pack

Researched stories and visuals delivered to the client's inbox automatically

Real-Time

Catches trending music & sports stories while they are still fresh

100%

Client email approval before any content is published

22-Second Walkthrough

See this workflow in action

Watch the 22-second walkthrough showing how this system runs from start to finish.

Skills & Deliverables

n8nApifyOpenAI APIAI Image GenerationGoogle DriveGmail API

Project Details

Our Role

AI Automation Developer

Client

Digital Media Publisher

Industry

Marketing Analytics

Delivery Timeline

2 weeks

Need a similar system built for your team?

Book a free discovery call and we'll map out how to build this for your exact data sources and tools.

More Marketing Analytics Case Studies

View All
Smart Email Campaign Manager: Follow-ups Based on Opens & ClicksVideo

Smart Email Campaign Manager: Follow-ups Based on Opens & Clicks

The client was sending the exact same follow-up email to every lead regardless of what they did with the previous message—someone who clicked a link got the same follow-up as someone who never opened it. Worse, replies were easy to miss, so leads sometimes kept getting automated follow-ups after they had already answered.

View Case Study
AI LinkedIn Content Engine: Posts & Carousels with Owner ApprovalVideo

AI LinkedIn Content Engine: Posts & Carousels with Owner Approval

Publishing strong LinkedIn content every day was taking the founder hours—finding a real source worth writing about, drafting the post, and designing a matching carousel. On busy days nothing went out, yet the owner still wanted 100% final approval before anything was published under their name.

View Case Study
Ecommerce RFM Dashboard: Identified $50k in Churn RisksVideo

Ecommerce RFM Dashboard: Identified $50k in Churn Risks

The business had 693 customers but no clear way to tell them apart. Everyone got the same emails and offers—whether they bought every week or hadn't ordered in almost a year. There was no quick way to see who the best customers were or who had stopped buying.

View Case Study
Social Media Data Stack: Airbyte, Fivetran, BigQuery & dbtVideo

Social Media Data Stack: Airbyte, Fivetran, BigQuery & dbt

The client's analysts were pulling social media data by hand every week—logging into YouTube, Facebook, Instagram, TikTok, and other platforms one by one, exporting CSVs, and pasting numbers into reports. That took 8+ hours every week, and because each platform names and counts metrics differently, reports never matched.

View Case Study
CRM on Autopilot: Daily Lead Pipeline AutomationVideo

CRM on Autopilot: Daily Lead Pipeline Automation

A sales team in Spain was running its entire pipeline by hand. Three people spent their days inside the CRM: checking Gmail to see who had replied, moving leads from one stage to the next, setting follow-up reminders, and fixing contact records. It was slow, error-prone, and the only way to handle more leads was to hire more people.

View Case Study
AI Lead Finder Chatbot (Yelp, Google Maps & US Directories)Video

AI Lead Finder Chatbot (Yelp, Google Maps & US Directories)

Building local business lead lists by hand took hours. To build a single prospect list—like coffee shop owners in Miami—someone had to search Yelp, then Google Maps, then US business directories, and manually open every business's website to hunt for an email address or phone number.

View Case Study
AI Music & Sports Content Generator with Email Approval