Fetch keyword from Google Sheet and classify them using AI
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 ref...
🔌 Nodes & Integrations Used (4)
📖 Implementation & Setup Guide
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?"
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." ```
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Fetch keyword from Google Sheet and classify them using AI.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related AI Agents Workflows
View All in AI Agents →5 ways to process images PDFs with Gemini AI in n8n
How it works Many users have asked in the support forum about different methods to analyze images and PDF documents with Google Gemini AI in n8n. This workfl...
7 AI Sales Assistant
Production-ready n8n automation template for 7 AI Sales Assistant built by AhiXLight. Seamlessly connects Airtop Tool, Slack, Airtop with 24 configured nodes.
AAVE portfolio professional AI agent Telegram Email GPT 4o
A next-generation AI-powered DeFi health monitor that tracks wallet positions across Aave V3 using GPT-4o and LangChain. It delivers human-readable reports v...
Access control for AI agents RBAC using Airtable and Telegram
Purpose This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control....