Monitors your Google Sheet for lead status changes to send booking or proposal emails, append new clients, and calculate delivery duration.
Verified 2026-07-07
Founder-ExecFreelancer-Consultant
What it does
You get automatic booking or proposal emails sent via Gmail the moment your Google Sheet shows a lead is qualified or awaiting a proposal. New clients are instantly added to your tracking sheet when deals close, and delivery duration metrics update automatically once projects are marked as delivered.
How it works
When it runs
Triggered by an event · Event · on Google Sheets edit
How hands-off
Assists you, you do the final step
Setup
An afternoon · about an afternoon
Works with
Google Sheets, n8n, Gmail, Code
Tools that fit
Services
Google Sheets : CRM data storage and trigger source
Code : Processing timestamps and calculating delivery duration
Watch out for
⚠ Gmail API rate limits can block bulk sends, so implement a delay node between emails or use batch sending capabilities.
⚠ Timestamp format mismatches often break calculations, so ensure all date strings are parsed using a consistent library like dayjs before computing differences.
⚠ Duplicate entries may clutter the tracking sheet if triggers fire multiple times for single edits, so add a check to verify if the row was already processed in this session.
⚠ Webhook security is critical for n8n endpoints, so enforce authentication headers or IP whitelisting to prevent unauthorized trigger requests.
This is what I do. I design and build AI agents like this one, and keep them running. If you want it set up for your team instead of doing it yourself, get in touch.