Google Sheets

HTTP Request

JavaScript

Gmail

WhatsApp Personal Account

Sync Google Sheets with Google Search rankings using SerpAPI

This template runs on the schedule you set, reads keywords from Google Sheets, and looks up each rank with SerpAPI.

JavaScript compares the new position to the last row, then Google Sheets logs keyword, rank, and URL. Gmail and WhatsApp send a message when a rank improves or drops. Put the SerpAPI key on the HTTP request. Connect Google Sheets, Gmail, and WhatsApp.

Updated Sep 16, 2026Est. run: 25sEst. cost: $0.0016

Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. 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 CPU seconds work →

Workflow preview

What this template does

Logs Google Search ranks in Google Sheets on a schedule
Calls SerpAPI from the HTTP request
Keeps the SerpAPI key on that HTTP request
Emails and WhatsApps you when a rank improves or drops

How it works

Trigger

Run on a schedule

The scenario starts on the schedule you set, typically once a day.

Action

Look up each keyword

Google Sheets returns the keyword list. An HTTP request calls SerpAPI for the current rank. Put the SerpAPI key on that HTTP request.

Logic

Compare and log

JavaScript compares the new rank to the previous row. Google Sheets appends keyword, rank, URL, and change.

Action

Notify when rank moves

Gmail and WhatsApp send a message when the position improves or drops.

Setup guide

Connect Google Sheets

Add a Google Sheets connection. Keep keywords on one tab and a log tab for rank, URL, and checked-at.

Call SerpAPI

Add an HTTP request to the SerpAPI search endpoint. Put the SerpAPI key on that HTTP request. Map each keyword and the country you track.

Connect Gmail and WhatsApp

Add Gmail and WhatsApp connections for the alerts. Send when JavaScript marks a rank as improved or dropped.

Set the schedule and test

Run daily. Read keywords, look up ranks, append the log row, and send alerts when a position moves. Confirm a sample keyword in the sheet.

Requirements

A SerpAPI key stored on the HTTP request

A Google Sheet with a keyword tab and a ranking log tab

Gmail and WhatsApp accounts for movement alerts

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

Browse all templates →

Comprehensive SEO Audit and Optimization Automation

This template starts when you post a website URL to a Latenode webhook. An HTTP request downloads the HTML. JavaScript extracts title, meta, headings, and image alts. OpenAI GPT Assistants reviews that on-page copy. A second HTTP request calls Google PageSpeed Insights with the PageSpeed API key on that request. JavaScript merges the findings into an HTML report, and MailerSend emails it. Connect OpenAI GPT Assistants and MailerSend.

32s$0.0020

Automatically receive SMS alerts for new YouTube videos

This template watches a YouTube channel for new uploads, builds a short text with the video title and link in JavaScript, and sends that SMS with Twilio. Connect YouTube and Twilio. Point the trigger at the channel you want to watch. Put the Twilio Account SID and Auth Token on the Twilio connection.

5s$0.0003

Automatically sync Big Cartel orders to Google Analytics 4

This template receives each Big Cartel order on a webhook, maps order id, total, and items in JavaScript, and sends a purchase event to Google Analytics 4. Point Big Cartel at the Latenode webhook URL. Connect Google Analytics and put access on that connection. Use a JavaScript node to shape the event name and parameters GA4 expects.

10s$0.0006