AutomationFlowsData & Sheets › Comprehensive SEO Keyword Research & Analysis with Dataforseo and Google Sheets

Comprehensive SEO Keyword Research & Analysis with Dataforseo and Google Sheets

Byrana tamure @tamure on n8n.io

Overview

Event trigger★★★★★ complexity41 nodesGoogle SheetsGoogle DriveHTTP Request
Data & Sheets Trigger: Event Nodes: 41 Complexity: ★★★★★ Added:

This workflow corresponds to n8n.io template #6931 — we link there as the canonical source.

This workflow follows the Google Drive → Google Sheets recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "id": "6FzjDqadbNnLvKoB",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "keyword search for blogs",
  "tags": [],
  "nodes": [
    {
      "id": "682d6ccd-4b0b-46a3-a4c8-8a864d13dd36",
      "name": "When clicking \u2018Test workflow\u2019",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1360,
        112
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e241fda5-133e-49ad-8407-04b5179956c2",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1024,
        112
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RpgRUJI-CZ01SmGh_Xma8olDW3GEmpnaKsvLSo-0cK8/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1RpgRUJI-CZ01SmGh_Xma8olDW3GEmpnaKsvLSo-0cK8",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RpgRUJI-CZ01SmGh_Xma8olDW3GEmpnaKsvLSo-0cK8/edit?usp=drivesdk",
          "cachedResultName": "SEO PRO"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "c9666722-fe0c-42f2-9720-1263bb957d9c",
      "name": "Google Sheets1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -704,
        112
      ],
      "parameters": {
        "title": "={{ $now.format('yyyy-MM-dd') }}-seo pro",
        "options": {},
        "resource": "spreadsheet",
        "sheetsUi": {
          "sheetValues": [
            {
              "title": "keyword"
            },
            {
              "title": "SERP"
            },
            {
              "title": "Content"
            },
            {
              "title": "related keyword"
            },
            {
              "title": "keyword ideas"
            },
            {
              "title": "suggested keyword"
            },
            {
              "title": "sub topics"
            },
            {
              "title": "auto complete"
            }
          ]
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "518f18a5-c396-4a93-b96b-dd746201b3d0",
      "name": "Google Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -432,
        112
      ],
      "parameters": {
        "fileId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $json.spreadsheetId  }}   "
        },
        "driveId": {
          "__rl": true,
          "mode": "list",
          "value": "My Drive"
        },
        "folderId": {
          "__rl": true,
          "mode": "list",
          "value": "1sTWLU9GgsJ_6VvfK3S1UpGHuZCiu1TKQ",
          "cachedResultUrl": "https://drive.google.com/drive/folders/1sTWLU9GgsJ_6VvfK3S1UpGHuZCiu1TKQ",
          "cachedResultName": "seo pro"
        },
        "operation": "move"
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "55bd3f9b-fe9f-4c9b-9369-f7cd3f65e39e",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        768,
        -272
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "tasks[0].result[0].items"
      },
      "typeVersion": 1
    },
    {
      "id": "dc35b520-0917-4ad7-ae92-e57d2b32276e",
      "name": "Edit Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        992,
        -272
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "9b6c6833-9a17-40a4-97cd-8c28168bb9c3",
              "name": "keyword",
              "type": "string",
              "value": "={{ $('Google Sheets').item.json['primary keyword'] }}"
            },
            {
              "id": "809a4151-ab92-40e6-a8d2-4ed1a96a49aa",
              "name": "keyword difficulty",
              "type": "string",
              "value": "={{ $json.keyword_data.keyword_properties.keyword_difficulty }}"
            },
            {
              "id": "12caa5c0-3ffb-4bed-b2af-f139dbf15a9c",
              "name": "search intent",
              "type": "string",
              "value": "={{ $json.keyword_data.search_intent_info.main_intent }}"
            },
            {
              "id": "aef9fa8d-dd76-4d16-a2a6-708fb5e9ab43",
              "name": "related keyword",
              "type": "string",
              "value": "= {{ $json.keyword_data.keyword }}"
            },
            {
              "id": "5d33a8a9-778b-40a6-9efb-acb8204c58fe",
              "name": "last update",
              "type": "string",
              "value": "={{ $json.keyword_data.keyword_info.last_updated_time }}"
            },
            {
              "id": "1a0d83e5-4651-4cc9-b282-1b58acd4bff2",
              "name": "SERP Analysis",
              "type": "string",
              "value": "={{ $json.keyword_data.serp_info.serp_item_types.join(\",\") }}"
            },
            {
              "id": "129ac304-872b-4772-bfd1-6382e6b8b71d",
              "name": "search volume",
              "type": "string",
              "value": "={{ $json.keyword_data.keyword_info.search_volume }}"
            },
            {
              "id": "1cf80f1f-dcec-4452-baa5-c5580d8aad24",
              "name": "CPC",
              "type": "string",
              "value": "={{ $json.keyword_data.keyword_info.cpc }}"
            },
            {
              "id": "de3fe02d-8f6b-4b52-807a-ca727f089a32",
              "name": "compitition",
              "type": "string",
              "value": "={{ $json.keyword_data.keyword_info.competition_level }}"
            },
            {
              "id": "1663de4d-4a53-4a0e-96bd-c437ad888e41",
              "name": "type",
              "type": "string",
              "value": "related_keyword"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "3d273ed3-9e9b-4a42-aad9-e638a2568820",
      "name": "Split Out1",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        768,
        -80
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "tasks[0].result[0].items"
      },
      "typeVersion": 1
    },
    {
      "id": "5379fb0e-4b93-4e03-a825-8dab45eee68e",
      "name": "Edit Fields2",
      "type": "n8n-nodes-base.set",
      "position": [
        992,
        -80
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "9b6c6833-9a17-40a4-97cd-8c28168bb9c3",
              "name": "keyword",
              "type": "string",
              "value": "={{ $('Google Sheets').item.json['primary keyword'] }}"
            },
            {
              "id": "12caa5c0-3ffb-4bed-b2af-f139dbf15a9c",
              "name": "search intent",
              "type": "string",
              "value": "={{ $json.search_intent_info.main_intent }}"
            },
            {
              "id": "aef9fa8d-dd76-4d16-a2a6-708fb5e9ab43",
              "name": "suggested keyword",
              "type": "string",
              "value": "= {{ $json.keyword }}"
            },
            {
              "id": "5d33a8a9-778b-40a6-9efb-acb8204c58fe",
              "name": "last update",
              "type": "string",
              "value": "= {{ $json.keyword_info.last_updated_time }}"
            },
            {
              "id": "129ac304-872b-4772-bfd1-6382e6b8b71d",
              "name": "search volume",
              "type": "string",
              "value": "={{ $json.keyword_info.search_volume }} "
            },
            {
              "id": "1cf80f1f-dcec-4452-baa5-c5580d8aad24",
              "name": "CPC",
              "type": "string",
              "value": "= {{ $json.keyword_info.cpc }}"
            },
            {
              "id": "de3fe02d-8f6b-4b52-807a-ca727f089a32",
              "name": "compitition",
              "type": "string",
              "value": "= {{ $json.keyword_info.competition }}"
            },
            {
              "id": "1663de4d-4a53-4a0e-96bd-c437ad888e41",
              "name": "type",
              "type": "string",
              "value": "suggested_keyword"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "b486e98e-9a47-46cb-acbe-c2623e9ed772",
      "name": "Split Out2",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        768,
        128
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "tasks[0].result[0].items"
      },
      "typeVersion": 1
    },
    {
      "id": "0405d2b7-0bf5-41da-bb1a-a32cfe7622fc",
      "name": "Edit Fields3",
      "type": "n8n-nodes-base.set",
      "position": [
        992,
        128
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "9b6c6833-9a17-40a4-97cd-8c28168bb9c3",
              "name": "keyword",
              "type": "string",
              "value": "={{ $('Google Sheets').item.json['primary keyword'] }}"
            },
            {
              "id": "12caa5c0-3ffb-4bed-b2af-f139dbf15a9c",
              "name": "search intent",
              "type": "string",
              "value": "={{ $json.search_intent_info.main_intent }}"
            },
            {
              "id": "aef9fa8d-dd76-4d16-a2a6-708fb5e9ab43",
              "name": "  keyword ideas",
              "type": "string",
              "value": "= {{ $json.keyword }}"
            },
            {
              "id": "5d33a8a9-778b-40a6-9efb-acb8204c58fe",
              "name": "last update",
              "type": "string",
              "value": "= {{ $json.keyword_info.last_updated_time }}"
            },
            {
              "id": "129ac304-872b-4772-bfd1-6382e6b8b71d",
              "name": "search volume",
              "type": "string",
              "value": "={{ $json.keyword_info.search_volume }} "
            },
            {
              "id": "1cf80f1f-dcec-4452-baa5-c5580d8aad24",
              "name": "CPC",
              "type": "string",
              "value": "= {{ $json.keyword_info.cpc }}"
            },
            {
              "id": "de3fe02d-8f6b-4b52-807a-ca727f089a32",
              "name": "compitition",
              "type": "string",
              "value": "= {{ $json.keyword_info.competition }}"
            },
            {
              "id": "1663de4d-4a53-4a0e-96bd-c437ad888e41",
              "name": "type",
              "type": "string",
              "value": "keyword_ideas"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "4902e47b-fd45-427b-a807-53089c0cf041",
      "name": "Split Out3",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        768,
        352
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "tasks[0].result[0].items"
      },
      "typeVersion": 1
    },
    {
      "id": "821aad2c-d733-4de4-ab08-b8fa48f1b661",
      "name": "Edit Fields4",
      "type": "n8n-nodes-base.set",
      "position": [
        992,
        352
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "bcfd6063-5f17-481e-90a4-ffb6c90e03f4",
              "name": "primary keyword",
              "type": "string",
              "value": "={{ $('Google Sheets').item.json['primary keyword'] }}"
            },
            {
              "id": "82f4e7ef-214e-474f-87d8-e23bbffa02b0",
              "name": "type",
              "type": "string",
              "value": "={{ $json.type }}"
            },
            {
              "id": "6a3ca04d-af0a-474f-bfa6-386f302062b8",
              "name": "get autocomplete",
              "type": "string",
              "value": "={{ $json.suggestion }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "51dad7b5-7606-49fc-99cc-f5a71ea48a35",
      "name": "Split Out4",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        768,
        544
      ],
      "parameters": {
        "options": {
          "destinationFieldName": "sub_topics"
        },
        "fieldToSplitOut": "tasks[0].result[0].sub_topics"
      },
      "typeVersion": 1
    },
    {
      "id": "cba3c171-cf7c-4477-8df9-37fe26e86b8d",
      "name": "related keyword",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        528,
        -272
      ],
      "parameters": {
        "url": "https://api.dataforseo.com/v3/dataforseo_labs/google/related_keywords/live",
        "method": "POST",
        "options": {
          "redirect": {
            "redirect": {}
          }
        },
        "jsonBody": "=[\n  {\n    \"keyword\": \"{{ $('Google Sheets').item.json['primary keyword'] }}\",\n    \"location_name\":\"{{ $('Google Sheets').item.json['location name'] }}\",\n    \"language_name\":\"{{ $('Google Sheets').item.json['language name'] }}\",\n    \"depth\": 3,\n    \"include_seed_keyword\": false,\n    \"include_serp_info\": true,\n    \"ignore_synonyms\": false,\n    \"include_clickstream_data\": false,\n    \"replace_with_core_keyword\": false,\n    \"limit\": 100\n  }\n]",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpBasicAuth"
      },
      "credentials": {
        "httpBasicAuth": {
          "name": "<your credential>"
        },
        "httpHeaderAuth": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "d4b284b9-5fd6-4833-9778-c4fb2a9b2f06",
      "name": "keyword suggestion",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        528,
        -80
      ],
      "parameters": {
        "url": "https://api.dataforseo.com/v3/dataforseo_labs/google/keyword_suggestions/live",
        "method": "POST",
        "options": {
          "redirect": {
            "redirect": {}
          }
        },
        "jsonBody": "=[\n  {\n    \"keyword\": \"{{ $('Google Sheets').item.json['primary keyword'] }}\",\n    \"location_name\":\"{{ $('Google Sheets').item.json['location name'] }}\",\n    \"language_name\":\"{{ $('Google Sheets').item.json['language name'] }}\",\n    \"depth\": 3,\n    \"include_seed_keyword\": false,\n    \"include_serp_info\": false,\n    \"ignore_synonyms\": false,\n    \"include_clickstream_data\": false,\n    \"replace_with_core_keyword\": false,\n    \"limit\": 100\n  }\n]",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpBasicAuth"
      },
      "credentials": {
        "httpBasicAuth": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "3ee2b5c7-799a-403b-8e96-dc5e0c648082",
      "name": "keyword ideas",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        528,
        128
      ],
      "parameters": {
        "url": "https://api.dataforseo.com/v3/dataforseo_labs/google/keyword_ideas/live",
        "method": "POST",
        "options": {
          "redirect": {
            "redirect": {}
          }
        },
        "jsonBody": "=[\n  {\n    \"keywords\":[ \"{{ $('Google Sheets').item.json['primary keyword'] }}\"],\n    \"location_name\":\"{{ $('Google Sheets').item.json['location name'] }}\",\n    \"language_name\":\"{{ $('Google Sheets').item.json['language name'] }}\",\n    \"depth\": 3,\n    \"include_seed_keyword\": false,\n    \"include_serp_info\": false,\n    \"ignore_synonyms\": false,\n    \"include_clickstream_data\": false,\n    \"replace_with_core_keyword\": false,\n    \"limit\": 100\n  }\n]",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpBasicAuth"
      },
      "credentials": {
        "httpBasicAuth": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "ac3ae316-d309-489e-b00b-14278bbd3887",
      "name": "get autocomplete",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        528,
        352
      ],
      "parameters": {
        "url": "https://api.dataforseo.com/v3/serp/google/autocomplete/live/advanced",
        "method": "POST",
        "options": {},
        "jsonBody": "=[\n  {\n    \"keyword\": \"{{ $('Google Sheets').item.json['primary keyword'] }}\",\n    \"location_name\": \"{{ $('Google Sheets').item.json['location name'] }}\",\n    \"language_name\": \"{{ $('Google Sheets').item.json['language name'] }}\",\n    \"client\": \"gws-wiz-serp\"\n  }\n]",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpBasicAuth"
      },
      "credentials": {
        "httpBasicAuth": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "41894e86-e67e-4f58-95d6-6b488de6a5d3",
      "name": "get_subtopics",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        528,
        544
      ],
      "parameters": {
        "url": "https://api.dataforseo.com/v3/content_generation/generate_sub_topics/live",
        "method": "POST",
        "options": {
          "redirect": {
            "redirect": {}
          }
        },
        "jsonBody": "=[\n  {\n    \"topic\":\"{{ $('Google Sheets').item.json['primary keyword'] }}\"\n     \n  }\n]",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpBasicAuth"
      },
      "credentials": {
        "httpBasicAuth": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "4e932ab8-40d6-4219-8b1c-260dfef6f84a",
      "name": "Edit Fields6",
      "type": "n8n-nodes-base.set",
      "position": [
        992,
        544
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "bcfd6063-5f17-481e-90a4-ffb6c90e03f4",
              "name": "primary keyword",
              "type": "string",
              "value": "={{ $('Google Sheets').item.json['primary keyword'] }}"
            },
            {
              "id": "82f4e7ef-214e-474f-87d8-e23bbffa02b0",
              "name": "type",
              "type": "string",
              "value": "sub_topics"
            },
            {
              "id": "6a3ca04d-af0a-474f-bfa6-386f302062b8",
              "name": "sub topics",
              "type": "string",
              "value": "= {{ $json.sub_topics }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "2551302b-19b4-44b3-b9c6-aecb1297e853",
      "name": "Google Sheets3",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1216,
        -272
      ],
      "parameters": {
        "columns": {
          "value": {
            "CPC": "={{ $json.CPC }}",
            "type": "={{ $json.type }}",
            "keyword": "={{ $json.keyword }}",
            "compitition": "={{ $json.compitition }}",
            "last update": "={{ $json['last update'] }}",
            "SERP Analysis": "={{ $json['SERP Analysis'] }}",
            "search intent": "={{ $json['search intent'] }}",
            "search volume": "={{ $json['search volume'] }}",
            "people also ask": "={{ $json['people also ask'] }}",
            "related keyword": "={{ $json['related keyword'] }}",
            "keyword difficulty": "={{ $json['keyword difficulty'] }}"
          },
          "schema": [
            {
              "id": "keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "keyword difficulty",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keyword difficulty",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "related keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "related keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "search intent",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "search intent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "last update",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "last update",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "SERP Analysis",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "SERP Analysis",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "search volume",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "search volume",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "CPC",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "CPC",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "people also ask",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "people also ask",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "compitition",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "compitition",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "type",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1770387324,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit#gid=1770387324",
          "cachedResultName": "master sheet"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit?usp=drivesdk",
          "cachedResultName": "2025-06-08-seo pro"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "dbefebcc-aa21-427d-933d-488670a846cc",
      "name": "Google Sheets4",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1424,
        -272
      ],
      "parameters": {
        "columns": {
          "value": {
            "CPC": "={{ $json.CPC }}",
            "type": "={{ $json.type }}",
            "keyword": "={{ $json.keyword }}",
            "compitition": "={{ $json.compitition }}",
            "last update": "={{ $json['last update'] }}",
            "SERP Analysis": "={{ $json['SERP Analysis'] }}",
            "search intent": "={{ $json['search intent'] }}",
            "search volume": "={{ $json['search volume'] }}",
            "people also ask": "={{ $json['people also ask'] }}",
            "related keyword": "={{ $json['related keyword'] }}",
            "keyword difficulty": "={{ $json['keyword difficulty'] }}"
          },
          "schema": [
            {
              "id": "keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "keyword difficulty",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keyword difficulty",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "related keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "related keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "search intent",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "search intent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "last update",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "last update",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "SERP Analysis",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "SERP Analysis",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "search volume",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "search volume",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "CPC",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "CPC",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "people also ask",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "people also ask",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "compitition",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "compitition",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "type",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 572225882,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit#gid=572225882",
          "cachedResultName": "related keywords"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit?usp=drivesdk",
          "cachedResultName": "2025-06-08-seo pro"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "94affba7-8a13-4560-90c0-b528db858f76",
      "name": "Google Sheets5",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1216,
        -80
      ],
      "parameters": {
        "columns": {
          "value": {
            "CPC": "={{ $json.CPC }}",
            "type": "={{ $json.type }}",
            "keyword": "={{ $json.keyword }}",
            "compitition": "={{ $json.compitition }}",
            "search intent": "={{ $json['search intent'] }}",
            "search volume": "={{ $json['search volume'] }}",
            "related keyword": "={{ $json['suggested keyword'] }}"
          },
          "schema": [
            {
              "id": "keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "keyword difficulty",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keyword difficulty",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "related keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "related keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "search intent",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "search intent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "search volume",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "search volume",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "compitition",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "compitition",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "CPC",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "CPC",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "type",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "SERP Analysis",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "SERP Analysis",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "people also ask",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "people also ask",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "last update",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "last update",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1770387324,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit#gid=1770387324",
          "cachedResultName": "master sheet"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit?usp=drivesdk",
          "cachedResultName": "2025-06-08-seo pro"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "9fd10d15-8c38-44cf-9adb-091ba5987813",
      "name": "Google Sheets6",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1424,
        -80
      ],
      "parameters": {
        "columns": {
          "value": {
            "CPC": "={{ $json.CPC }}",
            "type": "={{ $json.type }}",
            "keyword": "={{ $json.keyword }}",
            "compitition": "={{ $json.compitition }}",
            "search volume": "={{ $json['search volume'] }}",
            "suggested keyword": "={{ $json['related keyword'] }}"
          },
          "schema": [
            {
              "id": "keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "suggested keyword",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "suggested keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "search volume",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "search volume",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "CPC",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "CPC",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "compitition",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "compitition",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "type",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1945660973,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit#gid=1945660973",
          "cachedResultName": "suggested keyword"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit?usp=drivesdk",
          "cachedResultName": "2025-06-08-seo pro"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "a1f87720-6e5f-4eb9-ae91-5d4111187603",
      "name": "Google Sheets7",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1216,
        128
      ],
      "parameters": {
        "columns": {
          "value": {
            "CPC": "={{ $json.CPC }}",
            "type": "={{ $json.type }}",
            "keyword": "={{ $json.keyword }}",
            "compitition": "={{ $json.compitition }}",
            "search intent": "={{ $json['search intent'] }}",
            "search volume": "={{ $json['search volume'] }}",
            "related keyword": "={{ $json['  keyword ideas'] }}"
          },
          "schema": [
            {
              "id": "keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "keyword difficulty",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keyword difficulty",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "related keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "related keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "search intent",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "search intent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "search volume",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "search volume",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "compitition",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "compitition",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "CPC",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "CPC",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "type",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "SERP Analysis",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "SERP Analysis",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "people also ask",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "people also ask",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "last update",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "last update",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1770387324,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit#gid=1770387324",
          "cachedResultName": "master sheet"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit?usp=drivesdk",
          "cachedResultName": "2025-06-08-seo pro"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "f73a5ff8-1f33-4753-b143-bec741b5d60d",
      "name": "Google Sheets8",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1424,
        128
      ],
      "parameters": {
        "columns": {
          "value": {
            "cpc": "={{ $json.CPC }}",
            "type": "={{ $json.type }}",
            "ideas": "={{ $json['related keyword'] }}",
            "keyword": "={{ $json.keyword }}",
            "compitetion": "={{ $json.compitition }}",
            "search intent": "={{ $json['search intent'] }}",
            "search volume": "={{ $json['search volume'] }}"
          },
          "schema": [
            {
              "id": "keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "ideas",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "ideas",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "compitetion",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "compitetion",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "search intent",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "search intent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "search volume",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "search volume",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "cpc",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "cpc",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "type",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 906162743,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit#gid=906162743",
          "cachedResultName": "keyword ideas"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit?usp=drivesdk",
          "cachedResultName": "2025-06-08-seo pro"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "3fee865d-9aef-4c90-9274-0bba04422e59",
      "name": "Google Sheets9",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1216,
        352
      ],
      "parameters": {
        "columns": {
          "value": {
            "type": "={{ $json.type }}",
            "keyword": "={{ $json['primary keyword'] }}",
            "related keyword": "={{ $json['get autocomplete'] }}"
          },
          "schema": [
            {
              "id": "keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "keyword difficulty",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keyword difficulty",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "related keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "related keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "search intent",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "search intent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "search volume",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "search volume",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "compitition",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "compitition",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "CPC",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "CPC",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "type",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "SERP Analysis",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "SERP Analysis",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "people also ask",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "people also ask",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "last update",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "last update",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1770387324,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit#gid=1770387324",
          "cachedResultName": "master sheet"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit?usp=drivesdk",
          "cachedResultName": "2025-06-08-seo pro"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "9d96d5ec-2978-4c0c-9b0b-f67875b774e8",
      "name": "Google Sheets10",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1424,
        352
      ],
      "parameters": {
        "columns": {
          "value": {
            "keyword": "={{ $json.keyword }}",
            "auto complete": "={{ $json['related keyword'] }}"
          },
          "schema": [
            {
              "id": "keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "auto complete",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "auto complete",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1773795504,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit#gid=1773795504",
          "cachedResultName": "auto complete"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit?usp=drivesdk",
          "cachedResultName": "2025-06-08-seo pro"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "5215e08a-1bf9-45c7-94d3-27c50e922ee4",
      "name": "Google Sheets11",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1216,
        544
      ],
      "parameters": {
        "columns": {
          "value": {
            "type": "={{ $json.type }}",
            "keyword": "={{ $json['primary keyword'] }}",
            "related keyword": "={{ $json['sub topics'] }}"
          },
          "schema": [
            {
              "id": "keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "keyword difficulty",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keyword difficulty",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "related keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "related keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "search intent",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "search intent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "search volume",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "search volume",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "compitition",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "compitition",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "CPC",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "CPC",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "type",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "SERP Analysis",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "SERP Analysis",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "people also ask",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "people also ask",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "last update",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "last update",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1770387324,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit#gid=1770387324",
          "cachedResultName": "master sheet"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit?usp=drivesdk",
          "cachedResultName": "2025-06-08-seo pro"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "ba0505a8-9377-40b7-b341-107fe81bd629",
      "name": "Google Sheets12",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1424,
        544
      ],
      "parameters": {
        "columns": {
          "value": {
            "keyword": "={{ $json.keyword }}",
            "subtopics": "={{ $json['related keyword'] }}"
          },
          "schema": [
            {
              "id": "keyword",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "subtopics",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "subtopics",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "keyword"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1677181108,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit#gid=1677181108",
          "cachedResultName": "sub topics"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nKQ0ZzE4IL_gdOG1iwse2_rrPiJKtu2VzP7hmqQi4SU/edit?usp=drivesdk",
          "cachedResultName": "2025-06-08-seo pro"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "97946938-dd86-437c-9b1a-8d2ab25ddc4e",
      "name": "Split Out5",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        768,
        752
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "tasks[0].result[0].items"
      },
      "typeVersion": 1
    },
    {
      "id": "ce3370d6-bd21-4591-9c65-a4ac08775397",
      "name": "Edit Fields1",
      "type": "n8n-nodes-base.set",
      "position": [
        1264,
        976
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "987efe2e-1d0f-4ff7-9bc5-a8ec05f236df",
              "name": "type",
              "type": "string",
              "value": "={{ $json.type }}"
            },
            {
              "id": "081d8690-519b-45b0-b7ab-2fd0f081b2f6",
              "name": "domain",
              "type": "string",
 

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Overview

Source: https://n8n.io/workflows/6931/ — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Data & Sheets

PCN. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 60 nodes.

Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +3
Data & Sheets

The workflow automates the process of gathering extensive keyword data for a "Main Keyword." It starts by reading initial parameters from a Google Sheets template, creates a new dedicated Google Sheet

Google Sheets, Google Drive, HTTP Request
Data & Sheets

🔥 March Sale – n8n Community Members Get ideoGener8r for Just $27! (Reg. $47) Use Coupon Code: (Valid until 3/31/2025 for n8n community members)

HTTP Request, Google Drive, Google Sheets
Data & Sheets

📄 Documentation: Notion Guide

Google Sheets, Google Drive, HTTP Request +2
Data & Sheets

This workflow automates the full pipeline for extending short Viral UGC-style videos using AI, merging them, and finally publishing the output to cloud storage or social media platforms (TikTok, Insta

HTTP Request, Google Sheets, Google Drive +1