Roshan Ramani
I love building smart n8n automations that actually work reliably. My focus is on making everyday tasks like email, social media, and CRM workflows simpler using AI. I've shared templates in the n8n community, including a WhatsApp Expense Tracker that people really enjoy. What keeps me excited is constantly trying new things - testing fresh nodes, playing with AI tools like LangChain, and discovering creative ways to connect systems!
Categories
Templates by Roshan Ramani
Product video creator with Nano Banana & Veo 3.1 via Telegram
Product Video Creator with Nano Banana & Veo 3.1 via Telegram Who's it for This workflow is perfect for: E-commerce sellers needing quick product videos Social media marketers creating content at scale Small business owners without video editing skills Product photographers enhancing their offerings Anyone selling on Instagram, TikTok, or mobile-first platforms What it does Transform basic product photos into professional marketing videos in under 2 minutes: Send a product photo to your Telegram bot Nano Banana analyzes and enhances your image with studio-quality lighting Veo 3.1 generates an 8-second vertical video with motion and audio Receive your scroll-stopping marketing video automatically Perfect for creating engaging vertical content without expensive tools or editing expertise. How it works Input → User sends product photo via Telegram with optional caption AI Analysis → Nano Banana analyzes product and generates detailed enhancement prompt Image Enhancement → Nano Banana creates commercial-grade photo (9:16, studio lighting) Video Generation → Veo 3.1 creates 8-second 1080p video with motion and audio Delivery → Auto-polls status every 30s, delivers final video to Telegram Requirements Google Cloud Platform Vertex AI API enabled for Veo 3.1 Generative Language API enabled for Nano Banana OAuth2 credentials Get credentials from Google Cloud Console Telegram Bot token from @BotFather n8n Self-hosted or cloud instance Setup Import workflow JSON into n8n Add credentials: Telegram API (bot token) Google OAuth2 API (client id and secret) Google PaLM API (API key) Update your Project ID in both Veo 3.1 nodes Activate workflow and test with a product photo How to customize Aspect Ratio: Choose 9:16 (vertical), 16:9 (horizontal) in "Generate Enhanced Image" and "Initiate veo 3.1" nodes Duration: Set 2 to 8 seconds by adjusting durationSeconds in "Initiate veo 3.1 Video Generation" Quality: Select 720p or 1080p by changing resolution in "Initiate veo 3.1 Video Generation" Audio: Enable or disable background music by toggling generateAudio in "Initiate veo 3.1 Video Generation" Enhancement Style: Match your brand aesthetic by editing the prompt in "AI Design Analysis" node Polling Time: Adjust retry interval by changing wait time in "Processing Delay (30s)" node Key Features 🔐 Direct Google APIs – No third-party services. Uses Nano Banana and Veo 3.1 directly via Google Cloud for maximum reliability and privacy ⚡ Fully Automated – Send photo, receive video. Zero manual work required 🎨 Studio Quality – Nano Banana delivers professional lighting, composition, and AI-powered color grading 📱 Mobile-First – Default 9:16 vertical format optimized for Instagram Reels, TikTok, and Stories 🔄 Smart Retry Logic – Automatically polls Veo 3.1 status every 30 seconds until video generation completes 🎵 Audio Included – Veo 3.1 generates background music automatically (can be disabled)
By Roshan RamaniWhatsApp expense tracker with PostgreSQL database & AI-powered reports
Track Personal Finances with WhatsApp and AI Assistant Transform your WhatsApp into a powerful personal finance command center. This AI-powered workflow converts natural language messages into structured financial data, automates record-keeping, and delivers instant insights—all within your favorite messaging app. Who is this for? This template is perfect for: Personal finance enthusiasts who want effortless expense tracking Small business owners managing personal and business expenses Freelancers tracking income and expenses across projects Anyone who prefers messaging over complex finance apps Users seeking privacy with self-hosted financial data What problem is this workflow solving? Traditional expense tracking requires switching between apps, manual data entry, and complex spreadsheets. Most people abandon these systems within weeks. This workflow solves the friction by: Eliminating app-switching—everything happens in WhatsApp Converting natural language to structured data automatically Providing instant confirmations and reports Requiring zero learning curve or behavior change What this workflow does Smart Transaction Processing Send natural messages like Spent 300 on groceries at Walmart and the AI automatically extracts: Date: Today's date (or specified date) Category: Groceries Type: Expense/Income/Debt Amount: 300 Person/Company: Walmart Intelligent Message Classification The workflow automatically routes messages to three processing branches: Branch 1: Reports and analytics (show March expenses) Branch 2: Transaction logging (spent 50 on coffee) Branch 3: General financial chat (how can I save money?) Advanced Reporting Generate instant reports by messaging: today's report → Daily income/expense summary March vs April report → Monthly comparisons with percentages show groceries spending → Category-specific analysis Automatic daily summaries at your preferred time Database Integration All transactions are stored in PostgreSQL with proper schema: sql CREATE TABLE financial_transactions ( date DATE NOT NULL, category TEXT NOT NULL, type TEXT NOT NULL, amount NUMERIC(12,2) NOT NULL, person TEXT ); Setup Prerequisites n8n instance (self-hosted or n8n.cloud) WhatsApp Business Cloud API credentials PostgreSQL database (version 12+) OpenRouter API key for AI processing Quick Setup Steps Import the workflow template into your n8n instance Configure credentials: WhatsApp Business Cloud API (App Token + Phone Number ID) PostgreSQL connection details OpenRouter API key for AI processing Create database table using the provided SQL schema Test the connection by sending a sample message Customize the scheduled report timing (default: 8 AM daily) Verification Checklist [ ] WhatsApp webhook receives messages [ ] AI correctly parses transaction messages [ ] Database insertions work properly [ ] Confirmation messages are sent back [ ] Reports generate with accurate data How to customize this workflow to your needs AI Model Configuration Default: Uses OpenRouter with GPT-3.5-turbo for cost efficiency Upgrade: Switch to GPT-4 or Claude for better accuracy Local: Replace with self-hosted Ollama for complete privacy Database Options PostgreSQL: Recommended for production use Google Sheets: Alternative for simpler setups (nodes included) MySQL/SQLite: Easily adaptable with minor SQL modifications Message Classification Customize the classification system: 0: Reports (modify SQL queries for different analytics) 1: Transactions (adjust parsing rules for your language/currency) 2: Chat (customize AI responses for financial advice) Reporting Customization Scheduled reports: Change timing, format, and recipients Custom periods: Add quarterly, yearly, or custom date ranges Categories: Modify auto-categorization rules for your spending patterns Currency: Update formatting for your local currency Advanced Features Multi-user support: Add user identification for family/team use Receipt photos: Extend workflow to process image receipts via OCR Budgets: Add budget tracking and overspend alerts Integrations: Connect to banks via Plaid or other financial APIs Complete Package Included When you download this template, you get everything needed for immediate implementation: Ready-to-Use n8n Workflow Fully configured nodes with descriptive names explaining each step Color-coded sticky notes throughout the workflow explaining: What each branch does (Reports/Transactions/Chat) How the AI classification works Database connection requirements Error handling and troubleshooting tips Comprehensive Documentation Bundle Quick Start Guide: Get running in under 10 minutes Detailed Setup Guide: Complete configuration walkthrough with screenshots Branch Explanation Guide: Deep dive into each processing branch: Branch 0: Reports & Analytics - SQL queries and formatting Branch 1: Transaction Processing - AI parsing and database insertion Branch 2: Financial Chat - AI responses and conversation handling Built-in Workflow Documentation Sticky notes at every major step explaining the logic Node descriptions that clarify what each component does Visual flow indicators showing message routing paths Dependency callouts highlighting required credentials and connections Technical Implementation Details Database schema with complete SQL commands API configuration examples for all external services Troubleshooting checklist for common setup issues Performance optimization recommendations Bonus Resources Example message templates to test each workflow branch Sample data for testing reports and analytics Customization recipes for common modifications Integration patterns for extending functionality Example Usage Log Expenses: Spent 1200 on rent this month Paid 45 for gas at Shell Coffee 5.50 at Starbucks Log Income: Received 5000 salary from Company ABC Freelance payment 800 from Client XYZ Generate Reports: today's summary show this week's expenses compare March vs April spending how much on food this month? Expected Responses: ✅ Logged: expense | Rent | ₹1,200.00 | Landlord ✅ Logged: income | salary |₹12,000.00|company 📊 Today's Summary: Income: ₹0.00 Expenses: ₹1,245.50 Savings: -₹1,245.50 📈 March vs April: Expenses: ₹15,000 vs ₹12,500 (-16.7%) Top categories: Rent, Food, Transport
By Roshan RamaniNano banana AI product image creator via WhatsApp
Nano Banana AI Product Image Creator via WhatsApp Transform ordinary product photos into premium marketing visuals instantly using Gemini AI for prompt enhancement and Nano Banana AI for image generation through WhatsApp. Who's it for Small business owners E-commerce sellers Social media managers Anyone selling products online What it does • Takes your normal product photo • Gets your text/caption as input • Gemini AI improves your basic prompt into professional instructions • Nano Banana AI generates new premium ad image using enhanced prompt • Keeps your original product exactly the same • Returns social media-ready marketing image Key Benefits Smart Prompt Enhancement - Gemini AI makes your simple text into professional prompts Superior Image Generation - Nano Banana AI creates premium visuals Original Product Protected - Your product stays 100% unchanged Fast Results - Get enhanced image in under 60 seconds Easy to Use - Just send photo via WhatsApp Social Media Ready - Perfect for Instagram, Facebook, ads How it works Send Photo + Caption → Upload product image with your text AI Prompt Magic → Gemini AI turns your caption into professional prompt Image Generation → Nano Banana AI creates new premium ad using improved prompt Receive Result → Get marketing-ready image back instantly The Magic Process Your Input: "Make this look premium for Instagram" Gemini AI Enhanced Prompt: "Create luxury product advertisement with professional studio lighting, marble background, elegant typography, commercial photography style, high-end visual appeal..." Nano Banana AI Generated Result: Professional marketing image created with your improved prompt What you get • Better Prompts - Gemini AI turns simple text into detailed instructions • Professional Images - Studio-quality marketing visuals generated by Nano Banana AI • Same Product - Your original item stays unchanged • Quick Results - Ready in under 60 seconds Perfect for Instagram posts Facebook ads Online store images Social media marketing Why This Combo Works Best Gemini AI - Expert at understanding and enhancing text prompts Nano Banana AI - Specialized for high-quality product image generation Best of Both - Combines prompt expertise with image generation power Faster Results - Optimized dual-AI workflow Perfect solution for creating professional product ads from simple WhatsApp messages using the power of both Gemini AI and Nano Banana AI.
By Roshan RamaniDaily Email Digest with AI Summarization using Gmail, OpenRouter and LangChain
📧 Morning Mail Summary Ai Agent Simplify your mornings with this automated email summary workflow in n8n, designed for teams and individuals who want a quick, actionable snapshot of their inbox—every day, at a glance. 📌 Features Fully Automated: Triggers daily at 8 AM IST Targeted Extraction: Fetches messages from specific senders with dynamic date filtering Structured Data Aggregation: Pulls key fields (sender, recipients, snippet) AI-Powered Summarization: Uses LangChain + OpenRouter to generate: Insightful summaries Highlighted issues Assigned action items Memory-Enhanced Context: Maintains continuity across days Stylish HTML Email Output: Responsive design with: Summary section Action items Branded footer Team-Ready Sharing: Auto-distributes to team with CC support 🛠️ How It Works Trigger: Daily schedule in n8n Fetch: Retrieves last 24h emails from target sender Organize: Aggregates email metadata Summarize: AI agent produces structured report: Key updates Critical issues Actionable tasks Send: Emails digest to team 🎯 Ideal For Project managers needing stakeholder briefings Customer success teams tracking communications Leadership staying informed efficiently Anyone streamlining email review 📦 Included Resources Complete n8n workflow JSON (6 nodes) Prompt template for structured summarization (Summary, Issues, Actions, Follow‑Ups). -Styled HTML email template, with responsive design and branding sections. 🆓 Get Started Import JSON into n8n Configure: Gmail / OpenRouter credentials Recipient lists Custom prompts Modify freely for your use case --- ⭐ Benefits ⏳ Time saved: Skip inbox digging 🔍 Focus: See only what matters ✨ Clarity: Structured tasks & deadlines 🔄 Consistency: Daily alignment for teams
By Roshan RamaniWebsite lead management: Send contact form submissions to WhatsApp & Google Sheets
Who's it for Business owners, marketers, and web developers who want to instantly respond to website contact form submissions and maintain organized lead records without manual monitoring. What it does This workflow automatically processes contact form submissions from your website, sending immediate WhatsApp notifications with formatted lead details while simultaneously logging all data to Google Sheets for organized lead management and follow-up tracking. How it works When someone submits your website contact form, the webhook instantly receives the data, formats it into a professional WhatsApp message with emojis and structure, sends the notification to your phone, and logs all details (name, email, phone, service, message, timestamp) to a Google Sheets database for permanent storage and analysis. Requirements WhatsApp Business API credentials Google Sheets API access with a spreadsheet containing these columns: date (for timestamp) name (contact's full name) email (contact's email address) phone (contact's phone number) service (requested service/interest) message (contact's message/inquiry) Website contact form that can POST to webhook URL with fields: name, email, phone, service, message n8n instance (self-hosted or cloud) Google Sheets Setup Create a new Google Sheet with the following column headers in row 1: Column A: date Column B: name Column C: email Column D: phone Column E: service Column F: message The workflow will automatically populate these columns with each form submission and use the date column for duplicate checking. How to set up Credentials Setup: Configure WhatsApp Business API credentials in the WhatsApp node Set up Google Sheets API connection and grant necessary permissions Configuration: Update the recipient phone number in the WhatsApp node (format: +1234567890) Replace the Google Sheets document ID with your spreadsheet ID Ensure your Google Sheet has the required column structure mentioned above Integration: Copy the webhook URL from the Contact Form Trigger node Configure your website form to POST data to this endpoint with field names: name, email, phone, service, message Testing: Test the workflow by submitting a sample form entry Verify WhatsApp notification is received and data appears in Google Sheets How to customize the workflow Message Format: Modify the WhatsApp message template in the Format Lead Data node Additional Fields: Add more form fields by updating both the Code node and Google Sheets mapping Email Notifications: Include email alerts by adding an Email node after the Format Lead Data node Conditional Logic: Set up different notifications for high-priority services or VIP customers Data Validation: Add filtering rules in the Code node to handle spam or invalid submissions Multiple Recipients: Configure the WhatsApp node to send alerts to multiple team members
By Roshan RamaniWhatsApp expense tracker with multi-input (text, image & audio)
Description CashMate – Your AI-Powered WhatsApp Finance Agent Turn WhatsApp into a smart finance assistant that auto-registers you, logs transactions in natural language, extracts data from receipts and voice notes, and delivers instant report summaries—no apps, no charts, just lightning-fast insights in chat. Who is this for? Personal finance enthusiasts wanting effortless expense tracking Freelancers & solopreneurs juggling multiple incomes and expenses Small business owners needing quick bookkeeping on the go Busy professionals who prefer messaging over apps Privacy-minded users who host data on their own PostgreSQL What problem does this solve? Zero onboarding friction: Just send "Hi"—no forms, no sign-ups No app switching: Track everything right inside WhatsApp Manual entry eliminated: Natural-language, image, and voice input all auto-parsed Instant summaries: On-demand report requests—no dashboards to navigate How it works Auto-Registration New users: "Hi" → Creates your profile in PostgreSQL Returning users: Bypasses creation if your number already exists Intent Classification routes every message into one of five branches: Reports & Summaries Triggers on keywords like "today's report," "show May vs June," or "summary." Returns concise text summary of income, expenses, and net balance. Natural-Language Transactions Messages like "Give 200 to Mukesh for car repair" → AI extracts date, category, amount, payee → logs it. Receipt OCR Attach a receipt image → Gemini OCR node reads line-items → AI categorizes and logs. Voice-Driven Logging Send a voice note → Deepgram node transcribes → AI logs transaction. General Chat & Greetings "Hi," "Hello," or casual finance questions → Routed to chat branch for greetings or tips. Setup Prerequisites n8n instance (self-hosted or n8n.cloud, v1.0+) WhatsApp Business Cloud API credentials PostgreSQL database (host, port, user, password) OpenRouter/OpenAI API key for NLP Gemini API key for OCR Deepgram API key for voice transcription Quick Start Import CashMate.n8n.json into n8n. Rename nodes to suit your environment. Configure Credentials in n8n's Credentials section—avoid hard-coding keys. Activate workflow and message "Hi" from WhatsApp. Test by sending a sample expense text, image receipt, or voice note. > Note: All detailed setup instructions and deep configuration steps are provided in the sticky notes within the template. How to Customize Categories & Currencies: Edit parsing logic in the Function nodes. AI Models: Swap OpenAI/OpenRouter for GPT-4, Claude, or self-hosted alternatives. Multi-User Support: Extend registration logic to tag team or family accounts. Additional Features: Add budget alerts, multi-currency support, or bank integrations via Plaid. Example Interactions Text Transaction yaml User: 300 given to James for the coffee CashMate: ✅ Transaction Added: • Date: 2025-06-24 • Category: Coffee & Beverages • Type: Expense • Amount: ₹300.00 • Counterparty: James Receipt Image (OCR) yaml User: [sends image of café bill totaling ₹450] CashMate: ✅ Transaction Added: • Date: 2025-06-24 • Category: Coffee & Beverages • Type: Expense • Amount: ₹450.00 • Counterparty: Café Aroma Voice Transaction yaml User: [voice note: "Paid 650 rupees for office stationery"] CashMate: ✅ Transaction Added: • Date: 2025-06-24 • Category: Office Supplies • Type: Expense • Amount: ₹650.00 • Counterparty: (none)
By Roshan RamaniSmart Amazon shopping assistant with Gemini AI and Telegram
🛒 Smart Telegram Shopping Assistant with AI Product Recommendations Workflow Overview Target User Role: E-commerce Business Owners, Affiliate Marketers, Customer Support Teams Problem Solved: Businesses need an automated way to help customers find products on Telegram without manual intervention, while providing intelligent recommendations that increase conversion rates. Opportunity Created: Transform any Telegram channel into a smart shopping assistant that can handle both product queries and customer conversations automatically. --- What This Workflow Does This workflow creates an intelligent Telegram bot that: 🤖 Automatically detects whether users are asking about products or just chatting 🛒 Scrapes Amazon in real-time to find the best matching products 🎯 Uses AI to analyze and rank products based on price, ratings, and user needs 📱 Delivers perfectly formatted recommendations optimized for Telegram 💬 Handles casual conversations professionally when users aren't shopping Real-World Use Cases E-commerce Support: Reduce customer service workload by 70% Affiliate Marketing: Automatically recommend products with tracking links Telegram Communities: Add shopping capabilities to existing channels Product Discovery: Help customers find products they didn't know existed --- Key Features & Benefits 🧠 Intelligent Intent Detection Uses Google Gemini AI to understand user messages Automatically routes to product search or conversation mode Handles multiple languages and casual typing styles 🛒 Real-Time Product Data Integrates with Apify's Amazon scraper for live data Fetches prices, ratings, reviews, and product details Processes up to 10 products per search instantly 🎯 AI-Powered Recommendations Analyzes multiple products simultaneously Ranks by relevance, value, and user satisfaction Provides top 5 personalized recommendations with reasoning 📱 Telegram-Optimized Output Perfect formatting with emojis and markdown Respects character limits for mobile viewing Includes direct purchase links for easy buying --- Setup Requirements Required Credentials Telegram Bot Token - Free from @BotFather Google Gemini API Key - Free tier available at AI Studio Apify API Token - Free tier includes 100 requests/month Required n8n Nodes @n8n/n8n-nodes-langchain (for AI functionality) Built-in Telegram, HTTP Request, and Code nodes --- Quick Setup Guide Step 1: Telegram Bot Creation Message @BotFather on Telegram Create new bot with /newbot command Copy the bot token to your credentials Step 2: AI Configuration Sign up for Google AI Studio Generate API key for Gemini Add credentials to all three AI model nodes Step 3: Product Scraping Setup Register for free Apify account Get API token from dashboard Add token to "Amazon Product Scraper" node Step 4: Activation Import workflow JSON Add your credentials Activate the Telegram Trigger Test with a product query! --- Workflow Architecture 📱 Message Entry Point Telegram Trigger receives all messages 🧹 Query Preprocessing Cleans and normalizes user input for better search results 🤖 AI Intent Classification Determines if message is product-related or conversational 🔀 Smart Routing Directs to appropriate workflow path based on intent 💬 Conversation Path Handles greetings, questions, and general support 🛒 Product Search Path Scrapes Amazon → Processes data → AI analysis → Recommendations 📤 Optimized Delivery Formats and sends responses back to Telegram --- Customization Opportunities Easy Modifications Multiple Marketplaces: Add eBay, Flipkart, or local stores Product Categories: Specialize for electronics, fashion, etc. Language Support: Translate for different markets Branding: Customize responses with your brand voice Advanced Extensions Price Monitoring: Set up alerts for price drops User Preferences: Remember customer preferences Analytics Dashboard: Track popular products and queries Affiliate Integration: Add commission tracking links --- Success Metrics & ROI Performance Benchmarks Response Time: 3-5 seconds for product queries Accuracy: 90%+ relevant product matches User Satisfaction: 85%+ positive feedback in testing Business Impact Reduced Support Costs: Automate 70% of product inquiries Increased Conversions: Personalized recommendations boost sales 24/7 Availability: Never miss a customer inquiry Scalability: Handle unlimited concurrent users --- Workflow Complexity Intermediate Level - Requires API setup but includes detailed instructions. Perfect for users with basic n8n experience who want to create something powerful.
By Roshan RamaniAutomate email responses with OpenAI and Telegram approval for Gmail
Overview An intelligent email automation workflow that revolutionizes how you handle email responses. This sophisticated system monitors your Gmail inbox, uses AI to determine which emails require replies, generates professional responses, and sends them only after your approval via Telegram. Perfect for busy professionals who want to maintain personalized communication while leveraging AI efficiency. 🌟 Key Features Intelligent Email Analysis Smart Detection: Automatically identifies emails that genuinely need responses Context Understanding: Distinguishes between promotional content, newsletters, and actionable emails Priority Filtering: Focuses on emails with questions, requests, or time-sensitive matters AI-Powered Response Generation Professional Tone: Maintains appropriate business communication standards Contextual Replies: Generates responses based on email content and context Structured Output: Creates properly formatted subject lines and email bodies Customizable Prompts: Easily adjust AI behavior to match your communication style Human-in-the-Loop Approval Telegram Integration: Review and approve responses directly from your mobile device Visual Preview: See both original email and AI-generated response before sending Dual Approval System: Approve or reject with simple Telegram buttons Timeout Protection: Automatically expires after 5 minutes to prevent accidental sends 🔧 How It Works Workflow Architecture Email Monitoring: Continuous Gmail inbox surveillance (every minute) Inbox Filtering: Processes only emails in your main inbox folder AI Analysis: Determines response necessity using advanced language models Response Generation: Creates professional, contextual replies when needed Telegram Notification: Sends preview to your Telegram for approval Conditional Sending: Executes email send only upon your explicit approval Decision Logic The AI evaluates emails based on: Question Detection: Identifies direct questions requiring answers Action Requests: Recognizes requests for information or tasks Urgency Assessment: Prioritizes time-sensitive communications Context Analysis: Considers sender, subject, and content relevance 🚀 Setup Requirements Prerequisites Gmail Account: With OAuth2 authentication enabled OpenAI API Key: For AI language model access Telegram Bot: Personal bot token and chat ID N8N Instance: Cloud or self-hosted environment Required Credentials Gmail OAuth2 credentials OpenAI API authentication Telegram bot token and chat configuration 📊 Use Cases Business Applications Customer Support: Automated responses to common inquiries Sales Teams: Quick replies to prospect questions Account Management: Timely responses to client communications HR Operations: Efficient handling of employee inquiries Personal Productivity Email Management: Reduce inbox overwhelm Professional Communication: Maintain consistent response quality Time Management: Focus on high-priority tasks while AI handles routine replies Mobile Workflow: Approve emails anywhere via Telegram ⚙️ Customization Options AI Behavior Tuning Response Style: Adjust tone from formal to casual Content Filters: Modify email analysis criteria Response Length: Control reply brevity or detail level Language Patterns: Customize communication style Workflow Modifications Polling Frequency: Adjust email checking intervals Approval Timeout: Modify decision time limits Multi-Account Support: Extend to multiple Gmail accounts Category Routing: Different handling for different email types 🔒 Security & Privacy Data Protection Local Processing: All email analysis occurs within your N8N instance No Data Storage: Email content is not permanently stored Secure Authentication: OAuth2 and API key protection Encrypted Communication: Secure Telegram API integration Access Control Personal Approval: You control every outgoing message Audit Trail: Complete workflow execution logging Fail-Safe Design: Defaults to no action if approval isn't received 📈 Performance & Reliability Efficiency Metrics Processing Speed: Sub-second email analysis Accuracy: High-quality response generation Reliability: Robust error handling and retry mechanisms Scalability: Handles high email volumes efficiently Resource Usage Lightweight Operation: Minimal server resource consumption API Optimization: Efficient OpenAI token usage Rate Limiting: Respects Gmail and Telegram API limits 💡 Best Practices Optimization Tips Monitor AI Responses: Regularly review and refine AI prompts Approval Patterns: Establish consistent approval workflows Response Templates: Create reusable response patterns Performance Monitoring: Track workflow efficiency metrics Common Configurations Business Hours: Limit processing to working hours VIP Senders: Priority handling for important contacts Subject Filters: Custom rules for specific email types Escalation Rules: Forward complex emails to human review 🏆 Benefits Productivity Gains Time Savings: Reduce manual email composition time by 60-80% Consistency: Maintain professional communication standards Responsiveness: Faster reply times improve customer satisfaction Focus: Concentrate on high-value tasks while AI handles routine communications Professional Advantages Always Available: Respond to emails even when busy Quality Assurance: AI ensures grammatically correct, professional responses Scalability: Handle increasing email volumes without proportional time investment Competitive Edge: Faster response times improve business relationships --- Tags: Email Automation, AI Assistant, Gmail Integration, Telegram Bot, Workflow Automation, OpenAI, Business Productivity, Customer Service, Response Management, Professional Communication
By Roshan RamaniTwitter Keyword & Public-Figure Monitor with Automated Airtable Archiving
Monitor & Archive Keyword Tweets to Airtable 📌 Overview Automatically searches Twitter for any keyword/topic (person, brand, hashtag), filters duplicates, and stores new tweets in Airtable with rich metadata - all on a daily schedule. 🛠️ Workflow Steps ⏰ Schedule Trigger Runs daily at 8 AM (customizable) 🐦 Twitter Search Fetches 100 latest tweets matching your keyword 📦 Reformat Data Structures: Text | Likes | ID | URL Author | Timestamp 🗂️ Fetch Airtable Records Retrieves existing tweet IDs 🔍 Deduplicate Compares IDs to exclude duplicates ➕ Append New Tweets Saves only fresh entries to Airtable 💡 Key Benefits 🤖 Automated Monitoring: Near real-time tracking 🧹 Clean Data: Zero duplicate entries 📁 Structured Archive: Organized metadata for analysis ⚙️ Fully Customizable: Adapt keywords/schedule/output 🧩 Perfect For Social media analysts tracking brand mentions Journalists monitoring public figures Researchers archiving topic conversations Marketing teams measuring campaign reach 🚀 Getting Started Import into n8n Connect Credentials: Twitter API keys Airtable base + table ID Configure: Search keyword (e.g., "Narendra Modi") Schedule timing Run & Forget: Initial run to backfill Daily auto-archiving ✅ Enhancement Ideas Add Filters: Exclude retweets Filter by language Geolocation targeting Notifications: Slack alerts for new tweets Email digests AI Extensions: Sentiment analysis Auto-categorization Trend reporting
By Roshan RamaniGenerate professional product advertisements with Nano Banana Pro via Telegram
Nano Banana Pro AI Product Advertisement Generator via Telegram Who's It For E-commerce businesses needing quick product ads Social media marketers without design resources Small business owners creating promotional content Product photographers seeking automated enhancements What It Does Transforms basic product photos into professional advertisements using AI. Users send a product image with caption text via Telegram, and receive commercial-grade ads with studio lighting, premium backgrounds, and typography overlays. How It Works User sends product photo with caption to Telegram bot Image converted to base64 for AI processing Google Gemini analyzes image and extracts marketing text from caption AI generates detailed design enhancement instructions (400+ words) Nano Banana Pro creates 1-2 professional advertisement versions Enhanced images automatically sent back to user Requirements Telegram Bot API credentials (via BotFather) Google Gemini API key with nano-banana-pro-preview access n8n instance (self-hosted or cloud) Setup Instructions Create Telegram Bot Message BotFather on Telegram Send /newbot command and follow prompts Copy the API token Configure n8n Credentials Add Telegram Bot API token Add Google Gemini API key Import workflow JSON Update credential references Activate workflow Test the Workflow Send image with caption format: "Product Name | Tagline | Call to Action" Example: "Premium Sneakers | Mountain Edition | Shop Now" Key Features Original product remains 100% unchanged Text extracted only from user's caption (no AI-generated taglines) Professional design enhancements applied Studio-quality lighting and color grading Luxury background selection based on product category Typography overlays using caption text 30-60 second processing time Returns 1-2 advertisement variants Node Breakdown Telegram Trigger - Listens for messages with images Download Image File - Retrieves image from Telegram servers Image to Base64 - Converts image for AI processing AI Design Analysis - Gemini extracts caption text and generates design blueprint covering composition, lighting, backgrounds, color grading, effects, and typography Combine Image & Analysis - Merges image data with design instructions Prepare API Payload - Structures data for Nano Banana Pro API Generate Enhanced Image - Creates professional ad using AI Convert Base64 to Image - Converts first generated ad to file Convert Base64 to Image1 - Converts second ad variant (if available) Send Image - Returns enhanced ads to user via Telegram Customization Options Adjust Design Style Modify AI Design Analysis prompt to change lighting intensity, background preferences, color grading, or typography styles Change Caption Parsing Update extraction rules for different text elements or multi-language support Add Output Formats Request different aspect ratios (16:9 social media, 4:5 Instagram, 9:16 Stories) Error Handling Add fallback nodes to handle image generation failures Usage Analytics Insert database node to track requests and caption data Caption Examples "NIKE AIR MAX | Run Beyond Limits | Shop Now" "Himalayan Coffee Beans - Fresh from the Mountains - Order Today" "Luxury Smartwatch | Track Your Success | Available Now" Important Notes Product never altered, only enhanced visually Empty captions result in ads without text overlays Best with clear photos on simple backgrounds Monitor API quotas to avoid rate limits Processing time varies by API response speed
By Roshan RamaniTalentFlow AI – Instantly evaluate applicant's GitHub, LinkedIn, using AI
AI-Powered Job Application Screening Workflow Who Is This For? This template is ideal for: HR teams Recruiters Hiring managers Who want to automate the screening of job applicants. If you collect candidate data via JotForm and want an AI‑powered, multi‑source evaluation—without manual copy‑paste—this workflow is for you. What Problem Does This Solve? Manually reviewing: LinkedIn profiles GitHub repos LeetCode stats Resume PDFs Is time‑consuming and error‑prone. This workflow: Centralizes all candidate data Scores each dimension against specific job requirements Appends results to Google Sheets Helps make data‑driven hiring decisions faster What This Workflow Does Trigger on New JotForm Submission Captures candidate name, email, social URLs, resume link, and job description (Pro Tip: Add hidden field in JotForm to pass job requirements) Extract & Normalize Usernames Parses LinkedIn, GitHub, and LeetCode handles Scrape & Format Data LinkedIn → profile & latest posts via ScrapingDog & Apify GitHub → profile, repos, and contribution metrics via GitHub GraphQL LeetCode → submission stats & rankings via LeetCode GraphQL Resume → converts PDF to text with PDF.co AI‑Powered Evaluation Uses LangChain agents on OpenRouter to: Generate fit scores (1–10) based on job description Provide justifications for each source Analyze candidate suitability against specific role requirements Merge & Append Consolidates scores and feedback → writes new row to Google Sheets with hyperlinks and totals Setup JotForm Configuration Create your job application form Add Hidden Field: Name: job_description Value: [Paste full job description here] (This enables AI to evaluate candidates against specific role requirements) Create fields matching the workflow requirements Required Credentials/Variables JotForm API key SCRAPINGDOGAPIKEY & Apify token GitHub personal access token (read‑only) PDF.co API key OpenRouter API key Configuration Steps Google Sheets Create or select spreadsheet Grant n8n access Node Organization All nodes renamed for clarity Sticky notes explain prerequisites How to Customize Job-Specific Evaluation Include hidden job_description field in JotForm AI will automatically analyze candidates against these requirements Add/Edit Fields Use Edit Fields node to map your form questions Adjust Scoring Tweak agent prompts: linkedin evaluation github evaluation etc. Extend Sources Insert new branches (e.g., Stack Overflow) by following existing patterns Result Transforms raw candidate submissions into actionable insights—evaluating applicants against specific job requirements and reducing screening time from hours to minutes with consistent, unbiased evaluations.
By Roshan RamaniAutomate employee birthdays & work anniversaries with Google Gemini and Slack
Replace BillyBot: Free Slack Employee Birthday & Anniversary Automation Who's it for HR teams, team leaders, and operations managers looking to automate employee celebrations without expensive third-party tools like BillyBot. Perfect for startups to enterprise teams wanting to save $600-2,400+ annually while maintaining personalized, engaging employee recognition. What it does This workflow automatically monitors your employee database daily and posts AI-generated, unique celebration messages to Slack for birthdays and work anniversaries. Unlike generic bots, it creates personalized messages that never repeat, rotating through 12 different styles and tones to keep celebrations fresh and authentic. How it works Daily Check: Runs every morning at 9 AM to scan your employee Google Sheet Smart Filtering: Matches today's date against employee birthdays and joining dates Data Aggregation: Collects all celebrating employees into a single payload AI Generation: Google Gemini creates unique, heartfelt messages with proper Slack formatting Auto-Post: Sends personalized celebrations directly to your chosen Slack channel The AI ensures no two messages feel templated, calculating years of service for anniversaries and adapting tone based on tenure length. Requirements Google Sheets with employee data (columns: NO, Name, Email, Date of Birth, Joining Date in YYYY-MM-DD format) Slack workspace with bot permissions to post messages Google Gemini API key (free tier included) n8n Cloud ($20/month) or self-hosted n8n (free) Cost comparison: Save $600-2,400+ per year BillyBot pricing: $1 per employee/month 50 employees = $600/year 100 employees = $1,200/year 200 employees = $2,400/year This solution: $0-20/month (unlimited employees) Google Gemini API: FREE Google Sheets API: FREE Slack API: FREE n8n: $20/month (Cloud) or $0 (self-hosted) Your savings: 95-100% cost reduction regardless of team size. Setup instructions Create Google Sheet: Add columns: NO, Name, Email, Date of Birth, Joining Date (ensure dates are YYYY-MM-DD format) Connect Google Sheets: Authenticate your Google account in the "Get row(s) in sheet" node Set up Slack: Create a Slack bot with chat:write permission and add to your celebration channel Configure Gemini: Add your Google Gemini API key to the "Google Gemini Chat Model" node Adjust Schedule: Change trigger time in "Schedule Trigger" node (default: 9 AM daily) Select Channel: Update Slack channel in "Send a message" node to your desired celebration channel Test: Run workflow manually to verify messages post correctly Customization options Change celebration time: Modify the Schedule Trigger to any hour (e.g., 8 AM for morning celebrations) Adjust message tone: Edit the AI Agent system prompt to match your company culture (formal, casual, playful) Multi-channel posting: Duplicate the Slack node to post to multiple channels (e.g., company-wide + team-specific) Add upcoming reminders: Modify the IF node to check for celebrations within 7 days Include photos: Extend the workflow to pull employee photos from your HR system Custom emoji styles: Update the AI prompt to use your organization's custom Slack emojis Key features 12 rotating message styles prevent repetition Automatic tenure calculation for work anniversaries Culturally inclusive and professional tone Mobile-optimized message length (1-3 lines) Slack markdown formatting for visual appeal Scales infinitely without additional cost --- Note: Ensure your Google Sheet date formats are consistent (YYYY-MM-DD) for accurate date matching. The workflow processes dates in MM-DD format to match across years automatically.
By Roshan Ramani