5,260,421 AI resources indexedWorking toward the world’s largest AI resource index.

Browse resources 12 sections
PDF

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

Research & reporting workflow for n8n with 26 active steps. Starts with Manual Trigger. Uses Google Gemini. Integrations include Google Gemini, Google Sheets.

By JJ ThamWorkflowReference information

What it does

26 active nodes · Starts with Manual Trigger.

Steps in the template include:

  • When clicking ‘Test workflow’ (Manual Trigger)
  • Stringify Everything (Code)
  • Google Gemini Chat Model (Google Gemini Chat Model)
  • Structured Output Parser (Structured Output Parser)

Nodes and integrations

  • Manual Trigger
  • Code ×7
  • Google Gemini Chat Model
  • Structured Output Parser
  • Split Out
  • Google Sheets ×2
  • NocoDB ×2
  • HTTP Request ×2
  • Edit Fields (Set) ×3
  • Sort
  • Filter
  • Basic LLM Chain
  • Merge
  • If
  • Aggregate
See the author’s step names
  • When clicking ‘Test workflow’ (Manual Trigger)
  • Stringify Everything (Code)
  • Google Gemini Chat Model (Google Gemini Chat Model)
  • Structured Output Parser (Structured Output Parser)
  • Split Out (Split Out)
  • Sending Raw Data To A Google Sheet (Google Sheets) — appendOrUpdate
  • Getting Long-Term Token (NocoDB) — getAll
  • Does it Need A Token Refresh? (Code)
  • Getting Long-Lived Access Token1 (HTTP Request)
  • Calculating End Date of Token1 (Code)
  • Updating Token (NocoDB) — update
  • Getting Long-Term Token1 (Edit Fields (Set))
  • Splitting Out In Table Format (Code)
  • Sorting Based on Spends (Sort)
  • Filtering Only For Sales Campaigns (Filter)
  • Getting Data For the Past 28 Days Segemented Per Campaign Adset and Ad (HTTP Request)
  • Senior Facebook Ads Media Buyer (Basic LLM Chain)
  • Combining Ad Data and Benchmarking Data (Merge)
  • Updating Ad Insights Into Google Sheets (Google Sheets) — update
  • Does Token Needs Refreshing? (If)
  • Extracting Long Term Token (Edit Fields (Set))
  • Calculate Account Benchmarks (Code)
  • Stringify Benchmark Data (Code)
  • Aggregate Metrics by Ad Creative (Code)
  • Combine Ad & Benchmark Data for LLM (Aggregate)
  • Extracting Access Token (Edit Fields (Set))

Accounts and credentials

  • Google Gemini access
  • Google Sheets

Credential types in the graph: googlePalmApi, googleSheetsOAuth2Api, nocoDbApiToken

Check the HTTP request steps for any additional service accounts or API keys.

AI models and swaps

Google Gemini · Chat

models/gemini-2.5-pro-preview-06-05 in Google Gemini Chat Model. Potentially swappable with a compatible n8n chat model node. Match structured output before testing.

Resource information

Credit basis
Author listed by n8n
Pricing
Template access shown on n8n
License
Not specified
Last record update
Nov 5, 2026