Personalized cold email system with Google Gemini, Telegram approval & Google Sheets

Personalized Cold Email System with Google Gemini AI and Telegram Approval

An AI-powered cold email automation that uses Google Gemini to generate personalized outreach and a Telegram workflow for manual approval, ensuring high-quality, human-in-the-loop campaigns.

Features

- Smart Lead Selection: Fetches leads with an "Available" status from a designated Google Sheet. - AI Email Generation: Google Gemini creates a personalized subject line and email body based on lead data. - Telegram Approval: Sends each generated email to a Telegram chat for a one-click "Approve" or "Reject" decision. - Edit & Regenerate: Allows users to provide feedback on rejected emails, which the AI uses to regenerate a new version for re-approval. - Auto-Send: Approved emails are automatically dispatched via a configured SMTP server, including a professional signature. - Complete Tracking: Updates three separate Google Sheets (Filtered Leads, Sent Leads, Emails Sent) to maintain a clear audit trail. - Rate Limiting: A one-second delay between email sends helps avoid spam filters and protects sender reputation. - Batch Processing: Handles three leads per execution by default, which is configurable to scale up or down.

How It Works

1. A manual trigger initiates the workflow and captures the current date and time for logging. 2. The system fetches a set number of leads (default is three) from the Filtered Leads sheet where the status is "Available". 3. It loops through each lead individually to generate and send a unique email. 4. The AI generates a personalized email (Subject + Body) using the lead's data. 5. A preview of the email is sent to a specified Telegram chat with "Approve" and "Reject" buttons. 6. If approved: The email is sent via SMTP. The lead's status is updated, and logs are written to the Sent Leads and Emails Sent sheets. The system waits one second before processing the next lead. 7. If rejected: The system prompts the user for feedback in Telegram. The feedback is combined with the original prompt to generate a new email draft, which is sent for re-approval. 8. A final notification is sent to Telegram when the batch is complete.

Requirements

- Google Sheets with three tabs (see structure below). - Telegram Bot Token and user/group Chat ID. - Google Gemini API Key. - SMTP Email Account credentials (server, port, username, password).