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

n8nn8n26 modulesv1.0
Google SheetsFacebookGemini

Stop manually digging through Meta Ads data and spending hours trying to connect the dots. This workflow turns n8n into an AI-powered media buyer that automatically analyzes your ad performance, categorizes your creatives, and delivers insights directly into a Google Sheet. ➡️ Watch the full 4-part setup and tutorial on YouTube: About This 4-Part Automation Series As a media buyer, I built this system to automate the heavy lifting of analyzing ad data and brainst

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
Modules
26
Price
Free
Version
v1.0
Analyze Facebook Ads & send insights to Google Sheets with Gemini AI workflow diagram

About this workflow

Stop manually digging through Meta Ads data and spending hours trying to connect the dots. This workflow turns n8n into an AI-powered media buyer that automatically analyzes your ad performance, categorizes your creatives, and delivers insights directly into a Google Sheet. ➡️ Watch the full 4-part setup and tutorial on YouTube: 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. Benchmark Calculation Aggregates all data to create an overall performance benchmark (e.g., average Cost Per Purchase). AI Analysis A “Senior Media Buyer” AI persona evaluates each ad against the benchmark and categorizes it as “HELL YES,” “YES,” or “MAYBE,” with justifications. Output to Google Sheets Updates your Google Sheet with both raw performance data and AI-generated insights. Who Is It For? E-commerce store owners Digital marketing agencies Facebook Ads media buyers How to Set It Up Credentials Connect your Google Gemini and Google Sheets accounts in the respective nodes. The template uses NocoDB for token management. Configure the “Getting Long-Term Token” and “Updating Token” nodes — or replace them with your preferred credential storage method. Update Your IDs In the “Getting Data For the Past 28 Days…” HTTP Request node, replace actXXXXXX in the URL with your Facebook Ad Account ID. In both Google Sheets nodes (“Sending Raw Data…” and “Updating Ad Insights…”), update the Document ID with your target Google Sheet’s ID. Run the Workflow Click “Test workflow” to run your first AI-powered analysis! Tools Used n8n Facebook for Developers Google AI Studio (Gemini) NocoDB (or any credential database of your choice)

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

Conversational Meta ads reporting & management with GPT-5

Currently Work-In-Progress This n8n template creates an intelligent AI assistant that responds to chat messages, providing conversational access to your Meta Ads data. Powered by an OpenAI GPT-5 model and equipped with memory to maintain context, this agent can interact with your Meta Ads accounts via the Facebook Graph API. Users can ask it to: List all connected ad accounts. Retrieve detailed information for a specific ad account, including active campaigns, ad sets, and individu

Free

Monitor SSL certificate expiry with Google Sheets and multi-channel alert

SSL Expiry Alert System Who is this for? This workflow is ideal for administrators or IT professionals responsible for monitoring SSL certificates of multiple websites to ensure they do not expire unexpectedly. Problem SSL certificates play a crucial role in ensuring secure communication over the internet. However, if not monitored closely, they can expire, leading to potential security risks and service disruption. This workflow helps in proactively monitoring SSL certificate expiry dates. Func

Free

AI client onboarding agent: auto welcome email generator

AI Client Onboarding Agent: Auto Welcome Email Generator Subtitle: From Form Response to Personalized Welcome Email --- 🌍 Overview This workflow automates the client onboarding process. When a new client fills in the Google Form, their data flows into Google Sheets → gets structured → an AI model (Gemini) generates a personalized onboarding email → and finally, Gmail sends it directly to the client. Think of it as your automated client success assistant. --- 🟢 Section 1: Trigger – Capture New Cl

Free

Watch new rows in Google Sheets and append them to a Google Docs document

Automatically track new rows in Google Sheets and append them to a Google Docs document for streamlined data management and documentation.

Free

Add new email addresses from a Google Sheets spreadsheet to your whitelist in Mandrill

Every time a new email address is added to a Google Sheets spreadsheet, Make will automatically add it to your Mandrill whitelist. The template uses this [example spreadsheet](https://goo.gl/loCg1W).

Free

Add Go4Clients SMS messages from Google Sheets new rows

Every time you receive or send an SMS message via Go4Clients, Make will automatically add the message to specified Google Sheets spreadsheet as a new row. The template uses this template spreadsheet

Free

🛻 AI agent for logistics order processing with GPT-4o, Gmail and Google Sheet

Tags: Supply Chain, Logistics, AI Agents Context Hey! I’m Samir, a Supply Chain Data Scientist from Paris, and the founder of LogiGreen Consulting. We design tools to help companies improve their logistics processes using data analytics, AI, and automation—to reduce costs and minimize environmental impacts. >Let’s use N8N to improve logistics operations! 📬 For business inquiries, you can add me on LinkedIn Who is this template for? This workflow template is designed for logistics or manufactu

Free

Service scheduling & route planner for deliveries with Notion, Telegram and Maps

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. 🌸 Graceful Deliveries — Service Scheduling & Route Planner (Notion + Telegram) What this template does Turn new bookings into a graceful, automated delivery plan—with geocoded addresses, a one-tap Google Maps route, owner alerts on Telegram, and sweet pre-arrival updates to your clients (email/SMS). Optional Notion/Sheets logging gives you a beautiful “Delivery Day Planner” you can fi

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