Automated Data Collection, Processing, and Lead Management Workflow

This comprehensive n8n workflow automates the process of collecting, cleaning, analyzing, and managing restaurant data and leads. Designed for business intelligence and lead generation, it integrates Google Drive, Google Sheets, Supabase, OpenAI, and LangChain nodes to streamline data workflows from file monitoring to updating CRM or databases.

The process begins with a Google Drive trigger that detects updates in specific folders. It then downloads updated files, scrapes maps or reviews via HTTP requests, and cleans the raw data through custom JavaScript code to format and extract relevant information like ratings, reviews, and operational hours.

The cleaned data is used to generate structured summaries for AI analysis—assessing lead quality based on criteria like ratings and reviews—and then saved into Google Sheets or a vector database for quick retrieval and further analysis. The workflow also includes steps for inserting and updating restaurant leads and product data in Google Sheets, with data validation and duplication checks.

Additionally, the system employs AI agents for business intelligence, answering queries based on company documents and potential client data. It uses embeddings for semantic search, reranking for relevance, and chat models for conversational responses—useful for market insights, lead prioritization, and customer interactions.

This automation caters to restaurant businesses seeking efficient data handling, lead scoring, and intelligent insights, ultimately enhancing decision-making, outreach, and market analysis.