{
  "name": "Automate real-time SEO keyword research with DataForSEO and Google Sheets",
  "nodes": [
    {
      "id": "d42a41fc-2954-40da-aaf8-f3006c35f05c",
      "name": "When clicking ‘Test workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1760,
        240
      ]
    },
    {
      "id": "ebdca890-b195-4a24-a373-52b4872126fd",
      "name": "Add Related KWs",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -608,
        -160
      ]
    },
    {
      "id": "fbeb5071-5b36-45b6-9a91-7cc281f18335",
      "name": "Split Out Related KW",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -816,
        -160
      ]
    },
    {
      "id": "6a029bc6-1542-4d2b-966a-6e965cb34552",
      "name": "Get Related KWs",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1040,
        -160
      ]
    },
    {
      "id": "c984898c-8358-4903-ad61-526c12a6748c",
      "name": "Get SERPs",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1040,
        752
      ]
    },
    {
      "id": "37c8b946-b382-41a0-84cd-9d060b4d8d66",
      "name": "Add SERPs",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -384,
        640
      ]
    },
    {
      "id": "9babbdbe-90ef-4201-9a41-414224ecfeaa",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3344,
        192
      ],
      "parameters": {
        "width": 660,
        "height": 2060,
        "content": "## [n8n Automation] Live-time SEO Keyword Research Tool - Try It Out!\n**This n8n template automates real-time SEO keyword research, delivering comprehensive keyword insights, autocomplete suggestions,"
      }
    },
    {
      "id": "d263f753-61cd-4554-82b3-40aae0c94906",
      "name": "Filter SERPs",
      "type": "n8n-nodes-base.filter",
      "position": [
        -608,
        640
      ]
    },
    {
      "id": "8dbefb90-e4f8-49ae-87ca-51d67bb23ef7",
      "name": "Split Out PAA",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -384,
        848
      ]
    },
    {
      "id": "a3b8466f-6e34-4499-bff0-0c4c3d3a142d",
      "name": "Save Related KWs to All Results",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -384,
        -160
      ]
    },
    {
      "id": "20239242-b7c0-4316-bc1c-40f3195574a7",
      "name": "Get KW Suggestions",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1040,
        48
      ]
    },
    {
      "id": "ee2884cb-3d0f-49a8-b34a-376ed19d46da",
      "name": "Split Out KW Suggestions",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -816,
        48
      ]
    },
    {
      "id": "b7dd1d5b-fde3-4a71-adee-ed15a9894dd4",
      "name": "Add KW Suggestions",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -608,
        48
      ]
    },
    {
      "id": "2b81656f-f882-4bf2-bd3a-33555886c5ab",
      "name": "Save KW Suggestions to All Results",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -384,
        48
      ]
    },
    {
      "id": "49af7591-cb7c-42e8-bf07-0111ce7948f8",
      "name": "Get Autocomplete Suggestions",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1040,
        240
      ]
    },
    {
      "id": "a8d4b550-8817-40b1-a33b-9acfa1026778",
      "name": "Split Out Autocomplete Suggestions",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -816,
        240
      ]
    },
    {
      "id": "25f4b33a-b110-45a8-86a0-0a58099d6e6b",
      "name": "Add Autocomplete Suggestions",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -608,
        240
      ]
    },
    {
      "id": "3e4fa089-c969-4dfd-ab1f-e4d55767fff5",
      "name": "Save Autocomplete Suggestions to All Results",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -384,
        240
      ]
    },
    {
      "id": "8ba91c62-9158-4316-99b6-a07f5d5dc1e3",
      "name": "Get Content Ideas",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1040,
        448
      ]
    },
    {
      "id": "d81b5aa9-87cd-4dac-a7d1-cbdc328c79d3",
      "name": "Split Out Content Ideas",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -816,
        448
      ]
    },
    {
      "id": "9c74b674-cbff-40fd-84c6-47e17e101618",
      "name": "Add Content Ideas",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -608,
        448
      ]
    },
    {
      "id": "1861a175-cf24-4d80-aa09-1bfdcb6c737e",
      "name": "Add Content Ideas to All Results",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -384,
        448
      ]
    },
    {
      "id": "ca3e0fc2-64bd-4cb3-b519-cc4845d2403d",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4000,
        192
      ],
      "parameters": {
        "width": 620,
        "height": 440,
        "content": "## Result Types - Read It First!\n\n**Main Keyword**: Your original list of main keywords with status tracking.\n\n**All Results**: A master log of all relevant keyword and idea research outputs for easy "
      }
    },
    {
      "id": "5856063e-723b-48d9-88e9-16f8818eb70e",
      "name": "Get Main Keywords",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1344,
        240
      ]
    },
    {
      "id": "c789d47d-ae7c-4daa-b49a-eed4b769dd6b",
      "name": "Filter PAAs",
      "type": "n8n-nodes-base.filter",
      "position": [
        -608,
        848
      ]
    },
    {
      "id": "4fca497b-81b1-4eef-baad-16738057c087",
      "name": "Split Out SERPs and PAAs",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -816,
        752
      ]
    },
    {
      "id": "0625cdcd-05d1-4cad-85ad-351596142543",
      "name": "Add PAAs",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -160,
        848
      ]
    },
    {
      "id": "ef182ebe-9cf7-4519-ab39-c59067911c8a",
      "name": "Add PAAs to All Results",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        64,
        848
      ]
    },
    {
      "id": "b3ee7ec7-0f2e-423a-acd9-47d7273686b1",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2640,
        192
      ],
      "parameters": {
        "width": 660,
        "height": 1380,
        "content": "## How To Set Up\n- Download the workflow package and import it into your n8n interface.\n- Duplicate the [**Keyword Research**](https://docs.google.com/spreadsheets/d/1QiaKcy5MwLwmBqD4FrBTd_m3GCK1Jjll9"
      }
    },
    {
      "id": "67b2d673-080d-444c-a854-db8cba84384b",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1840,
        -48
      ],
      "parameters": {
        "width": 720,
        "height": 640,
        "content": "## 1. Set Google Sheet ID & Input Target Keywords\n\n- In n8n, enter the **Google Sheet ID** in the **Set Sheet ID** node. \n- In the connected Google Sheet, for the first tab **Main Keyword**, you manua"
      }
    },
    {
      "id": "3e6bb7a8-c639-44c0-8ebf-45823f95c067",
      "name": "Set Sheet ID",
      "type": "n8n-nodes-base.set",
      "position": [
        -1536,
        240
      ]
    },
    {
      "id": "b9a45021-967b-4b04-85a0-2484c88feea7",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        -336
      ],
      "parameters": {
        "width": 2160,
        "height": 1420,
        "content": "## 2.  Automated Research & Data Collection"
      }
    },
    {
      "id": "41bdfdbb-edee-4bc3-abab-8e32e2dc9679",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        -224
      ],
      "parameters": {
        "width": 1140,
        "height": 200,
        "content": "### 2.1. Get Related Keywords:\n- The workflow sends a **POST request** to the **DataForSEO API** endpoint to directly retrieve an array of related keywords.\n- Then, the array of related keywords is pa"
      }
    },
    {
      "id": "2a0efeaa-9c34-4521-a1d7-034b849cf953",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        0
      ],
      "parameters": {
        "width": 1140,
        "height": 200,
        "content": "### 2.2. Get Keyword Suggestions\n- The workflow sends a **POST request** to the **DataForSEO API** endpoint to directly retrieve an array of keyword suggestions related to your main keyword.\n- This ar"
      }
    },
    {
      "id": "040e0049-bfeb-414d-a20c-e4d003d2cae4",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        224
      ],
      "parameters": {
        "width": 1140,
        "height": 200,
        "content": "### 2.3. Get Autocomplete Suggestions:\n- The workflow sends a **POST request** to the **DataForSEO API** endpoint to retrieve Google autocomplete keyword suggestions for your main keyword.\n- The array"
      }
    },
    {
      "id": "b4cca1a9-38c5-4926-bbc4-78f1b909d8d3",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        448
      ],
      "parameters": {
        "width": 1140,
        "height": null,
        "content": "### 2.4. Get Content Ideas:\n- The workflow sends a **POST request** to the DataForSEO API endpoint to retrieve content ideas and fresh topic suggestions based on your main keyword.\n- The array of cont"
      }
    },
    {
      "id": "86a01202-4a2e-4b6c-9295-98691daf4c3c",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        288,
        640
      ],
      "parameters": {
        "width": 700,
        "height": 380,
        "content": "### 2.5. Get SERPs & PAAs:\n- The workflow sends a **POST request** to the DataForSEO API endpoint, retrieving both the current Google SERP (Search Engine Results Page) data and People Also Ask (PAA) q"
      }
    }
  ],
  "connections": {
    "Add PAAs": {
      "main": [
        [
          {
            "node": "Add PAAs to All Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get SERPs": {
      "main": [
        [
          {
            "node": "Split Out SERPs and PAAs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter PAAs": {
      "main": [
        [
          {
            "node": "Split Out PAA",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter SERPs": {
      "main": [
        [
          {
            "node": "Add SERPs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Sheet ID": {
      "main": [
        [
          {
            "node": "Get Main Keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out PAA": {
      "main": [
        [
          {
            "node": "Add PAAs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Related KWs": {
      "main": [
        [
          {
            "node": "Save Related KWs to All Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Related KWs": {
      "main": [
        [
          {
            "node": "Split Out Related KW",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Content Ideas": {
      "main": [
        [
          {
            "node": "Add Content Ideas to All Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Content Ideas": {
      "main": [
        [
          {
            "node": "Split Out Content Ideas",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Main Keywords": {
      "main": [
        [
          {
            "node": "Get Related KWs",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get KW Suggestions",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get Autocomplete Suggestions",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get Content Ideas",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get SERPs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add KW Suggestions": {
      "main": [
        [
          {
            "node": "Save KW Suggestions to All Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get KW Suggestions": {
      "main": [
        [
          {
            "node": "Split Out KW Suggestions",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Related KW": {
      "main": [
        [
          {
            "node": "Add Related KWs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Content Ideas": {
      "main": [
        [
          {
            "node": "Add Content Ideas",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out KW Suggestions": {
      "main": [
        [
          {
            "node": "Add KW Suggestions",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out SERPs and PAAs": {
      "main": [
        [
          {
            "node": "Filter SERPs",
            "type": "main",
            "index": 0
          },
          {
            "node": "Filter PAAs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Autocomplete Suggestions": {
      "main": [
        [
          {
            "node": "Save Autocomplete Suggestions to All Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Autocomplete Suggestions": {
      "main": [
        [
          {
            "node": "Split Out Autocomplete Suggestions",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Set Sheet ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Autocomplete Suggestions": {
      "main": [
        [
          {
            "node": "Add Autocomplete Suggestions",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}