The Problem
A newsletter operator was sending the same email to every subscriber regardless of their interests. New subscribers received no onboarding sequence. Duplicate subscribers were receiving emails multiple times and there was no system to manage it.
The Solution
I built an n8n workflow triggered by Tally form submissions. Gemini AI reads the subscriber's stated interests and segments them into one of four categories. A deduplication check against Google Sheets prevents duplicate records. A 7-day drip sequence then delivers personalised emails based on segment — all without manual intervention.
Screenshots
n8n workflow showing Gemini segmentation and drip sequence logic
Google Sheets subscriber database with segment tags