Anir Agram
Automation freelancer solving business challenges with n8n. From email sequences to API integrations and workflow optimization. I build solutions that save time and boost productivity. Let's connect. 🔧
Templates 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? 📧 anirpoke@gmail.com 🔗 LinkedIn
By Anir AgramSnap & 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: MealName, Date, Mealdescription, 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? 📧 anirpoke@gmail.com 🔗 LinkedIn
By Anir Agram