Skip to main content

Analyze competitor keywords with RapidAPI and Google Sheets reporting

n8n Cloud
$20/month : Unlimited workflows
2500 executions/month
Try free
Bright Data
THE #1 IN WEB SCRAPING
Scrape any website without limits
Try free
HOSTINGER 🎉 Early Black Friday Deal
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
Try free
Apify
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Try free

🔍 Analyze Competitor Keywords with RapidAPI and Google Sheets Reporting

📄 Description

This n8n workflow streamlines the process of analyzing SEO competitor keywords using the Competitor Keyword Analysis API on RapidAPI. It collects a website and country via form submission, calls the API to retrieve keyword metrics, reformats the response, and logs the results into Google Sheets — all automatically.

It is ideal for SEO analysts, marketing teams, and agencies who need a hands-free solution for competitive keyword insights.

🧩 Node-by-Node Explanation

  1. 📝 On form submission (formTrigger)
    Starts the workflow when a user submits their website and country through a form.

  2. 🌐 Competitor Keyword Analysis (httpRequest)
    Sends a POST request to the Competitor Keyword Analysis API on RapidAPI with form input to fetch keyword data.

  3. 🔄 Reformat Code (code)
    Extracts the domainOrganicSearchKeywords array from the API response for structured processing.

  4. 📊 Google Sheets (googleSheets)
    Appends the cleaned keyword metrics into a Google Sheet for easy viewing and tracking.

🚀 Benefits of This Workflow

  • ✅ Automates SEO research using the Competitor Keyword Analysis API.
  • ✅ Eliminates manual data entry — results go straight into Google Sheets.
  • ✅ Scalable and reusable for any number of websites or countries.
  • ✅ Reformatting logic is built-in, so you get clean, analysis-ready data.

💼 Use Cases

  1. Marketing Agencies
    Use the Competitor Keyword Analysis API to gather insights for client websites and store the results automatically.

  2. In-house SEO Teams
    Quickly compare keyword performance across competitors and monitor shifts over time with historical Google Sheets logs.

  3. Freelancers and Consultants
    Provide fast, data-backed SEO reports using this automation with the Competitor Keyword Analysis API.

  4. Keyword Research Automation
    Make this flow part of a larger system for identifying keyword gaps, content opportunities, or campaign ideas.

📁 Output Example (Google Sheets)

keyword searchVolume cpc competition position previousPosition keywordDifficulty
best laptops 9900 2.3 0.87 5 7 55

🔐 How to Get Your API Key for the Competitor Keyword Analysis API

  1. Go to 👉 Competitor Keyword Analysis API - RapidAPI
  2. Click "Subscribe to Test" (you may need to sign up or log in).
  3. Choose a pricing plan (there’s a free tier for testing).
  4. After subscribing, click on the "Endpoints" tab.
  5. Your API Key will be visible in the "x-rapidapi-key" header.

🔑 Copy and paste this key into the httpRequest node in your workflow.

✅ Summary

This workflow is a powerful no-code automation tool that leverages the Competitor Keyword Analysis API on RapidAPI to deliver real-time SEO insights directly to Google Sheets — saving time, boosting efficiency, and enabling smarter keyword strategy decisions.

Create your free n8n account and set up the workflow in just a few minutes using the link below:

👉 Start Automating with n8n