🔍 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