Latenode
Google Ads
Google sheets

Automate Keyword Research and Search Volume Data Collection

This automation workflow generates new keywords and retrieves their corresponding search volume data from the Google Ads API, which can then be saved into a spreadsheet. It is designed to streamline keyword research and data collection processes for users looking to optimize their SEO or Google Ads campaigns.

The workflow triggers manually or via a webhook, taking an array of initial keywords as input. It then calls the Google Ads API to fetch new keyword ideas and associated metrics, such as search volume, competition, and bid estimates. The processed data is then written to a Google Sheet, allowing users to further analyze and utilize the information for their marketing efforts.

Updated Apr 2, 2026Est. run: 7sEst. cost: $0.0004
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. 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 credits work →
SEO, marketing & analytics

Workflow preview

What this template does

  • Triggers workflow manually or via webhook to generate new keywords
  • Calls Google Ads API to fetch keyword ideas and associated metrics
  • Extracts search volume, competition, and bid estimate data for each keyword
  • Normalizes and stores the processed data in a Google Sheet
  • Allows users to further analyze and optimize SEO or Google Ads campaigns

How it works

1
Trigger

Generate Keywords

The workflow is triggered manually or via a webhook, taking an array of initial keywords as input. It then calls the Google Ads API to fetch new keyword ideas and associated metrics, such as search volume, competition, and bid estimates.

2
Logic

Split & Transform

The retrieved keyword data is extracted and formatted for further processing. This step involves splitting the results into individual keywords and transforming the data into a structured format.

3
Action

Save to Google Sheet

The processed keywords and their corresponding search volume data are written to a Google Sheet, allowing users to further analyze and utilize the information for their marketing efforts.

Setup guide

1

Add Google Ads credential

Add your Google Ads API credentials (customer ID, developer token, and login customer ID) to the Latenode Credentials panel.

2

Configure Google Ads API node

In the Latenode visual builder, add a 'Google Ads API' node and select the credential you added in the previous step.

3

Map input keywords

Add a 'Set Keywords' node and map the input keywords to the workflow.

4

Configure Google Sheet output

Add a 'Google Sheets' node and specify the Google Sheet document and sheet name where you want to write the keyword data.

5

Customize workflow

Review and customize the workflow as needed, such as adjusting the data fields extracted or the Google Ads API parameters.

Requirements

Connect a Google Ads account with the necessary permissions to access the Google Ads API
Ensure access to the Google Ads API within the Latenode workspace
Configure the Google Sheets integration to write data to a designated spreadsheet
Provide a list of initial keywords as input to the workflow

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

You might also like

Browse all templates →
SEO, marketing & analytics

Comprehensive SEO Audit: Boost Website Performance and Rankings

The SEO On-site Audit workflow is an automated tool that provides a comprehensive analysis of a website's technical health, content quality, and user experience. By integrating with the Google PageSpeed API and DeepSeek API, the workflow collects and analyzes vital on-site data, including metadata, headings, links, and site speed. It then generates detailed, actionable reports with recommendations for improving search engine visibility and rankings. This turnkey solution enables users to optimize website performance and search rankings effortlessly, with the ability to scale audits across single pages or entire website portfolios.

31s$0.0019
SEO, marketing & analytics

Sync Google Ads search volume to your Google Sheet for SEO insights

This automation helps users retrieve search volume data for a list of SEO keywords from the Google Ads API, and automatically populate the results back into a Google Sheet. It enables users to generate accurate search volume data, identify seasonal trends, assess keyword difficulty, and gather data-driven insights to inform their SEO campaigns. The workflow connects to the Google Ads API to fetch the monthly search volume, historical trends, and competition metrics for each keyword. Users can customize the list of keywords and choose their own database or storage system to store the generated data.

9s$0.0006
SEO, marketing & analytics

Receive SMS alerts when new YouTube videos are published

This Latenode automation allows users to monitor a specific YouTube channel or keyword, and automatically receive SMS notifications via a service like Twilio or an SMS carrier whenever a new video is published. The integration is triggered by a 'New Video in Channel' event that monitors the specified YouTube channel, and then sends an SMS message with details about the new video, including the title and a link. This automation is designed to help users stay up-to-date on the latest content from their favorite YouTube creators or their own channel, without having to manually check for updates.

8s$0.0005