Lifecycle

Lead Nurture & Reactivation

Workflow & AI Automation Specialist

Business outcome

Dormant leads come back without anyone touching a list. Every cold lead gets a personalized re-engagement message — written by AI from that lead's own history.

Cold leads identified and re-engaged automatically on schedule
Each message personalized per lead — not the same blast to everyone
Replies flagged for human follow-up immediately

What I built

Built a nurture and reactivation engine on a Google Sheets lead database. An n8n loop runs through the lead list on schedule, identifies leads that have gone quiet past a configured threshold, and routes each one to the Gemini API with that lead's history — source, last contact, previous interest. Gemini drafts a personalized re-engagement message per lead, and Gmail sends it. Status and send date write back to the sheet so no lead is contacted twice in the same window. Replies flag the lead for human follow-up.

Automation pattern

Scheduled trigger → n8n loops through Google Sheets lead database → filter: leads inactive past threshold → each lead's history routed to Gemini API → personalized message drafted per lead → sent via Gmail → sheet updated with status + send date → reply detection flags lead for human follow-up → suppression rule prevents repeat contact within the window.

Tech stack

Google Sheets (Lead DB) n8n (Loop) Gemini API Gmail