Latenode
Ahrefs
Supabase

Automate Ahrefs-powered SEO keyword research and insights with Gemini

This Latenode automation helps SEO specialists, content marketers, and digital agencies gain valuable insights into keyword opportunities to boost their rankings. It automates the SEO keyword research process by querying the Ahrefs API for keyword data and related insights.

The enriched data is then processed by an AI agent, the Google Gemini language model, to format a response and provide actionable SEO recommendations. This end-to-end workflow can be triggered by a chat message and leverages integrations with the Ahrefs API and Google Gemini to deliver SEO and marketing analytics insights.

Updated Apr 6, 2026Est. run: 25sEst. cost: $0
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

  • Queries the Ahrefs API to retrieve keyword data and related insights
  • Processes the data using the Google Gemini language model to generate SEO recommendations
  • Formats the response with actionable insights for SEO specialists and content marketers
  • Triggers the workflow via a chat message and integrates with Ahrefs and Google Gemini
  • Delivers a table of high-volume, relevant keywords and content strategy recommendations

How it works

1
Trigger

Incoming Chat Message

The workflow is triggered by an incoming chat message from the user, containing their SEO keyword query.

2
Action

Keyword Query Extraction & Cleaning

The user's SEO keyword query is extracted and cleaned from the incoming chat message.

3
Action

Ahrefs Keyword API Request

The cleaned keyword query is used to make a request to the Ahrefs API, retrieving keyword data and insights.

4
Action

Extract Main Keyword & Related Keywords

The Ahrefs API response is processed to extract the main keyword and related keyword data.

5
Action

Store Keyword Data

The extracted main keyword and related keyword data is saved to a Supabase database for future reference.

6
Action

Keyword Data Response Formatter

The keyword data is formatted into a clean, readable text response.

7
AI

Google Gemini Chat Model

The formatted keyword data is passed through the Google Gemini language model, which analyzes the information and provides SEO insights and recommendations.

8
Action

Response Delivery

The SEO insights and recommendations generated by the Google Gemini model are sent back to the user through the chat interface.

Setup guide

1

Add Ahrefs API Credential

In the Latenode Credentials panel, add a new credential for the Ahrefs API. Enter your Ahrefs API key in the API key field.

2

Configure Ahrefs API Node

In the Latenode visual builder, add an Ahrefs API node. In the node settings, select the Ahrefs credential you created earlier. Then, map the input data (such as the keyword query) to the node's input fields.

3

Configure Google Gemini Node

Add a Google Gemini node to your workflow. In the node settings, configure the connection to the Google Gemini 1.5 Flash language model. Map the data output from the Ahrefs API node to the Google Gemini node's input fields.

4

Add Supabase Credential

In the Latenode Credentials panel, add a new credential for Supabase. Enter your Supabase project URL and API key in the respective fields.

5

Configure Supabase Node

Add a Supabase node to your workflow. In the node settings, select the Supabase credential you created earlier. Map the output data from the Google Gemini node to the Supabase node's input fields to store the SEO insights and recommendations.

Requirements

Ahrefs API key to query keyword data
Google Gemini API key to utilize the language model for content insights
Supabase database connection to store and retrieve processed data
Latenode workspace access to run the automation flow, including the JavaScript and headless browser nodes

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