Automate Ad Banners with Google Drive & n8n Workflow

Transform your ad campaign production with this intelligent n8n workflow that automatically generates multiple banner formats from your source images stored in Google Drive. Perfect for marketing teams who need to produce consistent ad creatives across different sizes without manual resizing work.

What this workflow does

This automation streamlines batch ad banner production using Google Sheets as your job queue. Simply add rows containing your Google Drive file ID, edit instructions, headline, CTA, target banner sizes (300x250, 728x90, 160x600, 320x100, 300x50, 970x250), and output folder. The workflow downloads your source image from Google Drive, optionally refines it using OpenAI's Edit Image node for creative enhancement, then employs sharp library through a Code node to crop and resize images to exact pixel dimensions. All generated banners are automatically uploaded back to Google Drive, with the original Google Sheets row updated with output links, filenames, timestamps, and completion status.

Use cases

• Multi-format campaign deployment: Generate display ads for Google Ads, Facebook, and other platforms requiring specific banner dimensions
• Brand consistency at scale: Ensure uniform visual identity across all ad formats from a single source creative
• Agency workflow optimization: Batch process client campaigns with organized Google Drive folder structures
• A/B testing preparation: Quickly produce multiple banner variations for performance testing

Technical details

Built with essential n8n nodes including Google Drive integration for file management, Google Sheets for job queuing, OpenAI Edit Image node for creative refinement, and Code node utilizing sharp library for precise image manipulation. The workflow uses manual trigger and split in batches functionality for controlled processing. This approach combines AI-powered creative enhancement with deterministic resizing, ensuring exact banner specifications while maintaining creative quality.

Ideal for n8n users, automation engineers, and SaaS operators managing digital advertising workflows who need reliable, scalable banner production without compromising on precision or creative control.