Automated Lead-to-Client Pipeline: Google Sheets CRM with Emails & Time Tracking

This n8n workflow turns a simple Google Sheets into a powerful lightweight CRM for managing leads through to clients. It uses Google Apps Script triggers to send webhooks to n8n on sheet edits in 'Leads' and 'Clients' tabs. Key automations include: sending a Cal.com booking email when a lead is marked 'Qualified?', a 'proposal coming soon' email when stage changes to 'Awaiting Proposal', appending won leads to the 'Clients' tab with a start date/time timestamp, and on 'Delivered' status, updating the client row with end date/time and calculating total delivery duration (e.g., '2d 5h 30m').

Benefits include hands-free lead nurturing, reduced manual data entry, precise sales pipeline tracking, and performance metrics like time-to-delivery without complex tools. It's ideal for solopreneurs, small sales teams, or agencies handling freelance projects, saving hours weekly on admin tasks.

Use cases: Freelance consultants tracking client projects, sales reps nurturing leads via email sequences, or marketing teams monitoring conversion funnels. Setup requires pasting the provided Apps Script into your sheet and configuring n8n credentials for email/Cal.com.