🤖 Learn how to build a complete automated company research system using n8n, Google Gemini AI, and Trustpilot scraping! In this tutorial, you'll discover how to create a powerful workflow that: ✅ Reads company names from Google Sheets ✅ Scrapes company websites using Jina AI ✅ Extracts structured company data with Google Gemini ✅ Analyzes Trustpilot reviews for sentiment and insights ✅ Updates your spreadsheet with comprehensive research results 🔧 TOOLS USED: - n8n (workflow automation platform) - Google Sheets API - Jina AI for web scraping - Google Gemini 2.5 Flash for AI analysis - Firecrawl for Trustpilot data extraction - JavaScript for data processing 📊 WHAT YOU'LL BUILD: A complete business intelligence tool that automatically researches companies and provides: - Company industry and description - Key services and target markets - Trustpilot sentiment analysis (1-5 scale) - Main customer complaints and positive highlights - Trust scores and review summaries 🔗 RESOURCES: - n8n documentation - Jina AI API documentation - Google Gemini API setup guide - Firecrawl integration examples 💡 Perfect for entrepreneurs, business analysts, sales teams, and anyone looking to automate competitive research and customer sentiment analysis.

What: Scrapes all member profiles from Skool.com community and saves them to Google Sheets How: 1. Click button → Generate 88 page URLs → Scrape each page → Extract names/usernames → Create profile links → Save to spreadsheet → Wait 7 seconds → Repeat Result: Complete Google Sheet with all community members' names, usernames, and profile URLs Why: Build a database of community members without manually visiting 88 pages

What: Finds popular tweets about "voiceAi" and saves them to Google Sheets How: 1. Click button → Search Twitter → Get viral tweets → Save to spreadsheet Result: Auto-updated spreadsheet of trending "voiceAi" tweets, sorted by popularity Why: Track viral content without manual searching