Latenode
Google sheets
Gmail
WhatsApp Business Cloud

Automatically track & store Google SERP keyword rankings in Google Sheets

This Latenode automation template helps SEO professionals and marketers automatically track the ranking of specific keywords in Google's search results and save the position data directly into a Google Sheets spreadsheet using the SerpAPI integration.

The workflow is triggered on a user-defined schedule, fetches the current SERP positions, logs the data in Google Sheets, and sends notifications via WhatsApp or email when a keyword's ranking changes. This reduces the manual effort required to monitor keyword positions and provides timely alerts on ranking fluctuations.

Updated Apr 2, 2026Est. run: 16sEst. 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 the current Google Search rankings for specified keywords
  • Logs the keyword positions in a Google Sheets spreadsheet
  • Sends notifications via WhatsApp or email when rankings change
  • Reduces manual effort to monitor keyword positions
  • Provides timely alerts on ranking fluctuations

How it works

1
Trigger

Schedule Automation

The automation is triggered on a user-defined schedule, such as daily or weekly, to periodically check the rankings of target keywords in Google Search.

2
Action

Configure Tracked Keywords

The user specifies the keywords to be tracked in a Google Sheets spreadsheet, which serves as the data source for the automation.

3
Action

Fetch Google SERP Data

The automation uses a headless browser to fetch the current Google search engine results pages (SERPs) for the configured keywords.

4
Logic

Process SERP Results

The automation analyzes the SERP data, extracts the ranking positions for the tracked keywords, and maps the organic results.

5
Action

Update Keyword Rankings in Google Sheets

The automation logs the new ranking data for each keyword directly into the Google Sheets spreadsheet and marks the rows as 'checked'.

6
Logic

Detect Ranking Changes

The automation compares the new rankings with the previous data to detect any improvements or drops in keyword positions.

7
Action

Send Email Notifications

When a keyword's ranking changes, the automation sends notifications via email to the user or team.

8
Action

Send WhatsApp Notifications

In addition to email, the automation can also send notifications about ranking changes via WhatsApp Business Cloud.

Requirements

Google API credentials (Client ID, Client Secret) with access to the Google Sheets API
Google Sheets spreadsheet with write access for the Google API credentials
SerpAPI API key to fetch search engine results
Latenode workspace with access to the Google Sheets, Email, and WhatsApp Business Cloud integrations

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