{
  "name": "Automate SEO keyword & SERP analysis with DataForSEO and Google Sheets",
  "nodes": [
    {
      "id": "a8b86cae-fc03-433b-bca7-be4137f40b9b",
      "name": "On form submission",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -180,
        -160
      ]
    },
    {
      "id": "75613162-339b-4792-9c21-300a84cd07eb",
      "name": "related keyword",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1560,
        -560
      ]
    },
    {
      "id": "00881b6b-944e-448d-8786-2960602d9ad8",
      "name": "Switch",
      "type": "n8n-nodes-base.switch",
      "position": [
        760,
        -200
      ]
    },
    {
      "id": "435d55c0-4f2a-434c-a4d0-b73625c14e34",
      "name": "Edit Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        300,
        -160
      ]
    },
    {
      "id": "f57d30ea-999a-47ad-807b-8dcfe562a9e2",
      "name": "Edit Fields1",
      "type": "n8n-nodes-base.set",
      "position": [
        2100,
        -560
      ]
    },
    {
      "id": "419d2fee-2e8c-4e0a-abfe-2bc1f2ca3533",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1860,
        -560
      ]
    },
    {
      "id": "ff5790ac-3a24-4993-81db-9ac794a0c976",
      "name": "Split Out1",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1860,
        -360
      ]
    },
    {
      "id": "63a738b1-cb97-4390-a767-86b4ce1197f9",
      "name": "Split Out2",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1860,
        -160
      ]
    },
    {
      "id": "9e3c5450-9321-4983-b6d8-8a5698e08aab",
      "name": "Split Out3",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1860,
        60
      ]
    },
    {
      "id": "c820bb1c-5f2c-4f9e-bf05-730a608b7797",
      "name": "Split Out4",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1860,
        280
      ]
    },
    {
      "id": "a7ad86d2-5a6f-4078-b94a-9fd28e9cfe6e",
      "name": "keyword suggestion",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1560,
        -360
      ]
    },
    {
      "id": "abc58e82-a4b4-4db1-b02a-2b3b30a9ed83",
      "name": "keyword suggestion sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1220,
        -360
      ]
    },
    {
      "id": "833ea8c4-6d65-4cee-bd28-14b9d884c7d8",
      "name": "get autocomplete",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1560,
        -160
      ]
    },
    {
      "id": "e4b9cc5a-a120-4b7c-a31b-0462ad0511e6",
      "name": "get subtopics",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1560,
        60
      ]
    },
    {
      "id": "9a78b5a9-5ebc-4fe5-8c45-d1448219870b",
      "name": "people also ask",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1560,
        280
      ]
    },
    {
      "id": "34e47468-0c60-427f-812e-bf093c317a71",
      "name": "get autocomplete sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1220,
        -160
      ]
    },
    {
      "id": "b12faf3e-2f1c-41d3-9e1d-cabd95c94be3",
      "name": "get subtopics sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1220,
        60
      ]
    },
    {
      "id": "7078dcd3-3220-48a4-b0b1-f9b2df41a5c9",
      "name": "people also ask sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1220,
        280
      ]
    },
    {
      "id": "eabf4c58-85e2-4f73-85ed-107ff42fa330",
      "name": "Edit Fields4",
      "type": "n8n-nodes-base.set",
      "position": [
        2100,
        -160
      ]
    },
    {
      "id": "22e11d3b-ad30-40fb-beb5-869fa32908ae",
      "name": "Edit Fields6",
      "type": "n8n-nodes-base.set",
      "position": [
        2100,
        60
      ]
    },
    {
      "id": "fdd8e7c2-97ce-4988-8f64-6601aabc7b03",
      "name": "Split Out6",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        2340,
        280
      ]
    },
    {
      "id": "7adbf13a-efeb-4acd-897a-a107ef29955f",
      "name": "Edit Fields5",
      "type": "n8n-nodes-base.set",
      "position": [
        2580,
        280
      ]
    },
    {
      "id": "b03df472-0028-433a-a291-0b02e6d6b27a",
      "name": "Edit Fields2",
      "type": "n8n-nodes-base.set",
      "position": [
        2100,
        -360
      ]
    },
    {
      "id": "3852d7d0-238b-4799-879e-43414387233c",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -240,
        -360
      ],
      "parameters": {
        "width": null,
        "height": 460,
        "content": "## Get keyword\nGet keyword, location, language and operation from user."
      }
    },
    {
      "id": "228fe28f-4fcb-41c5-926d-d2d64fd6b8a0",
      "name": "Add operation to main sheet in Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        540,
        -160
      ]
    },
    {
      "id": "758a8e17-34da-482b-a678-e16b9d4a28c3",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        700,
        -360
      ],
      "parameters": {
        "width": null,
        "height": 460,
        "content": "## Switch\nChoose what operation to do. It gets the operation from user."
      }
    },
    {
      "id": "b7bc7d6a-31f3-4689-ac6a-589afae253fc",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1140,
        -760
      ],
      "parameters": {
        "width": 260,
        "height": 1240,
        "content": "## Create a sheet\nIt creates a sheet that its title is {keyword}{operation}.\nfr every operation it create a sheet.\n"
      }
    },
    {
      "id": "b728b3a8-72bf-4950-a74f-45a5567a4fda",
      "name": "related keyword sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1220,
        -560
      ]
    },
    {
      "id": "28eccb35-34b2-4c7b-8d36-456a5577843d",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1460,
        -760
      ],
      "parameters": {
        "width": 260,
        "height": 1240,
        "content": "## DataforSEO API Request\nSend request to DataforSeo with operation, keyword, location_name and language_name.\n"
      }
    },
    {
      "id": "fae6c44e-7069-4278-b756-14f859847574",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1780,
        -760
      ],
      "parameters": {
        "width": 260,
        "height": 1240,
        "content": "## Get the Data from API call\nIt gets the data that needed from last node and ignores every other fields that we don't need.\n"
      }
    },
    {
      "id": "35249966-22b2-4123-9806-055bbb2f6bdd",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2280,
        -760
      ],
      "parameters": {
        "width": 260,
        "height": 1000,
        "content": "## Append data to sheet\nThis node append the data to the sheet created in 'Create a sheet' node.\n"
      }
    },
    {
      "id": "42475196-e399-4bc2-b258-fbd26daf545c",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2740,
        120
      ],
      "parameters": {
        "width": 260,
        "height": 420,
        "content": "## Append data to sheet\nThis node append the data to the sheet created in 'Create a sheet' node.\n"
      }
    },
    {
      "id": "0d121e1e-19f1-4574-87de-4b22c8d15026",
      "name": "Filter people also ask",
      "type": "n8n-nodes-base.filter",
      "position": [
        2100,
        280
      ]
    },
    {
      "id": "6ba0d98b-6115-48e4-8550-9554c737f869",
      "name": "Check If fields not empty",
      "type": "n8n-nodes-base.if",
      "position": [
        60,
        -160
      ]
    },
    {
      "id": "e07e4b2a-ada3-41ce-baf5-faa8f3467720",
      "name": "Add to Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2340,
        -560
      ]
    },
    {
      "id": "2df32bdd-390c-4e2d-8353-8a76acaf93a2",
      "name": "Add to Sheet1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2340,
        -360
      ]
    },
    {
      "id": "d65cacaa-71c7-4bc1-8e7c-fcc44606837b",
      "name": "Add to Sheet2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2340,
        -160
      ]
    },
    {
      "id": "6052e855-ba5b-4e05-870c-e667a31ee8bc",
      "name": "Add to Sheet3",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2340,
        60
      ]
    },
    {
      "id": "f48efe65-7dd8-4821-bdd7-0b058f85840e",
      "name": "Add to Sheet4",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2820,
        280
      ]
    }
  ],
  "connections": {
    "Switch": {
      "main": [
        [
          {
            "node": "related keyword sheet",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "keyword suggestion sheet",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "get autocomplete sheet",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "get subtopics sheet",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "people also ask sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out": {
      "main": [
        [
          {
            "node": "Edit Fields1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out1": {
      "main": [
        [
          {
            "node": "Edit Fields2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out2": {
      "main": [
        [
          {
            "node": "Edit Fields4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out3": {
      "main": [
        [
          {
            "node": "Edit Fields6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out4": {
      "main": [
        [
          {
            "node": "Filter people also ask",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out6": {
      "main": [
        [
          {
            "node": "Edit Fields5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "Add operation to main sheet in Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields1": {
      "main": [
        [
          {
            "node": "Add to Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields2": {
      "main": [
        [
          {
            "node": "Add to Sheet1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields4": {
      "main": [
        [
          {
            "node": "Add to Sheet2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields5": {
      "main": [
        [
          {
            "node": "Add to Sheet4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields6": {
      "main": [
        [
          {
            "node": "Add to Sheet3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add to Sheet4": {
      "main": [
        []
      ]
    },
    "get subtopics": {
      "main": [
        [
          {
            "node": "Split Out3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "people also ask": {
      "main": [
        [
          {
            "node": "Split Out4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "related keyword": {
      "main": [
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get autocomplete": {
      "main": [
        [
          {
            "node": "Split Out2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "On form submission": {
      "main": [
        [
          {
            "node": "Check If fields not empty",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "keyword suggestion": {
      "main": [
        [
          {
            "node": "Split Out1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get subtopics sheet": {
      "main": [
        [
          {
            "node": "get subtopics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "people also ask sheet": {
      "main": [
        [
          {
            "node": "people also ask",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "related keyword sheet": {
      "main": [
        [
          {
            "node": "related keyword",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter people also ask": {
      "main": [
        [
          {
            "node": "Split Out6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get autocomplete sheet": {
      "main": [
        [
          {
            "node": "get autocomplete",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "keyword suggestion sheet": {
      "main": [
        [
          {
            "node": "keyword suggestion",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check If fields not empty": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add operation to main sheet in Google Sheets": {
      "main": [
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}