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.
On Form Submission
Triggers the workflow when a user submits a website domain.
Global Storage
Stores the submitted website domain for use in subsequent nodes.
Competitor Analysis Request
Sends a POST request to the Competitor Analysis API to fetch organic competitors, pages, and keyword data.
If (Condition Check)
Verifies that the API response contains valid, non-empty data.
Google Sheets (Insert Success Data)
Appends the fetched competitor data to a specified Google Sheet.
Wait Node
Adds a 5-second delay to avoid exceeding API rate limits.
Google Sheets (Insert 'Not Found' Record)
Logs a “Not data found.” entry into Google Sheets if the API response lacks relevant data.
🔑 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: