Resumen
Enriquecer company registros in n8n by busqueda Google for canonical company datos (Knowledge Graph, sitio web, descripcion) y Reddit for community sentiment. Salida enriquecido registros to your CRM o base de datos.
Desencadenador
Nuevo fila in Google Sheet o CRM webhook
Programación
On nuevo CRM registro (event-driven)
Pasos del flujo de trabajo
Recibir company nombre
Activar on nuevo fila in Google Sheets, HubSpot webhook, o manual CSV subir. Extraer company nombre y optional dominio.
Google Knowledge Graph lookup
Search Google for el company nombre via Scavio. Extraer canonical nombre, sitio web, descripcion, y tipo de Knowledge Graph datos.
Reddit community search
Search Reddit for el company nombre to encontrar community discussions, puntos de dolor, y sentiment senales.
Fusionar y puntuacion
Combine Google y Reddit senales en un single enriquecimiento registro. Puntuacion basado on datos completeness: Knowledge Graph encontrado, sitio web confirmed, Reddit presence.
Escribir to destino
Push enriquecido registro to CRM, base de datos, o Google Sheet con canonical nombre, sitio web, descripcion, y community senal campos.
Implementacion en Python
import requests, os, json
H = {'x-api-key': os.environ['SCAVIO_API_KEY']}
def enrich_company(name):
# Google for canonical data
g = requests.post('https://api.scavio.dev/api/v1/search', headers=H,
json={'platform': 'google', 'query': name}, timeout=10).json()
# Reddit for community signals
r = requests.post('https://api.scavio.dev/api/v1/search', headers=H,
json={'platform': 'reddit', 'query': name}, timeout=10).json()
kg = g.get('knowledge_graph', {})
reddit_posts = r.get('organic', [])[:3]
return {
'input_name': name,
'canonical_name': kg.get('title', ''),
'website': kg.get('website', ''),
'description': kg.get('description', ''),
'type': kg.get('type', ''),
'reddit_mentions': len(r.get('organic', [])),
'reddit_topics': [p.get('title', '')[:80] for p in reddit_posts],
'enrichment_score': sum([
bool(kg.get('title')),
bool(kg.get('website')),
bool(kg.get('description')),
len(r.get('organic', [])) > 0,
]),
}
companies = ['Vercel', 'Supabase', 'PlanetScale']
for name in companies:
data = enrich_company(name)
print(f"{name} -> {data['canonical_name']} | {data['website']} | Score: {data['enrichment_score']}/4")
if data['reddit_topics']:
print(f" Reddit: {data['reddit_topics'][0]}")Implementacion en JavaScript
const H = {"x-api-key": process.env.SCAVIO_API_KEY, "Content-Type": "application/json"};
async function enrichCompany(name) {
const [g, r] = await Promise.all([
fetch("https://api.scavio.dev/api/v1/search", {
method: "POST", headers: H,
body: JSON.stringify({platform: "google", query: name})
}).then(r => r.json()),
fetch("https://api.scavio.dev/api/v1/search", {
method: "POST", headers: H,
body: JSON.stringify({platform: "reddit", query: name})
}).then(r => r.json()),
]);
const kg = g.knowledge_graph || {};
const redditPosts = (r.organic || []).slice(0, 3);
return {
inputName: name,
canonicalName: kg.title || "",
website: kg.website || "",
description: kg.description || "",
type: kg.type || "",
redditMentions: (r.organic || []).length,
redditTopics: redditPosts.map(p => (p.title || "").slice(0, 80)),
enrichmentScore: [kg.title, kg.website, kg.description, (r.organic || []).length > 0]
.filter(Boolean).length,
};
}
(async () => {
const companies = ["Vercel", "Supabase", "PlanetScale"];
for (const name of companies) {
const data = await enrichCompany(name);
console.log(`${name} -> ${data.canonicalName} | ${data.website} | Score: ${data.enrichmentScore}/4`);
if (data.redditTopics.length) console.log(` Reddit: ${data.redditTopics[0]}`);
}
})();Plataformas utilizadas
Búsqueda web con grafo de conocimiento, PAA y resúmenes de IA
Comunidad, publicaciones y comentarios en hilos de cualquier subreddit