This n8n workflow automates the process of analyzing Facebook (Meta) ads by scraping ads from specified URLs, assessing them with Google’s Gemini AI, and storing structured insights in a Google Sheet. It can be triggered on a schedule or manually, making it ideal for digital marketers, ad analysts, and social media managers who want to efficiently evaluate ad performance and get actionable feedback.

The workflow begins with fetching a list of Facebook Ad Library URLs from Google Sheets, either on a schedule or manually. It then uses the ScrapingFlash API to scrape ad data from each URL, splitting the results into individual ads. To manage costs, it limits processing to the first 10 ads per batch. Each ad’s image and text are sent to Google’s Gemini AI, which analyzes the creative, providing strengths, weaknesses, suggestions for improvement, and a performance score in a structured JSON format.

Finally, the analysis results are appended as new rows in a Google Sheet for easy review and reporting. This automation supports continuous ad performance monitoring, competitive analysis, and creative optimization.

Node Count	11 – 20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.chainLlm, @n8n/n8n-nodes-langchain.lmChatGoogleGemini, @n8n/n8n-nodes-langchain.outputParserStructured, googleSheets, httpRequest, limit, manualTrigger, scheduleTrigger, splitInBatches, splitOut, stickyNote