Resumen
Automatiza el recopilacion de datos phase of review-driven investigations. Feed un lista of businesses bajo investigation (nursing homes, clinics, contractors), recopilar todos public Google Resenas, extraer sentiment y palabra clave patrones, y produce un structured CSV listo for el reporting team.
Desencadenador
Manual activar con un CSV of business names
Programación
On demand, typically per investigation
Pasos del flujo de trabajo
Ingest objetivo businesses
Subir CSV of business names, addresses, y seguimiento case IDs.
Scavio Google Resenas pull
For cada business, consulta Scavio google-reviews plataforma y paginate todos resenas.
Palabra clave extraccion
Ejecutar palabra clave y named entity extraccion on resena text to surface recurring allegations.
Sentiment scoring
Tag cada resena positive/negative/neutral con confidence puntuacion.
Cross-reference dates
Match negative resena spikes to conocido incident timelines de el case file.
Exportar to Airtable
Dump todos filas en un investigation Airtable base con provenance enlaces.
Implementacion en Python
import os, requests, csv
API_KEY = os.environ["SCAVIO_API_KEY"]
H = {"x-api-key": API_KEY}
def reviews(business):
r = requests.post("https://api.scavio.dev/api/v1/search",
headers=H, json={"platform": "google-reviews", "query": business})
return r.json().get("reviews", [])
with open("out.csv", "w") as f:
w = csv.writer(f)
w.writerow(["business", "date", "rating", "text"])
for row in csv.DictReader(open("targets.csv")):
for rv in reviews(row["name"]):
w.writerow([row["name"], rv.get("date"), rv.get("rating"), rv.get("text")])Implementacion en JavaScript
const API_KEY = process.env.SCAVIO_API_KEY;
const H = { "x-api-key": API_KEY, "content-type": "application/json" };
async function reviews(business) {
const r = await fetch("https://api.scavio.dev/api/v1/search", {
method: "POST", headers: H,
body: JSON.stringify({ platform: "google-reviews", query: business })
});
return (await r.json()).reviews || [];
}
const targets = ["Acme Clinic", "Sunset Care Home"];
for (const t of targets) {
const rs = await reviews(t);
console.log(t, rs.length);
}Plataformas utilizadas
Google Reviews
Extracción de reseñas de negocios con calificaciones y respuestas
Google Maps
Búsqueda de negocios locales con calificaciones e información de contacto