AI-Powered Company Research and Enrichment for Google Sheets

Name: AI-Powered Company Research and Enrichment for Google Sheets
Rating: 5 (10 reviews)
Author: Free N8N

Community Verified

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

112 views

0 downloads

AI & Machine Learningaiautomationdata enrichmentgoogle sheetslangchainopenaiweb scraping

Leverage AI with OpenAI and LangChain to automatically research companies, extract key data like domain, market, and pricing, and update Google Sheets. This workflow uses the 'OpenAI Chat Model', 'get_website_content' tool, and 'SerpAPI - Search Google' to enrich your data.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This n8n workflow automates the process of researching companies using AI. It's designed to take company names as input, find relevant information across the web, and structure this data for easy use, such as updating a Google Sheet. The workflow begins with a manual trigger and uses the 'Set' node to prepare the input data. It then leverages the power of LangChain tools, including an 'OpenAI Chat Model' for intelligent processing, a custom 'get_website_content' tool to scrape website text, and 'SerpAPI - Search Google' to find publicly available information. Finally, a 'Structured Output Parser' organizes the AI's findings into a predefined schema, which are then mapped to specific fields in a 'Google Sheets - Update Row' node.

Key Features

Automates company data enrichment using AI.
Integrates with OpenAI for advanced language processing.
Utilizes LangChain tools for web scraping and search.
Parses AI output into a structured format.
Updates Google Sheets with researched data.

How To Use

Trigger the workflow manually or via another trigger.
Provide the company name and row number as input.
The workflow will then use OpenAI and LangChain tools to research the company.
The extracted data will be automatically updated into the specified row in your Google Sheet.

Apps Used

automation

data enrichment

google sheets

langchain

openai

web scraping

Workflow JSON

{
  "id": "b472c041-5dde-49c8-a577-fc974da80e1d",
  "name": "AI-Powered Company Research and Enrichment for Google Sheets",
  "nodes": 0,
  "category": "AI & Machine Learning",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.