Templates / Automated SEO Keyword Tracking and Research via Semrush API in Google Sheets

Automated SEO Keyword Tracking and Research via Semrush API in Google Sheets

Ready for 3.0

by Evoort Solutions ✓ · 1,331 views · created 2025-08-20 · Market Research

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 3 nodes and runs when someone submits an n8n form (“Keyword Research ”). Along the way it connects Google Sheets. It also calls semrush-keyword-research-tool.p.rapidapi.com over HTTP.

How it runs

Trigger: When someone submits an n8n form (“Keyword Research ”).

Keyword Research (HTTP Request): calls semrush-keyword-research-tool.p.rapidapi.com (POST)
Append Data to Google Sheet (Google Sheets): append

Services it uses

Google Sheets

HTTP calls to: semrush-keyword-research-tool.p.rapidapi.com

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (3)

n8n Form Triggern8n-nodes-base.formTrigger
HTTP Requestn8n-nodes-base.httpRequest
Google Sheetsn8n-nodes-base.googleSheets

From the author

🔎 Automated Keyword Research Workflow with Google sheet logging & Semrush API Description: Easily collect keywords and country input, run automated keyword research via the Semrush Keyword Research API on RapidAPI, and store results in Google Sheets for…
Excerpt from Evoort Solutions's description on n8n.io.

View the original on n8n.io → Check your own copy

Automated SEO Keyword Tracking and Research via Semrush API in Google Sheets

What this workflow does

How it runs

Services it uses

Before you upgrade to n8n 3.0

Nodes used (3)

From the author

Get the weekly “what broke” email