HTTP Request

JavaScript

Google Sheets

Automatically track keyword rankings in Google Sheets

This template starts when you POST a keyword and country to a Latenode webhook, calls a SERP ranking endpoint over HTTP, and appends the results to Google Sheets.

Put the RapidAPI key on that HTTP request. Connect Google Sheets. If the API returns no hits, JavaScript writes a no-result row so the log stays complete.

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

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 live SERP ranks in Google Sheets
Starts from a keyword and country on the webhook
Calls RapidAPI from the HTTP request
Writes a no-result row when the API is empty

How it works

Trigger

Receive keyword and country

The scenario starts when a form or app POSTs keyword and country to your webhook.

Action

Look up the ranking

An HTTP request calls the SERP ranking API with that keyword and country. Put the RapidAPI key on that request.

Logic

Shape the row

JavaScript flattens the hits, or writes a no-result line when the API is empty.

Action

Append to Google Sheets

Google Sheets gets a new row with keyword, country, rank, and URL.

Setup guide

Add a webhook trigger

Add a webhook trigger and copy its URL. Point your form or app at that URL and send keyword and country.

Connect Google Sheets

Add a Google Sheets connection. Use a tab with columns for keyword, country, rank, URL, and checked-at.

Call the ranking API

Add an HTTP request to the SERP Keyword Ranking Checker endpoint on RapidAPI. Put the RapidAPI key on that HTTP request. Map keyword and country from the webhook.

Write the sheet row

Flatten the response in JavaScript, then append a Google Sheets row. If there are no hits, still append a no-result row.

Requirements

A RapidAPI key for the SERP Keyword Ranking Checker, stored on the HTTP request

A Google Sheet you can append to

A form or app that can POST keyword and country to the webhook

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