← All N8N workflows
Data & databasesExecute Workflow TriggerGoogle SheetsHTTP RequestEdit FieldsSplit Out

Generate New Keywords with Search Volumes⚒️⚒️🟢🟢

Configured with Execute Workflow Trigger, Google Sheets, HTTP Request, Split Out. Review the connections and setup before adapting this template.

Workflow preview
TransformSplit OutSplit OutWeb / APIGenerate new keywordsHTTP RequestTransformEdit FieldsEdit FieldsTransformSet KeywordsEdit FieldsData storeUpsertGoogle SheetsTriggerTriggerExecute Workflow Trigger

Node categories in this workflow

  • Transform
  • Web / API
  • Data store
  • Trigger

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
Split OutTransformSplit OutSee node parameters
Generate new keywordsWeb / APIHTTP RequestPOST
Edit FieldsTransformEdit FieldsSee node parameters
Set KeywordsTransformEdit FieldsSee node parameters
UpsertData storeGoogle Sheetsappend
TriggerTriggerExecute Workflow TriggerSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • googleAdsOAuth2Api
  • googleSheetsOAuth2Api

Workflow notes

Generate new keywords for SEO with the monthly Search volumes

Generate new keywords for SEO with the monthly Search volumes

This workflow is an improvement on the workflows below. It can be used to generate new keywords that you can use for your SEO campaigns or Google ads campaigns

Generate SEO Keyword Search Volume Data using Google API and Generating Keywords using Google Autosuggest

Usage

  1. Send the keywords you need as an array to this workflow
  2. Pin the data and map it to the set Keywords node
  3. Map the keywords to the Google ads API with the location and Language of your choice
  4. Split the results and set them data
  5. Pass this to the next nodes as needed for storage
  6. Make a copy of this spreedsheet and update the data accordingly

Having challenges with the google Ads API? Read this blog

Made by @Imperol

Generate new keywords

Call the endpoint:

https://googleads.googleapis.com/v18/customers/{customer_id}:generateKeywordIdeas

with your Customer id

Upsert

Upsert the new keywords to sheets

Setup

Setup

  1. Replace the trigger with your desired trigger eg a webhook or manual trigger

  2. Map the data correctly to the set Keywords node

  3. On the Generate new keywords, Update the {customer_id} on the url and login-customer-id with your actual one. Update the developer-token` also with your values.

The url should be corrected as below https://googleads.googleapis.com/v18/customers/{customer-id}:generateKeywordIdeas

You should send the headers as below



            {
              "name": "content-type",
              "value": "application/json"
            },
            {
              "name": "developer-token",
              "value": "{developer-token}"
            },
            {
              "name": "login-customer-id",
              "value": "{login-customer-id}"
            }
         
    


and the json body should take the following format


{
  "geoTargetConstants": ["geoTargetConstants/2840"], 
  "includeAdultKeywords": false,
  "pageToken": "",
  "pageSize": 2,
  "keywordPlanNetwork": "GOOGLE_SEARCH",
  "language": "languageConstants/1000", 
  "keywordSeed": {
    "keywords": {{ $json.Keyword }}
  }
}

Troubleshooting

Troubleshooting

  1. If you get an error with the workflow, check the credentials you are using

  2. Check the account you are using eg the right customer id and developer token

  3. Follow the guide on the blog to set up your Google ads account

Generate New Keywords with Search Volumes⚒️⚒️🟢🟢

Generate New Keywords with Search Volumes⚒️⚒️🟢🟢

Purpose and structure

This folder contains the Generate New Keywords with Search Volumes⚒️⚒️🟢🟢 workflow. Its executable nodes use executeWorkflowTrigger, googleSheets, httpRequest, set, splitOut. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

Trigger

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Splitout/1660_Splitout_HTTP_Create_Webhook.json MIT; preserve source notices.

Canvas section labels

These name areas of the original canvas; they do not include explanatory instructions.

  • Generate new keywords and split the data out to set only the keyword and average monthly search
  • Set up a new trigger and map the data with a column name as keyword

More in Data & databases