Automated SEO keyword analysis with RapidAPI and Google Sheets

🚀 Automated Keyword Analysis with On-Page SEO Workflow

📌 Description Boost your SEO strategy by automating keyword research and on-page SEO analysis with n8n. This workflow uses user input (keyword + country), retrieves essential data using the powerful [SEO On-Page API](https://rapidapi.com/PrineshPatel/api/seo-on-page), and saves it directly into Google Sheets. Ideal for marketers, content strategists, and SEO agencies looking for efficiency.

---

🔁 Node-by-Node Flow explanation 1. 🟢 On form submission Triggers the workflow when a user submits a keyword and country via a simple form.

2. 📦 Global Storage Captures and stores the submitted keyword and country for use across the workflow.

3. 🌍 Keyword Insights Request Sends a POST request to the [SEO On-Page API](https://rapidapi.com/PrineshPatel/api/seo-on-page) to fetch keyword suggestions (broad match keywords).

4. 🧾 Re-Format Extracts the relevant broadMatchKeywords array from the keyword API response.

5. 📊 Keyword Insights Appends extracted keyword suggestions into the "Keyword Insights" tab in Google Sheets.