🔓 Unlock all 10,000+ workflows & prompts free Join Newsletter →
✅ Full access unlocked — explore all 10,000 AI workflow and prompt templates Browse Templates →
Home › n8n › Workflow
January 22, 2026

Apify to Gmail, competitor Facebook ad reports

Apify to Gmail, competitor Facebook ad reports - n8n workflow automation template
Lisa Granqvist Partner Workflow Automation Expert
Apify to Gmail, competitor Facebook ad reports - n8n workflow automation template
Get a free AI assessment → Get a free AI assessment → ⬇️ Use template

Competitor ad research sounds simple until you’re juggling tabs, screenshots, and “where did I save that?” folders. Then you still have to turn it into something a client (or your boss) will actually read.

Paid media managers feel it first. Agency strategists and in-house growth marketers get dragged into it too. This Apify Gmail reports automation pulls the latest Facebook ads, removes duplicates, and emails a clean creative report without the usual scramble.

You’ll see how the workflow fetches ads, picks the best ones, runs AI analysis on images and videos, and sends a client-ready summary to Gmail.

How This Automation Works

Here’s the complete workflow you’ll be setting up:

n8n Workflow Template: Apify to Gmail, competitor Facebook ad reports

Why This Matters: Competitor Ad Research That Actually Gets Used

If you’ve ever done “quick” competitor research, you know how it goes. You start by checking the Facebook Ads Library, then you copy links into a doc, then you grab a few screenshots “just in case.” Before long you’re sorting ad formats (image vs video), trying to spot repeats, and guessing which creatives are worth talking about. The worst part is the end: packaging it into a report that looks intentional, not improvised. It’s mental load, not just time, and it steals attention from the work that moves results.

It adds up fast. Here’s where it breaks down.

  • Pulling “the latest ads” becomes a weekly rabbit hole because you have no consistent capture process.
  • Duplicates sneak in when the same creative runs in multiple placements or slightly different formats.
  • Video ads rarely get reviewed deeply because downloading and scrubbing them takes forever.
  • Even when you find good examples, you still have to explain what makes them good, which slows handoffs to clients and teammates.

What You’ll Build: Automated Competitor Creative Email Reports

This workflow starts with a simple intake: a user submits their email plus a competitor Facebook Page URL through a form trigger. n8n then calls Apify (via HTTP Request) to scrape the most recent ads from that page, including both images and videos. From there, the workflow routes each ad by media type, builds a unique “key” per creative, and removes duplicates so you’re not analyzing the same concept twice. It caps the final set to the top 5 image ads and top 5 video ads, then runs AI analysis on each. Image ads go through OpenAI Vision (GPT-4) for creative review, while video ads are retrieved, sent to Gemini for analysis, and delayed briefly so processing completes cleanly. Finally, everything is aggregated into a structured report and delivered by Gmail with previews and clear takeaways.

The workflow begins at the form intake, so you can hand it to a teammate or even a client without exposing your backend. In the middle, it cleans and standardizes the ad data, then uses AI to generate consistent evaluations. The end result is a polished email report that reads like a strategist wrote it, not like a spreadsheet got forwarded.

What You’re Building

Expected Results

Say you review one competitor page each week and you typically collect 20 ads. Manually, you might spend about 3 minutes opening each ad, sorting image vs video, and saving references, which is roughly an hour already. Add another hour to remove duplicates, write notes, and format something presentable for email. With this workflow, the “pull + clean + analyze” happens automatically after form submission, and you’re mostly spending about 15 minutes scanning the report and adding your own POV before forwarding it.

Before You Start

  • n8n instance (try n8n Cloud free)
  • Self-hosting option if you prefer (Hostinger works well)
  • Apify to scrape competitor Facebook ad data.
  • Gmail to send the finished email report.
  • OpenAI API key (get it from your OpenAI dashboard).

Skill level: Intermediate. You’ll be connecting credentials, adding API keys as environment variables, and adjusting prompts safely.

Want someone to build this for you? Talk to an automation expert (free 15-minute consultation).

Step by Step

A form submission kicks it off. Someone enters a Facebook Page URL and the email address that should receive the report. That Form Intake Trigger becomes your clean handoff point.

Ads get pulled and sorted. n8n calls Apify through HTTP Request (“Fetch Ad Library”), then splits results into image vs video (“Route Media Types”) so each one follows the right processing path.

Duplicates are removed and the list is capped. The workflow generates a unique key for each creative (Build Image Key / Build Video Key), prunes repeats, and limits the final batch to the top 5 images and top 5 videos. Frankly, this is where most manual workflows fall apart.

AI produces consistent creative insights, then Gmail delivers. Images are analyzed with OpenAI Vision, videos are fetched and analyzed with Gemini after a short wait, and the results are aggregated into a structured summary that’s emailed out via Gmail.

You can easily modify the prompts and scoring criteria to match your brand standards based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Form Trigger

Start the workflow with a form submission that captures the ad library request details.

  1. Add the Form Intake Trigger node as the workflow trigger.
  2. Open Form Intake Trigger and configure the form fields you want to collect (e.g., ad library ID, brand name, campaign dates).
  3. Copy the generated form URL and test a sample submission to ensure the trigger fires.

Step 2: Connect Ad Library Retrieval and Routing

Fetch ad assets and route them into image or video processing paths.

  1. Connect Form Intake Trigger to Fetch Ad Library.
  2. Configure Fetch Ad Library with your ad library endpoint and required headers.
  3. Connect Fetch Ad Library to Route Media Types to split by asset type.
  4. Set rules in Route Media Types so image assets go to Build Image Key and video assets go to Build Video Key.

Credential Required: Connect your HTTP Request credentials in Fetch Ad Library if the ad library requires authentication.

Step 3: Set Up Image Processing and Analysis

Deduplicate, cap results, and analyze image creatives before mapping their fields.

  1. From Build Image Key, pass data to Prune Image Duplicates to remove repeats.
  2. Connect Prune Image Duplicates to Cap Image Results and limit the number of images processed.
  3. Connect Cap Image Results to Inspect Image Content for AI-based image analysis.
  4. Send the analysis output to Map Image Fields to normalize fields before merging.

Credential Required: Connect your OpenAI credentials in Inspect Image Content.

Step 4: Set Up Video Processing and Analysis

Retrieve, analyze, and normalize video creatives using Gemini review steps.

  1. From Build Video Key, pass data to Prune Video Duplicates.
  2. Connect Prune Video Duplicates to Cap Video Results to limit the number of videos processed.
  3. Send the output to Retrieve Video File, then to Send Video to Gemini.
  4. After Send Video to Gemini, insert Delay Processing, then connect to Review Video with Gemini.
  5. Map the reviewed output in Map Video Fields before merging.

Credential Required: Connect your HTTP Request credentials in Retrieve Video File, Send Video to Gemini, and Review Video with Gemini if these endpoints require authentication.

⚠️ Common Pitfall: If Gemini responses are delayed, increase the wait time in Delay Processing to avoid empty analysis results.

Step 5: Merge, Aggregate, and Summarize Ad Data

Combine image and video outputs, aggregate media data, and assemble a unified ad summary.

  1. Connect Map Image Fields and Map Video Fields into Combine Media Outputs.
  2. Send merged results to Aggregate Media Data.
  3. Connect Aggregate Media Data to Assemble Ad Summary to finalize the structured payload.

⚠️ Common Pitfall: The workflow uses multiple set nodes (e.g., Map Image Fields, Map Video Fields, Build Image Key, Build Video Key, Assemble Ad Summary). Ensure each mapping preserves any fields required downstream.

Step 6: Configure AI Insight Generation

Use the AI agent to generate insights and prepare the report content.

  1. Connect Assemble Ad Summary to Insight Agent.
  2. Ensure OpenAI Chat Engine is connected as the language model for Insight Agent.
  3. Keep Structured Parse and Auto-Correct Parser connected to Insight Agent for structured output handling.

Credential Required: Connect your OpenAI credentials in OpenAI Chat Engine. Auto-Correct Parser and Structured Parse are AI sub-nodes, so credentials must be added to OpenAI Chat Engine, not those sub-nodes.

Step 7: Configure the Email Report Output

Send the final AI-generated summary to stakeholders via email.

  1. Connect Insight Agent to Send Email Report.
  2. In Send Email Report, set the recipient address, subject, and message body using data from Insight Agent.

Credential Required: Connect your Gmail credentials in Send Email Report.

Step 8: Test and Activate Your Workflow

Validate end-to-end execution before turning on the workflow.

  1. Use Form Intake Trigger to submit a test request and run the workflow manually.
  2. Confirm that Inspect Image Content and Review Video with Gemini return analysis outputs, and that Assemble Ad Summary builds the final payload.
  3. Verify that Send Email Report sends the report successfully.
  4. Once confirmed, toggle the workflow to Active for production use.
🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Troubleshooting Tips

  • Apify credentials can expire or lack access to the actor you’re using. If things break, check your Apify token and actor permissions in your Apify console first.
  • If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
  • OpenAI (and Gemini) prompts that ship “generic” will give generic analysis. Add your brand voice and what you consider a “winning ad” early, or you will be editing outputs forever.

Next Steps

If your team also needs a faster way to archive examples for later, Apify + Google Drive: clone Facebook ads faster pairs well with this email report so your best finds don’t disappear in inboxes.

For teams doing both creative review and ongoing tracking, Meta Ads to Google Sheets, instant creative scorecards gives you a living scorecard that complements the one-off Gmail report.

When you want to build a swipe file with context over time, Facebook Ads Library to Google Sheets, insights logged keeps every insight searchable instead of buried in threads.

Need the next step after research? Google Drive to Meta Ads Manager, launch ads faster helps you take approved creative and push it toward launch without the usual asset wrangling.

Finally, if you prefer a more formal deliverable, Facebook Ads to Gmail, client-ready PDF reports is a good companion workflow for stakeholders who expect a PDF attachment, not an email-only summary.


Quick reference:

Quick Answers

What’s the setup time for this Apify Gmail reports automation?

About 10–15 minutes if your accounts and API keys are ready.

Is coding required for this competitor ad reporting?

No. You’ll mainly connect services, paste API keys, and tweak prompts.

Is n8n free to use for this Apify Gmail reports workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs (often a few cents per report, depending on how many ads you analyze).

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I modify this Apify Gmail reports workflow for different use cases?

Yes, and you should. Most customizations are in the AI analysis steps (Inspect Image Content, Send Video to Gemini, and Review Video with Gemini) plus the final formatting step (Assemble Ad Summary). Common tweaks include changing what “good creative” means for your niche, adding extra fields from the Apify pull, and adjusting the cap from top 5/top 5 to something like top 3/top 3 for faster reads.

Why is my Apify connection failing in this workflow?

Usually it’s an expired or incorrect Apify API token. Update the credential in n8n and confirm the actor or endpoint you’re calling is accessible for that token. If it fails only sometimes, it can be rate limiting or temporary failures from the source, so add retries and consider a slightly longer Delay Processing wait for the video path.

What volume can this Apify Gmail reports workflow process?

Plenty for weekly competitor reviews.

Is this Apify Gmail reports automation better than using Zapier or Make?

Often, yes, because this workflow has branching (image vs video), deduplication, and multi-step AI processing that’s awkward and expensive in simpler tools. n8n also lets you self-host, which matters when you want unlimited runs or tighter control. Zapier or Make can still be fine for a lightweight “send me alerts” version, but they’re not as comfortable once you’re aggregating data and generating structured reports. If you’re sending these reports to clients, consistency matters, and n8n makes that easier to maintain. Talk to an automation expert if you want help choosing.

Once this is running, competitor creative research stops being a calendar burden and becomes a repeatable system. The workflow handles the repetitive stuff, so you can focus on decisions and testing.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Talk to Automation Expert →

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

×

Use template

Get instant access to this n8n workflow Json file

Copy and import json workflow into your n8n workflow

💬
Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.