Click to zoomOverview
An n8n workflow that pulls leads from Google Sheets, uses OpenAI to infer their time zone, checks local business hours before sending, and generates fully personalized emails using GPT-4. Sends a maximum of 5 emails per run to protect deliverability.
Stack
What needed solving
Cold outreach sent at the wrong time gets ignored or flagged as spam. Generic bulk emails have low reply rates. Sales teams waste time manually writing and scheduling emails for different time zones.
How I approached it
An automated outreach workflow that infers each lead's time zone using AI, checks whether it is currently business hours in their location, and only sends if the timing is right. GPT-4 writes a fully personalized email for each lead based on their industry, pain point, and location.
Step by step
- 01
Leads are pulled from Google Sheets and filtered by status
- 02
OpenAI infers the lead's time zone based on their location data
- 03
A Check Hour node verifies whether it is currently business hours for that lead
- 04
If outside business hours the workflow waits and retries
- 05
GPT-4 generates a personalized email using lead industry, pain point, and location
- 06
Email is sent via Gmail with a maximum of 5 per run to protect deliverability
- 07
Lead status is updated in Google Sheets and a notification is sent
Outcomes
- ✓
Higher open rates from time-aware delivery
- ✓
Fully personalized emails generated at scale with no manual writing
- ✓
Lead records automatically updated after each send
- ✓
Deliverability protected by controlled sending limits
Key features
AI-powered time zone inference with no manual configuration per lead
Business hours check runs before every send -- no emails land at 3am
GPT-4 writes unique emails per lead based on industry and pain point
Loop with wait logic controls send rate and protects sender reputation