# Automated Keyword Research Using n8n & DataForSEO

## Download the Workflow Files

👉 [**Google Drive**](https://drive.google.com/drive/folders/1bWuUq_B7dbwlwAdm9mNSxDpvdmbgFIkv?usp=drive_link)

## Want to Go Further?

If you want to learn faster and build advanced automations:

👉 **Join the community:**  
[https://link.thesohailjafri.me/join-skool](https://link.thesohailjafri.me/join-skool)

📺 **Free tutorials:**  
[https://www.youtube.com/@ai\_with\_sohail](https://www.youtube.com/@ai_with_sohail)

💼 **Paid consulting / builds:**  
[https://link.thesohailjafri.me/contact-ai](https://link.thesohailjafri.me/contact-ai)

%[https://youtu.be/rOYbV6ILvug] 

![](https://img.notionusercontent.com/s3/prod-files-secure%2Fa00e2ca2-5b4a-41ab-a3ce-9b4d27877600%2Fb90d0702-1251-4ab3-8a8b-2c3ef088917a%2Fimage.png/size/w=2000?exp=1766044203&sig=2AxYK-26sQLuye9bWKfGLWi39GN7UeNxcqrzlqyfCN0&id=2bbacd34-e8b2-8067-b381-f1509afe3556&table=block&userId=79da7959-dda1-47be-9499-b4384caa34ce align="left")

---

## 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](https://link.thesohailjafri.me/join-skool)

📺 **Free tutorials:**  
[https://www.youtube.com/@ai\_with\_sohail](https://www.youtube.com/@ai_with_sohail)

💼 **Paid consulting / builds:**  
[https://link.thesohailjafri.me/contact-ai](https://link.thesohailjafri.me/contact-ai)

---

## 🤝 My Social Media

\- X/Twitter: [https://x.com/thesohailjafri](https://x.com/thesohailjafri)  
\- LinkedIn: [https://link.thesohailjafri.me/ig\_ai](https://link.thesohailjafri.me/ig_ai)  
\- GitHub: [https://link.thesohailjafri.me/github](https://link.thesohailjafri.me/github)