Automate keyword research and search volume data in Google Sheets

This template starts when you add a seed keyword to Google Sheets. JavaScript calls the Google Ads Keyword Planner API for related keywords, monthly search volume, competition, and bid estimates, then appends those rows to your research sheet. Put the Google Ads developer token and customer ID in that JavaScript node. Connect Google Sheets and point the trigger at the seed worksheet.

Updated Sep 16, 2026Est. run: 7sEst. cost: $0.0004

Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how CPU seconds work →

Workflow preview

What this template does

Turns each seed keyword into a Keyword Planner research set
Calls the Google Ads API from JavaScript
Keeps the Google Ads developer token in that JavaScript node
Stores keyword, volume, competition, and bid estimates in Google Sheets

How it works

Trigger

Catch the seed keyword

The scenario starts when a new row with a seed keyword appears in the Google Sheet you choose.

Logic

Look up keyword ideas

JavaScript calls the Google Ads Keyword Planner API and returns related keywords with volume, competition, and bid estimates. Put the Google Ads developer token in that JavaScript node.

Action

Write the research rows

Google Sheets appends a row per keyword with the metrics you map.

Setup guide

Connect Google Sheets

Add a Google Sheets connection. Use one worksheet for seed keywords and another for results, or keep seeds and results in separate column ranges.

Point the trigger at the seed sheet

Add a Google Sheets trigger for new rows and select the seed spreadsheet and worksheet.

Store the Google Ads credentials

Add a JavaScript node that calls the Google Ads Keyword Planner API. Put the developer token, customer ID, and OAuth refresh details in that JavaScript node.

Map the result columns

Append Google Sheets rows from the JavaScript output. Map keyword, monthly searches, competition, and bid estimates, then add a sample seed row to confirm.

Requirements

A Google Sheet Latenode can read and append to

A Google Ads developer token and customer ID stored in the JavaScript node

Keyword Planner access on that Google Ads account

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.

Contact support →

More templates

Browse all templates →

Comprehensive SEO Audit and Optimization Automation

This template starts when you post a website URL to a Latenode webhook. An HTTP request downloads the HTML. JavaScript extracts title, meta, headings, and image alts. OpenAI GPT Assistants reviews that on-page copy. A second HTTP request calls Google PageSpeed Insights with the PageSpeed API key on that request. JavaScript merges the findings into an HTML report, and MailerSend emails it. Connect OpenAI GPT Assistants and MailerSend.

32s$0.0020

Automatically receive SMS alerts for new YouTube videos

This template watches a YouTube channel for new uploads, builds a short text with the video title and link in JavaScript, and sends that SMS with Twilio. Connect YouTube and Twilio. Point the trigger at the channel you want to watch. Put the Twilio Account SID and Auth Token on the Twilio connection.

5s$0.0003

Automatically sync Big Cartel orders to Google Analytics 4

This template receives each Big Cartel order on a webhook, maps order id, total, and items in JavaScript, and sends a purchase event to Google Analytics 4. Point Big Cartel at the Latenode webhook URL. Connect Google Analytics and put access on that connection. Use a JavaScript node to shape the event name and parameters GA4 expects.

10s$0.0006