Anir Agram
Workflows by Anir Agram
Automated cold email campaigns with random templates & Google Sheets tracking
# 📊 Google Sheets Leads → 🎲 Random Templates → ✉️ Personalized Emails → 📝 Status Tracking ## What this workflow does - 📊 Reads leads list from Google Sheets (Name, Email, Send Status) - 🔍 Filters out already-contacted leads (skips "SENT" status) - 🎲 Randomly selects email template from template library - ✏️ Personalizes subject and body with lead's name - 📧 Sends emails one-by-one with delays between sends - ✅ Updates Google Sheet with send status and timestamp - 🔁 Loops through all unsent leads automatically ## Why it's useful - ⚡ Automate cold outreach without manual copy-paste - 🎯 Avoid duplicate sends—tracks who's been contacted - 📝 Rotate email templates for A/B testing and variety - 👤 Personalization makes emails feel human, not spammy - ⏱️ Built-in delays prevent spam flags and rate limits - 📊 Full audit trail of who received what and when ## How it works - 📊 Google Sheets (Leads) → reads Name, Email, Send Status - 🚦 IF Node → filters leads where Send Status ≠ "SENT" - 🔄 Loop Over Items → processes leads one-by-one - 📧 Google Sheets (Templates) → fetches Subject + Body templates - 🎲 Code Node → picks random template - 🔀 Merge → combines lead data with template - ✏️ Edit Fields → replaces [Name] with actual lead name - 📨 Send Email → delivers personalized message - ⏳ Wait → adds delay between sends (avoids spam flags) - ✅ Google Sheets (Update) → marks as "SENT" with timestamp ## What you'll need - 📊 Google Sheet #1: Leads (columns: Name, Email, Send Status, Time) - 📧 Google Sheet #2: Templates (columns: Subject, Body) - 📬 SMTP credentials (SendGrid, Mailgun, etc.) - 🔐 Google Sheets OAuth ## Setup steps - 📊 Create "Leads" sheet with columns: Name | Email | Send Status | Time - 📧 Create "Templates" sheet with columns: Subject | Body (use [Name] placeholder) - 🔗 Connect Google Sheets OAuth credentials - 📬 Add SMTP email credentials - 🧭 Update both Google Sheets node IDs to point to your sheets - ⚙️ Set "From Email" in Send Email node - 🧪 Test with 2-3 test leads first ## Customization ideas - ⏱️ Adjust Wait time (30s-5min) to control send rate - 📊 Add click tracking with UTM parameters - 🔔 Send Slack/Telegram notification when campaign completes - 🎯 Add lead scoring—prioritize high-value leads first - 📈 Log opens/replies to separate tracking sheet ## Who it's for - 🧑💻 Freelancers doing cold outreach to agencies - 📈 Sales teams running lead generation campaigns - 🚀 Startups reaching out to potential customers - 🎯 Marketers testing email copy variations - 💼 Business developers nurturing prospect lists ## Quick Setup Guide - Before You Start - What You Need: 📊 Google account for Sheets access - 📧 SMTP email account (Gmail, custom domain, or email service) - 📝 List of leads (names + emails) - ✉️ Email templates ready (with [Name] placeholders) ## Want help customizing? 📧 [email protected] 🔗 LinkedIn
Snap & track nutrition: Telegram food photos → Gemini Vision AI → Google Sheets
# 📸🍽️ Telegram Food Photo → 🤖 Gemini Vision AI → 📊 Nutrition Data → 📄 Google Sheets + 🗂️ Drive ## What this workflow does - 📸 Snap and send a photo of your meal via Telegram - 🧠 Gemini Vision AI analyzes the image and estimates calories, protein, carbs, and fats - 🤖 AI Agent structures the data with meal name, description, and timestamp - 📄 Auto-logs nutrition data to Google Sheets for tracking - 🗂️ Saves original meal photos to Google Drive with timestamped filenames - 💬 Sends instant Telegram reply with full nutrition breakdown ## Why it's useful - ⚡ Track nutrition in seconds—no manual entry or food databases - 📊 Build a complete meal history with photos and macros in one place - 🎯 AI estimates portion sizes and hidden ingredients (oils, sauces) - 🏋️ Perfect for fitness tracking, meal prep, or health monitoring - 📱 Works entirely through Telegram—no extra apps needed ## How it works - 📲 Telegram Trigger → receives meal photo - 🗂️ Google Drive → saves image with timestamp - 🔎 Gemini Vision → analyzes food, estimates portions and macros - 🤖 AI Agent → structures output (meal name, calories, protein, carbs, fats) - 📄 Google Sheets → appends row with all nutrition data - 💬 Telegram Reply → confirms with full breakdown ## What you'll need - 🤖 Telegram Bot token - 🧠 Google Gemini API key (includes Vision capabilities) - 🔐 Google OAuth for Sheets + Drive - 📊 Google Sheet with columns: Meal_Name, Date, Meal_description, Calories, Proteins, Carbs, Fats ## Setup steps - 🔗 Connect credentials: Telegram, Google Gemini, Google Sheets, Google Drive - 📄 Create Google Sheet with nutrition columns (see format above) - 🗂️ Create Google Drive folder for meal photos - 🧭 Update sheet ID and Drive folder ID in workflow - 🧪 Test: send a meal photo via Telegram and check Sheet + Drive ## Customization ideas - 📈 Daily summary: add scheduled workflow to calculate daily totals - 🎯 Goal tracking: set IF conditions to alert when over/under calorie targets - 📊 Charts: connect to Data Studio/Looker for visual progress tracking - 🏃 Fitness integration: sync with MyFitnessPal or fitness apps ## Who it's for - 🏋️ Fitness enthusiasts tracking macros without manual logging - 🥗 Meal preppers analyzing portion sizes and nutrition - 💪 Athletes monitoring calorie and protein intake - 🩺 Health-conscious individuals building meal history - 👨🍳 Nutritionists collecting client food data ## Quick Setup Guide - Before You Start - What You Need: - 🔗 Telegram Bot (create via @BotFather) - 🧠 Google Gemini API key with Vision enabled (get it here) - 🔐 Google account for Sheets and Drive access - 📊 Basic spreadsheet to track your meals ## Want help customizing? 📧 [email protected] 🔗 LinkedIn