Ship search campaigns 10× faster. Drop your keywords into Google Sheets, set your brand, USPS & basic settings once, and this n8n workflow builds a Google Ads Editor CSV: Campaign, Ad Groups (auto-clustered), Responsive Search Ads (15/4), Keywords (Phrase & Broad), Sitelinks, Callouts, Structured Snippets, and Location.

Perfect for

• Performance marketers & agencies
• Solo founders launching fast
• Teams standardizing campaign creation across markets

What it does

• Reads Keywords from Google Sheets (1 per row)
• Reads Basic Settings (budget, bidding, languages, locations by geo ID, final URL, paths)
• Reads Brand Settings (brand name, default URL, USPs)
• Builds a Gemini prompt and generates structured JSON
• Parses and converts to Google Ads Editor CSV

Why it’s better

• Zero copy-paste: end-to-end from Sheets → CSV
• Policy-aware assets: clean RSA copy instructions
• Deterministic structure: always Editor-compatible columns
• Editable & modular: all nodes are simple and documented

What’s Included

• n8n workflow (.json) ready to import
• Three example Google Sheets (Keywords, Basic Settings, Brand Settings)
• One Output Example CSV
• Embedded setup notes in the workflow (first note block)
• Minimal code blocks for:
  • Building Gemini prompt
  • Minimal JSON parser
  • CSV row builder (strict sheet-first for locations)

Requirements

• n8n (self-hosted or cloud)
• Google account (to connect Google Sheets)
• Google Gemini API key
• Google Ads Editor (to import the generated CSV)

Setup (5 minutes)

1. Make Copy of Google Sheets (Keywords / Basic Settings / Brand Settings).
2. In Basic Settings, fill:
   • brandName, campaignCountry, finalUrl, path1, path2, budget, biddingStrategy, maxCpc, networks, languages, locations
3. In Brand Settings, fill:
   • brandName, defaultFinalUrl, brandUsps1..4
4. n8n credentials: connect Google Sheets + add Gemini API key.
5. Import the workflow, update the three Google Sheets nodes to your copies.
6. Run → download CSV → import into Google Ads Editor.

Key Features

• Auto Clustering: Groups keywords by intent; optional max per group via adGroupMaxKeywords.
• RSA Assets: 15 Headlines (≤30 char), 4 Descriptions (≤90 char), policy-friendly tone.
• Editor Columns: Campaign, Ad groups, RSAs, Keywords (Phrase & Broad), Sitelinks, Callouts, Snippet, Location.
• Sheet-First Logic: LLM fills gaps, but sheet settings always win for structure.
• Lightweight: Minimal custom code; easy to tweak.