Sheet-Driven Email Outreach Engine by Prateek SahniSheet-Driven Email Outreach Engine by Prateek Sahni

Sheet-Driven Email Outreach Engine

Portfolio project
Prateek Sahni

The Problem

Speaker and sponsor outreach for trade shows meant hundreds of hand-written emails and manual reply checking every day.

What I Built

Node.js and Python automations that run the full outreach cycle from a Google Sheet:
Contact management: Contacts are pulled from Google Sheets with all their personalisation fields.
Multi-step sequences: Each contact receives a personalised email sequence over SMTP/Gmail — initial outreach plus timed follow-ups.
Reply detection: The system polls IMAP for replies and bounces, classifies them, and updates the sheet with the current status.
Scheduling: Sequences run on a schedule, pacing sends to avoid rate limits and landing within business hours.
Status tracking: Every send, open, reply and bounce is written back to the sheet, so the team has a live view of where each contact stands.

The Outcome

Outreach went from a daily manual task to a background job. The team spent its time on conversations instead of admin. Used for speaker and sponsor outreach across multiple trade shows.

0 likes · 3 views · Nov 15, 2026

Automated email outreach system that reads contacts from Google Sheets, sends personalised sequences, detects replies and updates status automatically.

Timeline

Jan 1, 2026 - Ongoing

Tags