Automated Meta Ad Analysis and Data Storage Workflow

This n8n workflow automates the process of scraping Facebook Meta Ad Library for image ads, analyzing the retrieved data and images using OpenAI’s AI models, and storing the results in Google Sheets for further review. It begins with a manual trigger for testing, then configures settings and cleans up prompts for clarity. The workflow scrapes ad data via Apify’s HTTP request node, filters and limits the number of image ads, and calculates their runtime metrics. The images are downloaded and stored securely on Google Drive while being analyzed for content description and categorization through OpenAI’s language and image analysis nodes. The analyzed data, including structured information about the ads and images, is merged and finally stored in Google Sheets. This workflow is ideal for marketing teams, digital advertisers, or social media analysts seeking to monitor ad campaigns, understand creative strategies, and generate data-driven insights automatically.