Latenode

Automate Ahrefs-powered SEO keyword research and insights with Gemini

This template starts when a keyword is posted to a Latenode webhook. JavaScript cleans the query. Ahrefs returns related keywords and metrics. Gemini writes ranking and content notes.

Supabase stores the research row, and the webhook response sends the notes back. Connect Ahrefs, Google AI, and Supabase. Put the Ahrefs API key on the Ahrefs connection. Put the Google AI API key on the Google AI connection.

Updated Sep 16, 2026Est. run: 19sEst. cost: $0.0012
How Latenode estimates time and cost

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

  • Turns a keyword you send into Ahrefs metrics plus Gemini notes
  • Keeps the Ahrefs API key on the Ahrefs connection
  • Stores the research row in Supabase
  • Returns the notes on the webhook response

How it works

1
Trigger

Receive the keyword

The scenario starts when a keyword query is posted to your Latenode webhook.

2
Action

Pull Ahrefs keyword data

Ahrefs returns related keywords and metrics for that query.

3
Action

Store the research row

JavaScript flattens the metrics. Supabase writes a row with the seed keyword and related terms.

4
AI

Write SEO notes

Gemini turns those metrics into ranking and content notes. The webhook response sends that text back.

Setup guide

1

Add a webhook trigger

Add a webhook trigger and copy its URL. Point your chat, form, or HTTP client at that URL and send the keyword query.

2

Connect Ahrefs

Add an Ahrefs connection and paste your Ahrefs API key there. Run Keywords Explorer for the cleaned query.

3

Connect Google AI and Supabase

Add a Google AI connection and paste your Google AI API key there. Add a Supabase connection with the project URL and service key. Create a row with the seed keyword and related terms, then send the flattened metrics to Gemini.

4

Return the notes

Map Gemini's notes onto the webhook response. Post a sample keyword and confirm both the Supabase row and the returned text.

Requirements

An Ahrefs account and API key stored on the Ahrefs connection
A Google AI API key stored on the Google AI connection
A Supabase table Latenode can write to
A Latenode webhook URL that receives the keyword

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.