Latenode
Google sheets
Google Programmable Search Engine

Streamline daily keyword research with Google Sheets and API integrations

This automation simplifies the daily keyword research process by fetching data from the Google Suggest and Google Custom Search APIs, and storing the results in a Google Sheets spreadsheet. It is designed for SEO specialists, marketers, bloggers, and content creators who want to streamline their keyword research workflows.

The automation starts by reading a list of keywords from a Google Sheet, selects one keyword per day, and then queries the Google Suggest API for autocomplete suggestions. It then calls the Google Custom Search API to retrieve the top results for each suggestion, including titles, links, and snippets. The final output is structured JSON data that can be used to power content pipelines, research trends, or generate AI-driven content.

Updated Apr 2, 2026Est. run: 15sEst. cost: $0.001
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

  • Fetches keyword suggestions from the Google Suggest API
  • Retrieves top search results from the Google Custom Search API
  • Stores the keyword data in a Google Sheets spreadsheet
  • Structures the results as JSON for downstream use
  • Automates the daily keyword research process

How it works

1
Trigger

Read Keywords from Google Sheet

The automation starts by reading a list of keywords from a Google Sheets spreadsheet.

2
Logic

Select Daily Keyword

The automation selects one keyword from the list based on the current date.

3
Action

Get Autocomplete Suggestions

The automation queries the Google Suggest API to fetch autocomplete suggestions for the selected keyword.

4
Action

Search Google for Suggestions

The automation then calls the Google Custom Search API to retrieve the top results for each autocomplete suggestion, including titles, links, and snippets.

5
Action

Format Search Results

The automation structures the Google Custom Search data as JSON.

6
Action

Write Results to Google Sheet

The structured keyword research data is stored in the Google Sheets spreadsheet.

Setup guide

1

Connect Google Sheets Credential

Add your Google Sheets OAuth2 credential in the Latenode Credentials panel. This allows the workflow to securely access your Google Sheets data.

2

Configure Google Custom Search Credential

Add your Google Custom Search API credential in the Latenode Credentials panel. Use environment variables or Latenode Secrets to securely store your API key and Custom Search ID (CX).

3

Select Google Sheet with Keyword List

In the Google Sheets node settings, specify the ID of the Google Sheet that contains your list of keywords in a column labeled 'Title' or 'Keyword'.

4

Configure Keyword Selection Logic

In the 'Select Daily Keyword' JavaScript node, update the logic to select a new keyword based on the number of days since a specific start date (e.g., July 4, 2025).

5

Review and Run Workflow

Review the complete workflow in the Latenode visual builder, make any necessary adjustments, and then run the workflow manually to initiate the keyword research process.

Requirements

A Google Sheets spreadsheet with a sheet containing the list of keywords to research
A Google Cloud Platform account with the Google Custom Search API and Google Sheets API enabled
A Google Custom Search Engine ID for the API to query
A Google Cloud API key with access to the Google Custom Search API and Google Sheets API
The Latenode workspace set up with the HTTP Request, Google Sheets, and Google Programmable Search Engine nodes
The Latenode workspace configured with the necessary API keys, spreadsheet ID, and search engine ID as secure variables

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