XiaoFlow for Google Sheets™ transforms your ordinary spreadsheets into an automated SEO & PPC keyword intelligence powerhouse. Enrich thousands of keywords in bulk with official Google Ads™ monthly search volume, 3-month seasonality trends, low/high CPC bid ranges, competition indices, and search intent classification—with zero scripting required.

Designed specifically for SEO agencies, PPC media buyers, digital marketers, and eCommerce strategists who need to turn messy keyword lists into structured, presentation-ready campaigns.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
🌟 CORE FEATURES & CAPABILITIES
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📊 1. ONE-CLICK BULK KEYWORD ENRICHMENT
• Select any column of keywords in your active Google Sheets™ spreadsheet.
• Instantly append 5 key data columns: Monthly Search Volume, Low CPC, High CPC, Competition Index (0-100), and 3-Month Trend.
• High-performance batch processing handles up to 3,000 keywords per chunk without hitting Google Apps Script™ execution timeout limits.

📐 2. NATIVE SPREADSHEET CUSTOM FORMULAS
Build dynamic, self-updating financial and SEO models using native custom functions:
• =XIAOFLOW_METRICS(A2:A50, "US", "en") — Spills 5 complete metric columns in one go.
• =XIAOFLOW_VOLUME(A2, "US") — Fetches monthly Google™ search volume.
• =XIAOFLOW_CPC_LOW(A2) & =XIAOFLOW_CPC_HIGH(A2) — Returns minimum and maximum bid benchmarks.
• =XIAOFLOW_COMPETITION(A2) — Returns competition index.
• =XIAOFLOW_INTENT(A2) — Classifies intent (Informational, Commercial, Transactional, Navigational).
• =XIAOFLOW_CLUSTER(A2:A20) — Groups keywords semantically.
• Built-in memory caching prevents redundant API quota consumption.

🧩 3. NLP SEMANTIC CLUSTERING & PPC AD GROUP GENERATOR
• Automatically clusters messy keyword lists into tightly themed Campaign and Ad Group hierarchies.
• Intelligent category-modifier breakdown (e.g. Campaign: "earrings", Ad Group: "gold hoop").
• Built-in competitor brand isolation: groups competitor terms into dedicated brand ad groups.
• Generates Google Ads Editor™ ready columns (Campaign, Ad Group, Keyword, Criterion Type: Phrase) for 1-click copy-paste deployment.
• Interactive similarity slider lets you adjust clustering granularity from broad themes to hyper-tight SKAGs (Single Keyword Ad Groups).

⚡ 4. RECURSIVE DEEP BULK DISCOVERY ENGINE
• Input one or more seed keywords and let XiaoFlow recursively discover high-potential long-tail variations across 1 to 10 rounds.
• Set minimum search volume thresholds and custom Include/Exclude filters to filter out irrelevant terms automatically.

🧹 5. FILTER & CONSOLIDATION ENGINE
• Deduplicate raw search query exports from Google Search Console™, Ahrefs, or Semrush.
• Automatically remove zero-volume noise, negative keywords, and unwanted modifiers.
• Sort deliverables cleanly by volume or intent.

🌍 6. GLOBAL TARGETING (100+ COUNTRIES & LANGUAGES)
• Direct integration with Google Ads™ Planner geographic criteria IDs.
• Seamlessly switch target countries (US, UK, DE, FR, JP, AU, CA, etc.) and native languages directly from the sidebar.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
🚀 HOW TO GET STARTED (3 EASY STEPS)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
1. Click "Install" to add XiaoFlow to your Google™ account.
2. Open any Google Sheets™ spreadsheet, click "Extensions" > "XiaoFlow: Bulk Keyword Research Tool" > "🚀 XiaoFlow Quick Control".
3. Enter your XiaoFlow API Key (or use free daily credits), highlight your keyword column, and click "Fetch Selected Keywords"!

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
🔒 PERMISSIONS & SECURITY
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
• Only accesses current spreadsheet data when you explicitly execute an action.
• Safe and secure: Data is retrieved over encrypted HTTPS connections directly from the XiaoFlow API.
• No spreadsheet data is stored, cached, or shared with third parties.

Website: https://www.xiaoflow.com
Chrome Extension: https://www.xiaoflow.com/chrome-extension
API & Documentation: https://www.xiaoflow.com/api

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
TRADEMARK ATTRIBUTION
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Google Sheets™, Google Ads™, Google Search Console™, Google Apps Script™, Google Ads Editor™, and Google™ are trademarks of Google LLC. XiaoFlow is an independent software tool and is not affiliated with, sponsored by, or endorsed by Google LLC.