Latenode
Google sheets
HTTP Request

Automatically track keyword rankings in Google Sheets

This no-code n8n workflow automates the process of looking up keyword rankings in real-time using the SERP Keyword Ranking Checker API and logs the data into a Google Sheet for tracking and analysis.

Designed for SEO professionals, digital marketers, or anyone who needs to monitor keyword visibility across different regions, the workflow is triggered by a form submission where the user enters a keyword and a country to research. The workflow sends a request to the SERP Keyword Ranking Checker API, and based on the response, it either appends the actual SERP data to the Google Sheet or logs a 'No result found' message. This automated process allows users to easily monitor and analyze their keyword rankings without the need for manual data entry.

Updated Apr 6, 2026Est. run: 26sEst. cost: $0.0703
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

  • Looks up real-time SERP rankings for specified keywords and countries using the SERP Keyword Ranking Checker API.
  • Appends SERP data to a Google Sheets document for tracking and analysis.
  • Logs 'No result found' when the API returns no data for a query.
  • Automates the keyword ranking lookup process to save time for SEO professionals and digital marketers.
  • Provides a centralized view of keyword visibility data across multiple regions in a spreadsheet.

How it works

1
Trigger

Keyword and Country Input

The workflow is triggered by a form submission where the user enters a keyword and a country to research.

2
Action

Store Keyword and Country

The keyword and country entered by the user are stored as global variables in a Google Sheets spreadsheet.

3
Logic

Check SERP Results

The workflow checks whether the SERP (Search Engine Results Page) data for the given keyword and country is not empty.

4
Action

Fetch Ranking Data

If the SERP data is not empty, the workflow fetches the actual ranking data for the keyword and country from the SERP Keyword Ranking Checker API.

5
Action

Store SERP Data

The fetched SERP data is appended to the Google Sheets spreadsheet.

6
Action

Log 'No Result Found'

If the SERP data is empty, the workflow logs a 'No result found' message in the Google Sheets spreadsheet.

7
Logic

Delay Before Next Cycle

The workflow pauses for a set duration before proceeding to the next iteration or completing the process.

8
Action

Append Data to Spreadsheet

The workflow appends the fetched or 'No result found' data to the Google Sheets spreadsheet for tracking and analysis.

Setup guide

1

Add RapidAPI Credential

1. Go to the Latenode Credentials panel. 2. Click 'Add new credential'. 3. Select 'RapidAPI' as the integration. 4. Enter your RapidAPI API key.

2

Configure Google Sheets Integration

1. Go to the Latenode Credentials panel. 2. Click 'Add new credential'. 3. Select 'Google Sheets' as the integration. 4. Authenticate your Google account and grant access to your Google Sheets. 5. In the Google Sheets node settings, select the spreadsheet and worksheet you want to use.

3

Set Up Form Trigger

1. Add a Form Trigger node to the canvas. 2. Configure the form fields to capture the 'Keyword' and 'Country' inputs from the user.

4

Call SERP Keyword Ranking Checker API

1. Add an HTTP Request node to the workflow. 2. Configure the node to send a request to the SERP Keyword Ranking Checker API endpoint. 3. Map the 'Keyword' and 'Country' inputs from the Form Trigger node to the API request parameters.

5

Log SERP Data to Google Sheets

1. Add a Google Sheets node to the workflow. 2. Configure the node to append the SERP results data to the selected spreadsheet and worksheet. 3. Map the relevant data from the HTTP Request node's response to the Google Sheets node's input fields.

Requirements

Create an API key with the SERP Keyword Ranking Checker API from RapidAPI
Set up a Google Sheets document to store the keyword ranking data
Grant the n8n workflow access to the Google Sheets document using a Google OAuth2 credential
Configure the n8n workflow to use the SERP Keyword Ranking Checker API key and the Google Sheets document access

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 and Optimization Automation

The SEO & marketing analytics automation template provides a comprehensive analysis of a website's technical health, content quality, and user experience to identify issues and deliver actionable recommendations for improving search engine visibility and rankings. The workflow fetches the website content, analyzes various on-page elements like meta tags, headings, images, and content using language models and PageSpeed Insights, and generates an HTML report with optimization suggestions. The report is then emailed to stakeholders, enabling data-driven decisions to enhance the website's SEO performance. This automation streamlines the SEO audit process, saving time and resources while ensuring a thorough examination of the website's SEO-critical factors.

26s$0.0703
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

Automatically receive SMS alerts for new YouTube videos

The automation template allows users to monitor a specific YouTube channel or keyword, and automatically receive SMS notifications whenever a new video is published. This functionality is particularly useful for SEO and marketing analytics, enabling users to stay up-to-date on their competitors' content and activities. The automation integrates with a video monitoring service and a messaging platform like Twilio or an SMS carrier to deliver the notifications. By automating this process, users can streamline their content monitoring and stay informed without the need for manual checks.

26s$0.0703