๐ค 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.