This workflow automates company research by combining AI with web search and website scraping. Starting from a simple input (like a company name or domain), it enriches company data with valuable details such as domain, LinkedIn URL, pricing information, free trial availability, and more. The results are automatically stored and updated in Google Sheets, making it a powerful tool for sales, marketing, and research teams.
Features
- 🔍 Automated Web Research – Uses OpenAI with SerpAPI (or ScrapingBee) to search Google and extract company details.
- 🌐 Website Content Extraction – Visits company websites to analyze homepage and pricing details.
- 🧠 AI-Powered Company Researcher – Gathers structured insights including :
- Company domain & LinkedIn URL
- Market type (B2B or B2C)
- Cheapest plan available
- Free trial availability
- Enterprise plan offering
- API availability
- Latest case study link
- Up to 5 tool integrations
- 📑 Structured Output Parser – Ensures results are returned in a clean, structured format.
- 📊 Google Sheets Integration – Reads pending rows and automatically enriches them with researched data.
- ⏱ Flexible Scheduling – Can run manually or on an automated schedule (e.g., every 2 hours).
- 🛠 Customizable – Easily adapt prompts and output schema to extract additional information.