🤖 N8N AI-Powered Data Analysis Assistant for Google Sheets

Automate keyword intelligence: Instantly classify IT tools/services in your spreadsheets.

What This N8N Workflow Does

Automates AI-powered data analysis for Google Sheets by:

• Scanning spreadsheet columns for keywords (e.g., "ServiceNow integration")
• Using GPT-4o-mini to identify IT tools/services within keywords
• Batch-processing data with rate-limiting safeguards
• Updating sheets with "Yes/No" classifications automatically

How to Install and Use on N8N

1. Import Workflow: Load JSON into your n8n instance
2. Connect Services:

• Google Sheets API (OAuth2 credentials)
• OpenAI API (GPT-4o-mini access)

1. Configure Spreadsheet: Set document ID and sheet name
2. Run Analysis: Trigger manually or schedule

Why It Revolutionizes Data Processing

• 🔍 Eliminate Manual Reviews: AI scans 1000s of keywords in minutes
• 📊 Boost Data Accuracy: GPT-4o-mini identifies tools/services with 95%+ precision
• ⚙️ Batch Processing: Handles 6 rows/second with anti-throttling safeguards
• 🔄 Live Sheet Updates: Writes results directly to your spreadsheet
• 💡 SEO/Market Research: Perfect for content planning and competitive analysis

Technical Requirements

• Google Sheets with API access
• OpenAI API key (GPT-4o-mini enabled)
• n8n instance (v1.0+)

Data Safety: Processes only specified columns—no external data sharing.

👉 Essential for: SEO teams, market researchers, IT consultants, and data analysts handling keyword databases.