Latenode
Google sheets

Automate SEO Keyword Tracking and Research in Google Sheets

This Latenode automation template allows users to easily track SEO keyword rankings and research keyword data using the Semrush API, with the results automatically saved into a Google Sheets spreadsheet.

The workflow is triggered when a user submits a form with a keyword and country, and it then queries the Semrush Keyword Research API to retrieve comprehensive data like search volume, cost-per-click, competition, and related keywords. This information is then appended to the connected Google Sheets document for seamless tracking and analysis. The automation eliminates the need for manual keyword research and data entry, enabling users to scale their SEO efforts and make data-driven decisions based on reliable, up-to-date insights.

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

  • Queries the Semrush Keyword Research API to retrieve data like search volume, cost-per-click, competition, and related keywords.
  • Appends the keyword data to a connected Google Sheets spreadsheet for tracking and analysis.
  • Eliminates the need for manual keyword research and data entry.
  • Enables users to scale their SEO efforts and make data-driven decisions.
  • Delivers a Google Sheets spreadsheet with up-to-date keyword performance insights.

How it works

1
Trigger

Keyword and Country Input Form

The workflow is triggered when a user submits a form with a keyword and country to track.

2
Logic

Keyword Research using Semrush API

The submitted keyword and country are used to query the Semrush Keyword Research API, which retrieves comprehensive data such as search volume, cost-per-click, competition, and related keywords.

3
Action

Append to Google Sheets

The keyword research data is then automatically appended to a connected Google Sheets spreadsheet for seamless tracking and analysis.

Setup guide

1

Add Semrush Keyword Research API credential

Add your Semrush Keyword Research API key in the Latenode Credentials panel. This allows the workflow to securely authenticate and make API requests to retrieve keyword data.

2

Configure Google Sheets integration

In the Latenode builder, add a Google Sheets node and configure it with the Google Sheets document ID and sheet name where you want the keyword research data to be stored.

3

Set up form trigger

Add a Form trigger node in the Latenode builder and configure it to collect the 'Keyword' and 'Country' inputs from your users.

4

Map API response data to Google Sheets

In the Google Sheets node settings, map the relevant fields from the Semrush Keyword Research API response (e.g., keyword, search volume, CPC, competition) to the corresponding columns in your Google Sheets spreadsheet.

5

Test and publish the workflow

Test the full workflow by providing sample 'Keyword' and 'Country' inputs, then publish the Latenode automation template so your users can access and use it.

Requirements

Connect a Google Sheets account and have edit access to the target spreadsheet
Obtain a Semrush API key with access to the Keyword Research API
Set up a Latenode JavaScript node with the necessary code to query the Semrush API and append data to Google Sheets
Configure Latenode variables to store the Semrush API key and Google Sheets connection details

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