📊 SEO competitor analysis with RapidAPI and Google Sheets logging

⚡ 416 views · 📊 Market Research & Insights

💡 Pro Tip — For competitive intelligence, ScraperNode can automate the data collection — Yelp reviews, Glassdoor company data, and Crunchbase profiles all return structured JSON you can feed straight into this workflow.

Description

Automated SEO Competitor Analysis with Google Sheets Logging

Description:
This n8n workflow automates SEO competitor analysis by integrating the Competitor Analysis API. It captures website domains via a simple user form, sends them to the API to retrieve competitor data, and logs the results directly into Google Sheets. The workflow intelligently handles empty or missing data and incorporates a wait node to respect API rate limits, making your competitor tracking seamless and reliable.

Node-by-Node Explanation

1. On Form Submission
   Triggers the workflow when a user submits a website domain.

2. Global Storage
   Stores the submitted website domain for use in subsequent nodes.

3. Competitor Analysis Request
   Sends a POST request to the Competitor Analysis API to fetch organic competitors, pages, and keyword data.

4. If (Condition Check)
   Verifies that the API response contains valid, non-empty data.

5. Google Sheets (Insert Success Data)
   Appends the fetched competitor data to a specified Google Sheet.

6. Wait Node
   Adds a 5-second delay to avoid exceeding API rate limits.

7. Google Sheets (Insert ‘Not Found’ Record)
   Logs a “Not data found.” entry into Google Sheets if the API response lacks relevant data.

Use Cases & Benefits

• SEO Professionals: Automate competitor insights collection for efficient SEO research.
• Marketing Teams: Maintain consistent, automated logs of competitor data across multiple websites.
• Agencies: Manage organic search competitor tracking for many clients effortlessly.
• Reliability: Conditional checks and wait nodes ensure smooth API interaction and data integrity.
• Scalable & User-Friendly: Simple form input and Google Sheets integration enable easy adoption and scalability.

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

1. Go to 👉 Competitor Keyword Analysis API
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.

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

👉 Start Automating with n8n

🔗 Nodes Used

Google Sheets, HTTP Request, n8n Form Trigger

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup