This n8n workflow automates competitor research by fetching search engine results pages (SERPs) for a list of keywords from a Google Sheet and extracting competitor data for analysis. The process is triggered manually and involves several key steps:
1. **Manual Trigger:** The workflow starts when a user clicks ‘Execute workflow’, initiating the process.
2. **Retrieve Keywords:** It reads keywords and target countries from a specified Google Sheet. Users should replace placeholders with their actual Google Sheet ID and API credentials.
3. **Keyword Encoding:** Each keyword is URL-encoded to handle special characters, ensuring proper search URL formation.
4. **Batch Processing:** The list of keywords is split into manageable batches to optimize API requests and avoid rate limits.
5. **Fetch SERP Data:** For each batch, the workflow calls the BrightData SERP API to retrieve raw HTML search results for each keyword and country, constructing Google search URLs dynamically.
6. **Extract Competitor Details:** A placeholder node is included where HTML content should be parsed to extract competitor website names, URLs, titles, and descriptions.
This automation is practical for SEO analysts, digital marketers, and competition researchers who want to streamline their SERP analysis process, gather competitor insights, and update their databases automatically.
Reviews
There are no reviews yet.