Latenode
Google Programmable Search Engine
Google sheets
Gmail
WhatsApp Personal Account

Sync Google Sheets with Google Search rankings using SerpAPI

This n8n workflow automates scheduled checks for your target keywords' positions in Google's organic search results using SerpAPI.

It logs new positions in Google Sheets, compares them to previous rankings, and sends notifications via WhatsApp and/or email based on the movement. This workflow is ideal for SEO specialists monitoring keyword rankings, website owners tracking performance, and agencies managing SEO campaigns.

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

  • Retrieves the current ranking positions for specified keywords in Google's organic search results using SerpAPI.
  • Logs the keyword positions in a Google Sheets spreadsheet for historical tracking and analysis.
  • Compares current rankings to previous positions and identifies changes in keyword performance.
  • Sends notifications via WhatsApp and/or email when keyword rankings fluctuate beyond a specified threshold.
  • Provides a comprehensive report of keyword ranking data stored in the Google Sheets spreadsheet.

How it works

1
Trigger

Schedule Workflow to Run Automatically

The workflow is triggered on a regular schedule to automatically check the target keywords' rankings in Google search results.

2
Logic

Set Keywords to Track

The user configures the specific keywords they want to monitor for their SEO or website performance tracking needs.

3
Action

Fetch Current Google SERP Rankings

The workflow uses the Google Programmable Search Engine integration to fetch the current rankings and URLs for the target keywords in Google's organic search results.

4
Logic

Map Organic Search Results

The JavaScript code node extracts the rank and URL information from the SERP response for each target keyword.

5
Action

Lookup Previous Rank from Google Sheets

The workflow looks up the previous rank for each keyword from the Google Sheets spreadsheet where the historical data is stored.

6
Logic

Detect Rank Changes

The JavaScript code compares the current and previous ranks to determine if the keyword's position has improved, dropped, or stayed the same.

7
Action

Log New Rank in Google Sheets

The new rank and status for each keyword is stored in the Google Sheets spreadsheet for historical tracking.

8
Logic

Route to Improved or Dropped Notifications

The workflow routes the results to the appropriate notification paths based on whether the keyword rank has improved or dropped.

9
Action

Send Email - Improved

If the keyword rank has improved, the workflow sends an email notification to the user or team.

10
Action

Send WhatsApp - Improved

If the keyword rank has improved, the workflow also sends a WhatsApp notification to the user or team.

11
Action

Send Email - Dropped

If the keyword rank has dropped, the workflow sends an email notification to the user or team.

12
Action

Send WhatsApp - Dropped

If the keyword rank has dropped, the workflow also sends a WhatsApp notification to the user or team.

Setup guide

1

Add Google Search Console Credential

1. Go to the Latenode Credentials panel. 2. Click 'Add Credential' and select the 'Google Programmable Search Engine' integration. 3. Follow the authentication flow to grant Latenode access to your Google Search Console account.

2

Configure Google Sheets Integration

1. In the Latenode builder, add a 'Google Sheets' node. 2. In the node settings, select the Google Sheets credential you added earlier. 3. Specify the Google Sheets spreadsheet and tab where you want to log the keyword positions.

3

Set Target Keywords

1. In the Latenode builder, add a 'Set' node. 2. In the node settings, define the target keywords you want to track in the Google search results.

4

Configure Notification Channels

1. In the Latenode builder, add a 'Gmail' node and a 'WhatsApp' node. 2. In the 'Gmail' node settings, enter your Gmail credential details. 3. In the 'WhatsApp' node settings, connect your WhatsApp Business API credential.

5

Review and Deploy Workflow

1. Review the entire workflow in the Latenode builder to ensure all nodes are configured correctly. 2. Click 'Deploy' to publish the workflow and make it available for scheduled runs.

Requirements

Create a Google Programmable Search Engine API key and enable the Programmable Search Engine API in your Google Cloud Console
Set up a Google Sheets spreadsheet to store the keyword ranking data
Enable the Google Sheets API and create credentials (Service Account or OAuth) to access the spreadsheet
Configure a WhatsApp Business API account and obtain the necessary credentials (phone number, access token) to send notifications

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