Scrape and log your website's on-page SEO metrics to Google Sheets

This template runs on a schedule, reads the URLs you track from Google Sheets, calls an on-page SEO API on RapidAPI from JavaScript, and appends title, meta, headings, and similar metrics as a new row. Connect Google Sheets. Put the RapidAPI key in the JavaScript node that makes the request.

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 on-page SEO metrics in Google Sheets on a schedule
Reads the URL list from the sheet you connect
Calls the RapidAPI on-page endpoint from JavaScript
Keeps the RapidAPI key in the JavaScript node

How it works

Trigger

Run on a schedule

A schedule starts the scenario at the time you choose.

Action

Read URLs and fetch on-page data

Google Sheets loads the URL list. JavaScript calls the RapidAPI on-page SEO endpoint for each URL.

Action

Log a row in Google Sheets

Each result is appended as a row with the metrics you map, plus the check time.

Setup guide

Connect Google Sheets

Add a Google Sheets connection. Use a tab with the URLs to check and a results tab for new rows.

Store the RapidAPI key

Add a JavaScript node and put your RapidAPI key there. Call the on-page SEO endpoint from that node.

Map columns and schedule

Map URL, title, meta description, H1, word count, and checked-at into Add Single Row. Set the schedule to daily or weekly. Run once by hand to confirm a row lands.

Requirements

A Google Sheet with the URLs you want to check

A RapidAPI account and key stored in the JavaScript node

Access to an on-page SEO API on RapidAPI

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