Analyze competitor keywords with RapidAPI and Google Sheets reporting

🔍 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](https://rapidapi.com/PrineshPatel/api/competitor-keyword-analysis). 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](https://rapidapi.com/PrineshPatel/api/competitor-keyword-analysis) with form input to fetch keyword data.