📊 Fetch keyword from Google Sheet and classify them using AI
⚡ 3,288 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
Who is this template for
This template is for marketers, SEO specialists, or content managers who need to analyze keywords to identify which ones contain references to a specific area or topic, in this case – IT software, services, tools, or apps.
Use case
Automating the process of scanning a large list of keywords to determine if they reference known IT products or services (like ServiceNow, Salesforce, etc.), and updating a Google Sheet with this classification. This helps in categorizing keywords for targeted SEO campaigns, content creation, or market analysis.
How this workflow works
- Fetches keyword data from a Google Sheet
- Processes keywords in batches to prevent rate limiting
- Uses an AI agent (OpenAI) to analyze each keyword and determine if it contains a reference to an IT service/software
- Updates the original Google Sheet with the results in a “Service?” column
- Continues processing until all keywords are analyzed
Set up steps
- Connect your Google Sheets account credentials
- Set the Google Sheet document ID (currently using “Copy of Sheet1 1”)
- Configure the OpenAI API credentials for the AI agent
- Adjust the batch size (currently 6) if needed based on your API rate limits
- Ensure the Google Sheet has the required columns: “Number”, “Keyword”, and “Service?”
Screenshot 20250219 at 13.07.11.png
The AI agent’s prompt is highly customizable to match different identification needs. For example, instead of looking for IT software/services, you could modify the prompt to identify:
- Industry-specific terms (healthcare, finance, education)
- Geographic references (cities, countries, regions)
- Product categories (electronics, clothing, food)
- Competitor brand mentions
Here’s how you could modify the prompt for different use cases:
Copy
// For identifying educational content keywords
"Check the keyword I provided and define if this keyword relates to educational content, courses, or learning materials and return yes or no."
// For identifying local service keywords
"Check the keyword I provided and determine if it contains location-specific terms (city names, neighborhoods, regions) that suggest local service intent and return yes or no."
// For identifying competitor mentions
"Check the keyword I provided and determine if it mentions any of our competitors (CompetitorA, CompetitorB, CompetitorC) and return yes or no."🔗 Nodes Used
Google Sheets, AI Agent, OpenAI Chat Model, Structured Output Parser
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File