AutomationMart
Home/Browse/Analyze Facebook Ads & send insights to Google Sheets with Gemini AI
n8n

Analyze Facebook Ads & send insights to Google Sheets with Gemini AI

n8nn8nv1.0
Google SheetsFacebookGemini

This workflow turns n8n into an AI-powered media buyer that automatically analyzes your ad performance, categorizes your creatives, and delivers insights.

At a glance

Analyze Facebook Ads & send insights to Google Sheets with Gemini AI is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, Facebook, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, Facebook, Gemini
Price
Free
Version
v1.0
Analyze Facebook Ads & send insights to Google Sheets with Gemini AI workflow diagram

About this workflow

About This 4-Part Automation Series As a media buyer, I built this system to automate the heavy lifting of analyzing ad data and brainstorming new creative ideas. This template is the first foundational part of that larger system. ✅ Part 1 (This Template): Pulling Ad Data & Getting Quick Insights Automatically pulls data into a Google Sheet and uses an LLM to categorize ad performance. ✅ Part 2: Finding the Source Files for the Best Ads Fetches the image or video files for top-performing ads. ✅ Part 3: Using AI to Understand Why an Ad Works Sends your best ads to Google Gemini for structured notes on hooks, transcripts, and visuals. ✅ Part 4: Getting the AI to Suggest New Creative Ideas Uses all the insights to generate fresh ad concepts, scripts, and creative briefs. What This Template (Part 1) Does Secure Token Management Automatically retrieves and refreshes your Facebook long-term access token. Fetch Ad Data Pulls the last 28 days of ad-level performance data from your Facebook Ads account. Process & Clean Parses raw data, standardizes key e-commerce metrics (like ROAS), and filters for sales-focused campaigns.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Analyze images and update Google Sheets rows based on filtered results

Us this template to filter Google Sheets rows, analyze images with ChatGPT, and update rows based on results. Streamline data processing and insights.

Free

Add new ActiveCampaign subscribers to a Google Sheets spreadsheet

Every time a new subscriber is added to ActiveCampaign, Make will automatically add that subscriber to a new row in a Google Sheets spreadsheet. If you want to use this template as it is, you need to create a table according to this [example] (https://goo.gl/HofgmG).

Free

Create new vtiger leads from Facebook Lead Ads submissions and retrieve lead details

Automatically convert Facebook Lead Ads submissions into detailed vtiger leads. Capture new leads and retrieve their details for streamlined CRM management.

Free

Generate product mockups with Nano Banana (Gemini 2.5 Flash Image)

This n8n template uses AI to generate product mockups by composing a product image onto a model or template image. This workflow provides a powerful solution for creating dynamic marketing assets and e-commerce visuals. Use cases are many: Instantly create virtual try-on images for apparel, place your product into different scenes for advertisements, or generate custom marketing material without needing a physical photoshoot. Good to know This workflow uses the OpenRouter API to a

Free

Send new Facebook Lead Ads leads to Google Sheets and notify via Slack

Automatically send new Facebook Lead Ads leads to Google Sheets and notify your team via Slack for instant updates and streamlined communication.

Free

Beginner AI dataset generator using OpenAI + LangChain in n8n

This n8n workflow dynamically generates a realistic sample dataset based on a single topic you provide. It uses OpenAI (via LangChain) and n8n’s built-in nodes to: 1. Generate structured JSON data for 5 columns with 3–5 values each 2. Flatten that data into a single text blob 3. Infer meaningful column names via a second AI call 4. Pivot, split, merge, and rename columns automatically 5. Output a clean, labeled dataset ready for export or further processing ---

Free

Extract product info from website screenshots with Dumpling AI + Sheets

What this workflow does This workflow extracts product details—like name, price, discount, and rating— from website screenshots using Dumpling AI. It starts when a new product page URL is added to a Google Sheet, captures a screenshot of that page, extracts visible product info from the image, and writes the results back into the sheet. What problem is this workflow solving? Many product pages block traditional scraping tools or use unstructured layouts. This workflow bypasses HTML limitatio

Free

Classify documents with Gemini and organize them in Google Drive

Who is this for Accountants and office managers who want to automatically classify and organize documents in Google Drive. What this workflow does Retrieves files from a Google Drive inbox folder, classifies each using Gemini 2.5 Flash OCR, then renames, moves, and logs them. Get inbox files → Loop through files → Download file fetches files one by one. Check file type routes PDFs and images to Convert to Base64; unsupported formats go to Handle unsupported format → Send error notification → Log

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free