Conversational lead capture with Gemini 2.0 Flash AI and Google Sheets

AI Lead Capture System - Complete Setup Guide Prerequisites

n8n instance (cloud or self-hosted) Google AI Studio account (free tier available) Google account for Sheets integration Website with chat widget capability

Phase 1: Core Infrastructure Setup Step 1: Set Up Google AI Studio

Go to Google AI Studio Create account or sign in with Google Navigate to "Get API Key" Create new API key for your project Copy and securely store the API key Free tier limits: 15 requests/minute, 1 million tokens/month

Step 2: Configure Google Sheets

Create new Google Sheet for lead storage Add column headers (exact names):

Full Name Company Name Email Address Phone Number Project Intent/Needs Project Timeline Budget Range Preferred Communication Channel How they heard about DAEX AI

Copy the Google Sheet ID from URL (between /d/ and /edit) Ensure sheet is accessible to your Google account