Automate Hundreds of Keywords in Seconds vs. Hours of Manual Work

Stop pasting keywords into ChatGPT one by one. In this video, I show you how to automate your entire SEO Topic Cluster strategy using Make.com and the new Gemini 2.5 Flash model—for less than a penny per run. 👉 Copy the Prompt for Gemini: https://docs.google.com/document/d/1JygZhHMBUtI9dgOBEwysKbJd6V2Tlz5rvxVebK6794M/edit?usp=sharing Most people either burn hours doing this manually or pay $99/month for expensive SEO tools like Surfer or KeywordInsights. Today, we are building a "SaaS Killer" workflow that does the exact same thing, but faster, cheaper, and completely automated. We will move beyond basic loops and use the "Bulk Context Strategy" to process many keywords in a single API call, forcing the AI to return clean JSON data that maps directly into Google Sheets. 📥 Copy the Scenario 👉 https://eu1.make.com/public/shared-scenario/ZkaGnezaEsr/seo-cluster-maker 🔥 IN THIS VIDEO, YOU WILL LEARN: The "Gap Analysis": Why manual ChatGPT prompts are killing your productivity. The "Bulk Context" Trick: How to save thousands of Make.com operations by bundling data. The Build: Step-by-step tutorial on connecting Google Sheets to Gemini 2.5 Flash. The "Green Pill" Fix: How to solve the common Row Number mapping error in Make.com. The Financials: Proof that this workflow costs $0.02 vs. the $99 competitor. ⏱️ TIMESTAMPS: 0:00 The "Money Shot" (Live Demo) 0:45 Why Manual SEO is Dead 1:30 The Logic: Bulk Context vs. Looping 2:15 Step 1: The "Messy" Data Setup 3:45 Step 2: The Gemini System Prompt (JSON Hack) 5:20 Step 3: The "Sandwich Method" (Fixing the Iterator) 6:50 The Result: 65 Keywords Clustered in Seconds 7:30 Cost Breakdown & Final Verdict 🛠️ TOOLS USED: Make.com: (Automation Core) Google Gemini API: (Model: gemini-1.5-flash / 2.0-flash-exp) Google Sheets: (Database) 🏷️ TAGS: #Makecom #SEOAutomation #GeminiAI #TopicClusters #ProgrammaticSEO #NoCode #MatthewZare #KeywordResearch #AIAutomation About the Channel: your guide to a successful care