Automate Your Entire SEO Keyword Search (FREE n8n Template)

👥 Join the top Skool community to earn from AI: https://link.thesohailjafri.me/join-s... 🚀 Ai Automation Consulting Website → https://ai.thesohailjafri.me/ Contact → https://cal.com/thesohailjafri/ai-dis... 👇 Free Workflow Guide + Resources Shown In Video: https://blog.thesohailjafri.me/automa... ⭐ Description Turn any keyword into hundreds of actionable SEO data points using a low-cost, credit-based automation. In this video, Soil walks you step by step through building a keyword research system that pulls SERP data, keyword ideas, and keyword suggestions directly into Google Sheets—without expensive tools like Ahrefs or SEMrush. You’ll learn how to use DataForSEO with an automation workflow to trigger research based on keyword status, manage resets cleanly, batch-delete data to avoid API limits, and save everything in a structured, reusable format. Perfect for SEO professionals, bloggers, and automation builders, this setup lets you embed keyword research directly into your own workflows while paying only for what you use. If you want scalable, automation-friendly keyword research at a fraction of the usual cost, this tutorial shows you exactly how to build it from scratch. 🕒 Chapters Of Video 00:00 - Introduction to low-cost keyword automation 00:32 - Keyword setup and Google Sheets overview 01:06 - Workflow execution and trigger timing 01:45 - Using DataForSEO as the data source 02:51 - Cost breakdown and keyword data results 03:32 - Automation logic: pending vs completed 04:01 - Workflow triggers and filters explained 05:02 - Handling keyword reset automatically 06:09 - Overview of full automation architecture 06:44 - Creating a new automation workflow 07:02 - Getting DataForSEO API key and credits 08:12 - Installing DataForSEO community node 09:04 - Google Sheets triggers configuration 10:01 - Filtering keywords by status 11:54 - Fetching SERP, ideas, and suggestions 13:21 - Extracting and formatting nested data 15:00 - Saving results to Google Sheets 16:01 - Marking keyword research as completed 17:13 - Reset workflow and batch deletion logic 18:31 - Verifying reset and cleanup process 22:09 - Debugging node configuration issues 23:14 - Final results and automation recap 🍻 About me: Sohail Jafri. I automate everything that solopreneurs need for lead generation, content automation, closing high-ticket clients, and scaling using AI and Automation Tools 🤝 Catch me here X/Twitter: https://x.com/thesohailjafri LinkedIn: https://link.thesohailjafri.me/ig_ai GitHub: https://link.thesohailjafri.me/github Blog: https://link.thesohailjafri.me/blog Skool community: https://link.thesohailjafri.me/join-s... 🎥 My Creator Gear Recording Cam: Pixel 7 Mic Setup: Hollyland Lark M2 Editor: DaVinci Resolve/CapCut/Loom 🎯 Hashtags & Keywords --- #n8n #automation #ai #aiagent #nocode #freetemplate #n8nproject #aiproject #aiagentproject