What This Workflow Does
This workflow automates the analysis of search intent for keywords by scraping top-ranking pages and using AI to classify their intent. It leverages Google search results, web scraping, and Google Gemini AI to determine whether each page targets informational, commercial, transactional, navigational, or mixed intent. This helps you understand what type of content ranks for your target keywords and informs your SEO strategy accordingly.
How It Works
The workflow follows a systematic process to analyze search intent at scale:
- Start with a manual trigger to begin the workflow execution
- Input keywords and country codes from a Google Sheet containing your keyword list
- Use HTTP requests to scrape the top 10 ranking pages for each keyword from search results
- Split the results into batches for efficient processing
- Extract and classify page titles using text classification
- Send the titles to Google Gemini AI for detailed intent analysis
- Merge the results and store the classified intent data back into Google Sheets
- Review the intent classifications to inform your content strategy
Use Cases
- Competitive content analysis to understand what type of pages rank for your target keywords and adjust your content strategy accordingly
- Content planning and ideation by identifying gaps between your current content and the intent of top-ranking competitors
- SERP intent monitoring to track changes in search intent over time and detect shifts in what Google rewards for specific keywords
- Bulk keyword research analysis to process hundreds of keywords simultaneously and categorize them by intent without manual review
- SEO strategy development by identifying opportunities to create content that better matches user search intent than existing results
Nodes Used
- manualTrigger – Initiates the workflow when you’re ready to analyze keywords
- httpRequest – Performs web scraping to retrieve top search results and page content
- splitOut – Distributes keywords across the workflow for parallel processing
- googleSheets – Reads keywords from your sheet and stores the classified intent results
- splitInBatches – Divides large keyword sets into manageable batches to optimize API usage
- set – Prepares and formats data between workflow steps
- @n8n/textClassifier – Extracts and processes page titles for analysis
- @n8n/lmChatGoogleGemini – Uses Google Gemini AI to classify each page’s search intent
- stickyNote – Provides documentation and workflow guidance within the template
- merge – Combines processed results before storing them back to Google Sheets
Prerequisites
- An n8n account with access to workflow automation tools
- A Google account with Google Sheets API enabled and a spreadsheet containing your keywords and country codes
- Google Gemini API credentials and access to the API
- Web scraping permissions and knowledge of search engine guidelines for your use case
- Basic understanding of how search intent categories work in SEO
Difficulty Level
Intermediate. This workflow combines multiple APIs and requires setup of Google Sheets authentication, web scraping configuration, and Gemini AI integration. While the template handles the complex logic, you’ll need to configure your Google Sheets data source and API credentials before running it.
This workflow template is shared under the n8n fair-code license. Free to use and modify.
Leave a Reply