Website Data Enrichment (Unverified)

Name: Website Data Enrichment (Unverified)
Rating: 3.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

10 views

0 downloads

Community Contributed (Unverified)aiautomationdata-processinggoogle-sheetsopenaiwebsite-enrichment

Enriches website data with AI-generated insights from Google Sheets.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow reads website domains from a Google Sheet, fetches their content, uses OpenAI to extract key information like value proposition, industry, target audience, and market type (B2B/B2C), and then updates the Google Sheet with these enriched details. It's designed for unverified community contributions, meaning the output may require review.

Key Features

Reads website domains from Google Sheets.
Fetches website content via HTTP requests.
Cleans and shortens website content for AI processing.
Utilizes OpenAI to extract structured data (value proposition, industry, target audience, market).
Parses the AI response into usable fields.
Updates the original Google Sheet with the enriched data.
Includes a Wait node for potential rate limiting or pauses.

How To Use

Import the workflow: Add this JSON to your n8n instance.
Configure Credentials: Set up Google Sheets account lucas for Google Sheets access and Lucas Open AI for OpenAI API access.
Set Environment Variables: Ensure $env.BASE_URL is configured for the HTTP Request node and $env.WEBHOOK_URL points to your Google Sheet document URL.
Map Google Sheet Columns: In the Read Google Sheets and Update Google Sheets nodes, ensure the sheetName and documentId are correctly set to your target Google Sheet.
Define Google Sheet Columns: In the Update Google Sheets node, map the output fields (market, industry, value_proposition, target_audience) to your desired Google Sheet columns. The columnToMatchOn should be set to 'Domain' to update the correct row.
Adjust OpenAI Prompt: Modify the OpenAI node's prompt to refine the data extraction criteria or adjust output formats as needed.
Execute: Trigger the workflow manually or via an external event.

Apps Used

automation

data-processing

google-sheets

openai

website-enrichment

Workflow JSON

{
  "id": "bc2d63d0-d148-4692-b8ee-50b4665f081f",
  "name": "Website Data Enrichment (Unverified)",
  "nodes": 0,
  "category": "Community Contributed (Unverified)",
  "status": "active",
  "version": "1.0.0"
}

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