{
  "name": "Comprehensive SEO keyword research & analysis with DataForSEO and Airtable",
  "nodes": [
    {
      "id": "7613b783-7f7e-4299-90f7-46ffd266eca3",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1488,
        1024
      ],
      "parameters": {
        "width": 640,
        "height": 320,
        "content": "## Get Primary Keyword from Airtable\nAirtable triggers the workflow with send data automation to n8n. \n\nGet airtable record gets the fields for D4SEO api enpoints. Fields are set for use later in work"
      }
    },
    {
      "id": "2f87d091-2c02-4ac8-8a3e-394530d2c3f6",
      "name": "Related API Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        80,
        144
      ]
    },
    {
      "id": "d8cb4966-58c1-4a77-87d3-e5dd51830d4b",
      "name": "Get Primary Keyword",
      "type": "n8n-nodes-base.airtable",
      "position": [
        -1008,
        1168
      ]
    },
    {
      "id": "50301d86-1244-44be-a9d5-adaf87a43889",
      "name": "Split Out Result Items",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        304,
        144
      ]
    },
    {
      "id": "3acbffe2-88aa-45f1-827e-fe7c2b1a2415",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "width": 760,
        "height": 320,
        "content": "## Get Related Keywords from DFSEO and Create Airtable Records in the Master All Keyword Variations table.\n\n"
      }
    },
    {
      "id": "e560f396-0d9a-4dde-a21b-e414480194dc",
      "name": "KW Suggestions API Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        80,
        464
      ]
    },
    {
      "id": "efe6fb34-93fd-4e38-bdd0-5840e11b3910",
      "name": "Split Out Suggested KWs",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        304,
        464
      ]
    },
    {
      "id": "afee46f9-578c-4c58-b3ec-269e8138446a",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        368
      ],
      "parameters": {
        "width": 760,
        "height": 300,
        "content": "## Get Keyword Suggestions from DFSEO and Create Airtable Record\n\nNote: Some API data is hardcoded for now."
      }
    },
    {
      "id": "cf463908-0b29-4fac-8c6d-5990db91435a",
      "name": "KW Ideas API Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        80,
        800
      ]
    },
    {
      "id": "0d2b0ae3-593a-403e-9806-9e6ef3dd4c6f",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        704
      ],
      "parameters": {
        "width": 760,
        "height": 300,
        "content": "## Get Keyword Ideas from DFSEO and Create Airtable Record\n\nNote: Some API data is hardcoded for now."
      }
    },
    {
      "id": "ea998f74-0503-4eac-99c4-43ae909005ef",
      "name": "Split Out Autocomplete",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        304,
        1152
      ]
    },
    {
      "id": "4a3d1aed-5ae8-4dc2-ad49-6d4727b53ad4",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        1040
      ],
      "parameters": {
        "width": 760,
        "height": 300,
        "content": "## Get autocomplete from DFSEO\n\n"
      }
    },
    {
      "id": "30d2e6bc-6780-4e9c-8e71-804c0a6131a4",
      "name": "Serp API Request1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        64,
        1488
      ]
    },
    {
      "id": "e1cde771-c7d3-43de-9eb3-dcf7db8ad864",
      "name": "Autocomplete API Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        80,
        1152
      ]
    },
    {
      "id": "fe954aea-a56c-4e2f-8a14-13f9fa10cf8e",
      "name": "Split Out SERP",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        304,
        1488
      ]
    },
    {
      "id": "e5543b46-9885-4ca9-81bc-94306862f8f6",
      "name": "Create SERPS",
      "type": "n8n-nodes-base.airtable",
      "position": [
        928,
        1488
      ]
    },
    {
      "id": "f6996d46-ffb6-4f30-891f-30ce9e20d7a5",
      "name": "Split Out People Also Ask",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        720,
        1664
      ]
    },
    {
      "id": "0037579e-624c-42ae-8b5c-8b23bdb5a27a",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        1392
      ],
      "parameters": {
        "width": 1080,
        "height": 440,
        "content": "## Get SERP from DFSEO for SERP Results and People Also Ask\n\nNote: SERP depth hardcoded to 25 and people also ask depth set to 1."
      }
    },
    {
      "id": "7e099806-6903-44d3-86cf-db10fe6ffd43",
      "name": "Generate Subtopics API Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        64,
        1968
      ]
    },
    {
      "id": "169de71d-76d6-43c0-89c3-18e7b08889ed",
      "name": "Split Out Subtopics",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        320,
        1968
      ]
    },
    {
      "id": "081338f0-f25e-453b-9fe8-993cf4856845",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        1872
      ],
      "parameters": {
        "width": 780,
        "height": 300,
        "content": "## Get Subtopics from DataForSEO\n\nNote: Some API data is hardcoded for now."
      }
    },
    {
      "id": "f40f7411-f3e8-489b-b3f0-4ef46da83b46",
      "name": "Set Fields for API Request",
      "type": "n8n-nodes-base.set",
      "position": [
        -608,
        1168
      ]
    },
    {
      "id": "bebc2273-1b80-4d96-b6a6-8e109c57ee32",
      "name": "Set KW Suggestion Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        512,
        464
      ]
    },
    {
      "id": "4c107e0d-97eb-4b7f-9605-b158d1806224",
      "name": "Set KW Related Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        512,
        144
      ]
    },
    {
      "id": "7eac52e7-a686-4226-b98e-7c7a50320443",
      "name": "Split Out KW Ideas",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        304,
        800
      ]
    },
    {
      "id": "9d87c94b-8da5-44aa-9346-067ba6370d54",
      "name": "Set Keyword Ideas Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        512,
        800
      ]
    },
    {
      "id": "03e057ab-4ed8-497b-9e09-ee2545b1d444",
      "name": "Set Autocomplete Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        512,
        1152
      ]
    },
    {
      "id": "f84a649a-ff99-4fe2-90dd-edad5865d89c",
      "name": "Set SERP Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        704,
        1488
      ]
    },
    {
      "id": "0cac24b9-eefd-4ec5-8a16-5a1978d1da7b",
      "name": "Set PAA Fileds",
      "type": "n8n-nodes-base.set",
      "position": [
        928,
        1664
      ]
    },
    {
      "id": "f28b1467-1257-4b97-a77a-8c3c5145ca40",
      "name": "Set Generate Subtopics Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        544,
        1968
      ]
    },
    {
      "id": "26c3e0c3-5902-4c0a-8c61-c96bae0099ba",
      "name": "Airtable",
      "type": "n8n-nodes-base.airtable",
      "position": [
        0,
        2304
      ]
    },
    {
      "id": "b1afe7a0-5103-4288-b08a-6974af8d8815",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2080,
        864
      ],
      "parameters": {
        "width": 540,
        "height": 1220,
        "content": "# Setup \n\n## 1. Copy this Airtable base: [KW Research Content Ideation](https://airtable.com/apphzhR0wI16xjJJs/shrsojqqzGpgMJq9y)\n## Important: Copy the base. Please do not ask for access. \n## 2. Set "
      }
    },
    {
      "id": "f7937b9e-a913-4b19-bcd0-58073575ad6f",
      "name": "Set Airtable Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        -1232,
        1168
      ]
    },
    {
      "id": "7deec2ca-7ec8-4fc2-b742-aa0b6295d5ac",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        784,
        0
      ],
      "parameters": {
        "width": 260,
        "height": 320,
        "content": "## Add to Master All KW Variations table.\n"
      }
    },
    {
      "id": "62451803-acb2-4fa8-8d7f-c4175555edce",
      "name": "Add Related KWs to Master Table",
      "type": "n8n-nodes-base.airtable",
      "position": [
        864,
        144
      ]
    },
    {
      "id": "ff23feaf-f51a-4d1f-8153-f5e2a7e58e7a",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        784,
        368
      ],
      "parameters": {
        "width": 260,
        "height": 300,
        "content": "## Add to Master All KW Variations table.\n"
      }
    },
    {
      "id": "89eeb233-f403-4aab-819e-02ef62f8edaf",
      "name": "Sticky Note11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        784,
        704
      ],
      "parameters": {
        "width": 260,
        "height": 300,
        "content": "## Add to Master All KW Variations table.\n"
      }
    },
    {
      "id": "8285997a-5bd2-4c62-ae11-02fff7678436",
      "name": "Add KW Suggestions to Master table",
      "type": "n8n-nodes-base.airtable",
      "position": [
        864,
        464
      ]
    },
    {
      "id": "f85c31e7-e5b1-4e82-92ae-8f935fb2edd6",
      "name": "Add KW Ideas to Master table",
      "type": "n8n-nodes-base.airtable",
      "position": [
        864,
        800
      ]
    },
    {
      "id": "54d98218-3f1e-482d-b5d2-303952e0bdfb",
      "name": "Sticky Note12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        784,
        1040
      ],
      "parameters": {
        "width": 260,
        "height": 300,
        "content": "## Add to Master All KW Variations table.\n"
      }
    },
    {
      "id": "319537e0-1a78-48ae-b0be-7b80eaa9eaf8",
      "name": "Add Autocomplete to Master table",
      "type": "n8n-nodes-base.airtable",
      "position": [
        864,
        1152
      ]
    },
    {
      "id": "fc2c7e15-7ed1-4659-a714-ad971e009d93",
      "name": "Filter SERPs",
      "type": "n8n-nodes-base.filter",
      "position": [
        528,
        1488
      ]
    },
    {
      "id": "c00a926d-c89f-409f-b50f-5a8a7681802c",
      "name": "Filter PAA",
      "type": "n8n-nodes-base.filter",
      "position": [
        528,
        1664
      ]
    },
    {
      "id": "0ee130c4-4526-448f-ba6a-4425d6518d58",
      "name": "Sticky Note13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1152,
        1520
      ],
      "parameters": {
        "width": 260,
        "height": 300,
        "content": "## Add to Master All KW Variations table.\n"
      }
    },
    {
      "id": "44e0ccde-399a-44c2-9a7f-0fa082eb0b13",
      "name": "Add PAA to Master Table",
      "type": "n8n-nodes-base.airtable",
      "position": [
        1200,
        1648
      ]
    },
    {
      "id": "638fcf15-05b1-479d-938a-2c3b522dee28",
      "name": "Sticky Note14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        800,
        1872
      ],
      "parameters": {
        "width": 260,
        "height": 300,
        "content": "## Add to Master All KW Variations table.\n"
      }
    },
    {
      "id": "510835f0-53cd-41c1-aef4-e33733b81efd",
      "name": "Add PAA to Master Table1",
      "type": "n8n-nodes-base.airtable",
      "position": [
        880,
        1968
      ]
    },
    {
      "id": "b6434069-8abb-451d-842b-add1e9fe88a9",
      "name": "Sticky Note15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1504,
        1440
      ],
      "parameters": {
        "width": 660,
        "height": 640,
        "content": "# How to Use\n## 1. Enter the keyword you would like to research in the Primary Keywords table along with location, language, limit, and depth.\nFor U.S. based searches, a good starting point for these "
      }
    },
    {
      "id": "288e16ab-6f73-47cc-a464-af6d2070f9b7",
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -1440,
        1168
      ]
    }
  ],
  "connections": {
    "Webhook": {
      "main": [
        [
          {
            "node": "Set Airtable Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter PAA": {
      "main": [
        [
          {
            "node": "Split Out People Also Ask",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter SERPs": {
      "main": [
        [
          {
            "node": "Set SERP Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set PAA Fileds": {
      "main": [
        [
          {
            "node": "Add PAA to Master Table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out SERP": {
      "main": [
        [
          {
            "node": "Filter SERPs",
            "type": "main",
            "index": 0
          },
          {
            "node": "Filter PAA",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set SERP Fields": {
      "main": [
        [
          {
            "node": "Create SERPS",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Serp API Request1": {
      "main": [
        [
          {
            "node": "Split Out SERP",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out KW Ideas": {
      "main": [
        [
          {
            "node": "Set Keyword Ideas Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Primary Keyword": {
      "main": [
        [
          {
            "node": "Set Fields for API Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Related API Request": {
      "main": [
        [
          {
            "node": "Split Out Result Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Airtable Fields": {
      "main": [
        [
          {
            "node": "Get Primary Keyword",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Subtopics": {
      "main": [
        [
          {
            "node": "Set Generate Subtopics Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "KW Ideas API Request": {
      "main": [
        [
          {
            "node": "Split Out KW Ideas",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set KW Related Fields": {
      "main": [
        [
          {
            "node": "Add Related KWs to Master Table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Autocomplete": {
      "main": [
        [
          {
            "node": "Set Autocomplete Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Result Items": {
      "main": [
        [
          {
            "node": "Set KW Related Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Autocomplete Fields": {
      "main": [
        [
          {
            "node": "Add Autocomplete to Master table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Suggested KWs": {
      "main": [
        [
          {
            "node": "Set KW Suggestion Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Autocomplete API Request": {
      "main": [
        [
          {
            "node": "Split Out Autocomplete",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set KW Suggestion Fields": {
      "main": [
        [
          {
            "node": "Add KW Suggestions to Master table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Keyword Ideas Fields": {
      "main": [
        [
          {
            "node": "Add KW Ideas to Master table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out People Also Ask": {
      "main": [
        [
          {
            "node": "Set PAA Fileds",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "KW Suggestions API Request": {
      "main": [
        [
          {
            "node": "Split Out Suggested KWs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Fields for API Request": {
      "main": [
        [
          {
            "node": "Related API Request",
            "type": "main",
            "index": 0
          },
          {
            "node": "KW Suggestions API Request",
            "type": "main",
            "index": 0
          },
          {
            "node": "KW Ideas API Request",
            "type": "main",
            "index": 0
          },
          {
            "node": "Autocomplete API Request",
            "type": "main",
            "index": 0
          },
          {
            "node": "Serp API Request1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Generate Subtopics API Request",
            "type": "main",
            "index": 0
          },
          {
            "node": "Airtable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Generate Subtopics Fields": {
      "main": [
        [
          {
            "node": "Add PAA to Master Table1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Subtopics API Request": {
      "main": [
        [
          {
            "node": "Split Out Subtopics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}