AI Lead Follow-Up Automation: SMS & Google Sheets via Twilio

Transform website leads into engaged prospects with this intelligent AI-powered follow-up automation that combines GPT-4.1 personalization, SMS messaging via Twilio, and smart Google Sheets tracking to ensure no lead falls through the cracks.

What this workflow does

This comprehensive lead nurturing system activates the moment a prospect submits your website contact form. The webhook trigger instantly captures their details (Name, Phone, Email, and Interest) and logs everything to Google Sheets for centralized tracking. GPT-4.1 then analyzes the lead information to craft a personalized SMS message that gets sent immediately via Twilio, creating instant engagement while your lead's interest is at its peak.

The automation includes intelligent follow-up logic: after waiting 2 hours, the system checks your Google Sheets to see if the lead has responded. If they've replied, you receive an instant Gmail notification to take action. If not, GPT-4.1 generates and sends a thoughtful follow-up SMS to re-engage the prospect, maximizing your conversion opportunities.

Use cases

• SaaS companies capturing demo requests and trial signups from landing pages
• Service businesses following up on consultation inquiries and quote requests
• E-commerce stores nurturing high-value product interest forms
• Real estate agents managing property viewing requests and buyer inquiries
• Course creators engaging potential students from enrollment forms

Technical details

Built with essential n8n nodes including webhook triggers, conditional if statements, wait timers, Gmail notifications, and Twilio SMS integration. The workflow requires OpenAI API access for GPT-4.1, Twilio account credentials, Google Sheets OAuth connection, and Gmail OAuth setup. Your Google Sheet needs columns for Name, Phone, Email, Interest, and Replied status. Simply update the "Replied" column to "Yes" when leads respond, and paste the webhook URL into your contact form as the POST endpoint.

Perfect for automation engineers and SaaS operators seeking reliable, AI-enhanced lead management without complex CRM overhead.