AI assistant for B2B leads in HoReCa: data from Google

This automation helps B2B service providers identify, evaluate, and engage with potential clients in the HoReCa sector. It scrapes restaurant data from Google Maps via Apify, structures and enriches leads with quality scores, stores them in Google Sheets and Supabase vector database, and enables contextual AI-powered responses through a chat interface. Ideal for teams using WhatsApp or Telegram as primary communication channels.

## Who it´s for
- B2B service companies seeking lead generation automation in HoReCa
- Marketers who need to collect and analyze competitor and client data
- Sales managers wanting personalized insights on prospects
- Business owners using WhatsApp for communication and needing an AI assistant
- Analysts working with geospatial data and market opportunity assessment

## What the automation does
- Scrapes restaurant data from Google Maps using Apify
- Cleans, structures, and applies lead scoring logic
- Stores enriched data in Google Sheets and indexes it into Supabase vector store
- Powers an AI agent (LangChain-based) with RAG and Cohere reranking for accurate responses
- Maintains conversation context via PostgreSQL
- Answers user queries through a chat (e.g., Telegram)

## What´s included
- Ready-to-use n8n workflow
- Trigger logic: new rows in Google Sheets, files in Google Drive, HTTP webhooks
- Integrations with Google Sheets, Google Drive, Supabase, PostgreSQL, OpenAI, Cohere, Apify, WAHA (Telegram)
- Basic text instructions for setup and adaptation

## Requirements for setup
- Google Workspace accounts (Drive, Sheets)
- Apify account with API key
- Supabase project with vector database enabled
- PostgreSQL database for chat memory
- OpenAI API key
- Cohere API key
- Configured WAHA server for Telegram integration
- Basic understanding of n8n and API usage

## Benefits and outcomes
- Faster identification of high-potential HoReCa clients
- Automated lead enrichment and quality classification
- Quick access to real-time company and prospect data
- Reduced manual effort in collecting and analyzing geodata
- Context-aware chat responses powered by up-to-date knowledge
- Scalable solution for sales and analytics teams

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.