Automated Keyword Research Using n8n & DataForSEO

Download the Workflow Files

👉 Google Drive

Want to Go Further?

If you want to learn faster and build advanced automations:

👉 Join the community:
https://link.thesohailjafri.me/join-skool

📺 Free tutorials:
https://www.youtube.com/@ai_with_sohail

💼 Paid consulting / builds:
https://link.thesohailjafri.me/contact-ai

---

What It Does

Drop a keyword into the Input Keywords sheet, and the system automatically:

• Pulls live Google SERP results

• Generates keyword ideas

• Generates keyword suggestions

• Saves data into 3 separate Sheets

• Marks the keyword Completed

• Supports Reset to delete old data and rerun research

---

How It Works (Quick)

1. Google Sheets trigger fires when status = Pending

2. n8n calls DataForSEO APIs:

   • SERP

   • Keyword Ideas

   • Keyword Suggestions

3. Code + Set nodes clean and structure data

4. Results are appended to Sheets

5. Keyword is marked Completed

---

Reset Mode

Change status to Reset and the system:

• Deletes all existing SERP, Ideas, and Suggestions for that keyword

• Sets status back to Pending

• Re-runs the entire workflow cleanly

---

Tech Stack

• n8n – automation, logic, parsing

• DataForSEO – live SERP + keyword APIs

• Google Sheets – trigger, database, output

---

Required Setup

• DataForSEO API credentials

• Google Sheets OAuth connection

---

Why This Is Useful

• One keyword → full research

• Live, accurate data

• Clean Sheets output

• Scalable and repeatable

• Perfect for SEO, niche research, and client work

---

Want to Go Further?

If you want to learn faster and build advanced automations:

👉 Join the community:
https://link.thesohailjafri.me/join-skool

📺 Free tutorials:
https://www.youtube.com/@ai_with_sohail

💼 Paid consulting / builds:
https://link.thesohailjafri.me/contact-ai

---

🤝 My Social Media

- X/Twitter: https://x.com/thesohailjafri
- LinkedIn: https://link.thesohailjafri.me/ig_ai
- GitHub: https://link.thesohailjafri.me/github